access database? - PHP-Editors

atomek · #1 (**permalink**) 2006-09-18, 06:21 AM

I am a newbie to this:

To begin with, I set up an 'apache' testing server on my machine.
Then using MySQL Front I created a MySQL database from a .xls file to be hosted @ localhost
Using php script through dreamweaver was able to display through a browser, information accessed from within the MySQL database created.

Everything working afters hours of trials and tribulations......

Contacted my isp where I received information regarding access to phpMyAdmin hosted on their server...
Using phpMyAdmin I have imported the data to a table within a database created by my isp.

Table is called 'chemical' database is called 'wx110245' password '******' host 'localhost'

Updated php script to reflect this, and uploaded php file to server via ftp.

though php script is not displaying data.

script is as follows below

world is displayed but no data from the database.....

Q: once I have setup the database in phpMyAdmin is there a last process required in terms of deployment? or is there something else you can see in my process that requires change?

__________________________________________________ _____
<?php print 'world'?>
<?php
$mysqli = new mysqli('localhost','atomek','******');
$mysqli->select_db('wx110245');

$result = $mysqli->query("SELECT* FROM chemical");

while($row = $result->fetch_assoc()) {
print '<hr align="center" width="600">'.'Chemical: '.''.$row['Chemical'].''.' '.'Paints & Products: '.''.$row['Paints & Products'].''.' '.'Resins, Varnishes and Stains: '.''.$row['Resins, Varnishes and Stains'].''.' '.'Caulking/ Fillers/ Sealants etc: '.''.$row['Caulking/ Fillers/ Sealants etc'].''.' '.'Glues/ Adhesives: '.''.$row['Glues/ Adhesives'].''.' '.'Walls, Wall frames, Ceilings, Roofing: '.''.$row['Walls, Wall frames, Ceilings, Roofing'].''.' '.'Timbers: '.''.$row['Timbers'].''.' '.'Floors and Floor Coverings: '.''.$row['Floors and Floor Coverings'].''.' '.'Insulation, membranes: '.''.$row['Insulation, membranes'].''.' '.'Conduits, piping, plumbing: '.''.$row['Conduits, piping, plumbing'].''.' '.'Fixtures and furnishings: '.''.$row['Fixtures and furnishings'].''.' '.'Soft Furnishings: '.''.$row['Soft Furnishings'].''.' '.'Description: '.''.$row['Description'].''.' '.'Main component use: '.''.$row['Main component use'].''.' '.'Health concerns and other details: '.''.$row['Health concerns and other detail'].''.' '.'Sources - see information sources for details: '.''.$row['Sources - see information sources for details'].''.' '.' ';}

$result->close(); ?>
__________________________________________________ _____

vladimir_cz · #2 (**permalink**) 2006-09-18, 11:53 AM

Hi!
1st: turn on maximal error logging: error_reporing(E_ALL)
2nd: after each call of mysql* function check result value. if value is false, output errors like this:

PHP Code:


			
<?php

$mysqli = new mysqli("localhost", "my_user", "my_password", "world");



/* check connection */ 

if (mysqli_connect_errno()) {

    printf("Connect failed: %s\n", mysqli_connect_error());

    exit();

}





if (!$mysqli->query("some query")) {

        printf("Error: %s\n", $mysqli->error);

    }





?>

Xnuiem · #3 (**permalink**) 2006-09-19, 03:25 AM

Also, fix your print world....

<?ph print("world"); ?>

You forgot the semi colon.

atomek · #4 (**permalink**) 2006-09-19, 03:35 AM

Thanks vladimir for your reply,

I deleted all existing php script and entered the below, but still no response,

?????1st: turn on maximal error logging: error_reporing(E_ALL)?????? i do not understand this, could you explain a bit more, thanks
__________________________________________________ __________
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}

if (!$mysqli->query("some query")) {
printf("Error: %s\n", $mysqli->error);
}

?>
__________________________________________________ ____________

thank you for all your help.....

atomek · #5 (**permalink**) 2006-09-19, 04:27 AM

ok... i have come a little further with my issue, i am now using the following code below

page displays:
world
Fatal error: Cannot instantiate non-existent class: mysqli in /var/www/wh223306x001/html/chemiframe.php on line 26

i understand also now that the script to login may be only applicable to a newer version of php and that my isp server my be running an older version

any help on script required for login to older version would be appreciated, otherwise i will keep researching and keep you posted.
_____________________________________
<?php print ("world");

ini_set("display_errors","1");

$mysqli = new mysqli("localhost", "my_user_name", "my_password");
$mysqli->select_db('wh223306x001');

$result = $mysqli->query("SELECT* FROM chemical");

$result->close(); ?>

atomek · #6 (**permalink**) 2006-09-19, 05:40 AM

Ok, my latest

Thank you all for your help..... special shoutouts go to vladimir_cz & Xnuiem & Alan from my ISP tech support

The following script works for me & displays complete database
(replace my_* as required)

__________________________________________________ _
<?php

ini_set("display_errors","1");

// Connecting, selecting database
$link = mysql_connect('localhost', 'my_username', 'my_password')
or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
mysql_select_db('my_database') or die('Could not select database');

// Performing SQL query
$query = 'SELECT * FROM my_table';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

// Printing results in HTML
echo "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "\t<tr>\n";
foreach ($line as $col_value) {
echo "\t\t<td>$col_value</td>\n";
}
echo "\t</tr>\n";
}
echo "</table>\n";

// Free resultset
mysql_free_result($result);

// Closing connection
mysql_close($link);
?>
__________________________________________________ _____
http://au2.php.net/mysql

vladimir_cz · #7 (**permalink**) 2006-09-19, 10:25 AM

my congratilations!

2forum moderators:
May be to FAQ next sentence:

Quote:

Before create topic/post reply make sure errors displayed and error reporting level set maximal level (E_ALL)

atomek · #8 (**permalink**) 2006-09-19, 10:44 AM

cheers' vladimir,

Peace out to the 'php-editors crew'



Sponsored by NuSphere - PHP Software for PHP Application Developers - On Sale This Week for $100