Building 1st PHP script! Need HELP!

wrckhaki

I have read an introductory book on PHP 6/Mysql 5 and am using it as reference to build my code. I am trying to build a fairly basic set of code that will pull data from a mysql database. I have tried debugging the code several times, but I cannot determine what's causing the problem. 'Header.html' comes in fine, but I am seeing nothing after that. Any help would be very very appreciated. Thank you in advance.

<?php
$page_title = 'Welcome!';
include ('header.html');

// Set the database access information as constants:
DEFINE ('DB_USER', 'root');
DEFINE ('DB_PASSWORD', 'xxxxxx');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'hf');

// Make the connection:
$dbc = @mysqli_connect (DB_HOST, DB_USER, DB_PASSWORD, DB_NAME) OR die ("Unable to select database!");

$q = "SELECT name, assets, address, city, state FROM funds ORDER BY assets DESC";

$r = @mysqli_query ($dbc, $q);

echo '<table align="center" cellspacing="3" cellpadding="3" width="75%">

<tr><td align="left"><b>Name</b></td>
<td align="left"><b>Assets</b></td>
<td align="left"><b>Address</b></td>
<td align="left"><b>City</b></td>
<td align="left"><b>State</b></td></tr>
';

while ($row = mysqli_fetch_array($r,mysqli_assoc)){

echo '<tr><td align="left">' . $row['name'] . '</td>
<td align="left">' . $row['assets'] . '</td>
<td align="left">' . $row['address'] . '</td>
<td align="left">' . $row['city'] . '</td>
<td align="left">' . $row['state'] . '</td></tr>
';
}

echo '</table>';

mysqli_close($dbc);

<h1>Content Header</h1>

<p>Content</p>

<?php
include ('footer.html');
?>

NogDog

Welcome to the forums. In the future, you can help us to help you by using the forum's [noparse]

...

[/noparse] bbcode tags around your code samples.

Anyway, I would start by checking that your query was processed OK, then see if it actually returned anything:

$r = @mysqli_query($dbc, $q);
if($r == false)
{
   user_error("Query failed: " . myqli_error($dbc) . "<br />\n$q");
   // some user-friendly message here, perhaps?
}
elseif(mysqli_num_rows($r) == 0)
{
   // some output indicating no results were returned....
}

Also, if you are not seeing any error messages, you may want to enable all error-reporting for now while developing your code. Just add the following to the start of your script:

<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);

wrckhaki

NogDog, thank you very much for your help and your quick reply. The error reporting was very helpful. Things seem to be improving, but now I am getting an error because of the "mysqli_assoc" function. The error message says that it is an undefined constant. So, I am thinking that php isn't recognizing it as function. Could this be related to my version of php (which is 5.2.6)? Any additional help would be appreciated. Thank you!

NogDog

The constant's spelling is all caps: MYSQLI_ASSOC. However, you can simply use the myqli_fetch_assoc() function, instead, and not worry about any such constants.

wrckhaki

I capitalized "MYSQLI_ASSOC" and it worked! Thanks again NogDog for all your help. Much appreciated. Have a great week.