Newbie PHP/MySQL problem

Codewalkers Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

May 23rd, 2003, 08:06 PM

Anonymous

Registered User

Codewalkers God 35th Plane (22000 - 22499 posts)

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

Newbie PHP/MySQL problem

Hi, I'm learning how to run PHP/MySQL from tutorials on this site. They're really great. I was using one of the given examples, which I'd modified for my database. The problem is that when I access the PHP file, it doesn't return a darn thing. Just a white page. What did I screw up?

php Code:

Original - php Code

<?php
$db = mysql_connect(xxxxxxxxxx);
mysql_select_db("Honor_Bios",$db); 
 
$first_name=$_GET[first_name];
$last_name=$_GET[last_name];
$hometown=$_GET[hometown];
$age=$_GET[age];
$major=$_GET[major];
$anything=$_GET[anything];
$id=$_GET[id];
 
$result = mysql_query("SELECT * FROM Freshmen",$db); 
echo "<TABLE BORDER=2>"; 
echo "<TR><TD><B>Full Name</B><TD><B>Nick Name</B><TD><B>Options</B></TR>"; 
while($myrow = mysql_fetch_array($result)) 
{ 
echo "<TR><TD>".$myrow["first_name"]." ".$myrow["last_name"]."<TD>".$myrow["major"]; 
echo "<TD><a href=
Warning: Unexpected character in input: '' (ASCII=92) state=1 in /www/codewalkers.com/www/tutorials.php on line 164
"view.php?id=".$myrow[id]."">View</a>"; 
} 
echo "</TABLE>"; 
?>

May 27th, 2003, 11:25 AM

Jester

Join Date: Apr 2007

Location: England

Posts: 271

Time spent in forums: < 1 sec
Reputation Power: 2

RE: Newbie PHP/MySQL problem

Are you sure that the mysql connection and db select is working?

Try changing second line to something like:

php Code:

Original - php Code
if ($db) { mysql_select_db($mysqldbname) or die("Could not select database"); } else { echo " <html> <head> <title>No Connection Available</title> </head> <body> <p>A connection to the database server is not possible at the current time. Please try again later.</p> </body> </html>n "; exit(); }

 
 
if ($db) {
  mysql_select_db($mysqldbname) or die("Could not select     database");
 
} else {
  echo "
    <html>
    <head>
    <title>No Connection Available</title>
    </head>
    <body>
    <p>A connection to the database server is not possible at the current time.
    Please try again later.</p>
    </body>
    </html>n
    ";
    exit();
}

This will tell you if the db server is not letting you in, or if the db cannot be selected.

J

May 27th, 2003, 07:50 PM

Anonymous

Registered User

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

RE: Newbie PHP/MySQL problem

Well, I completely cropped the rest of my php script out and put your code in. This is my code:

php Code:

Original - php Code
<HTML> <BODY> <?php $db = mysql_connect("xxxxxxxxx", "xxxxxxx", "xxxxxxxxxx"); if ($db) { mysql_select_db("Honor_Bios",$db) or die("Could not select database"); } else { echo " <html> <head> <title>No Connection Available</title> </head> <body> <p>A connection to the database server is not possible at the current time. Please try again later.</p> </body> </html>n "; exit(); } ?> </BODY> </HTML>

<HTML>
<BODY>
<?php 
$db = mysql_connect("xxxxxxxxx", "xxxxxxx", "xxxxxxxxxx");
if ($db) {
  mysql_select_db("Honor_Bios",$db) or die("Could not select     database");
 
} else {
  echo "
    <html>
    <head>
    <title>No Connection Available</title>
    </head>
    <body>
    <p>A connection to the database server is not possible at the current time.
    Please try again later.</p>
    </body>
    </html>n
    ";
    exit();
}
?>
</BODY>
</HTML>

It pulls up a blank page, too. Now I'm really confused. When I View Source both this page and my other php page that wasn't working, both show <HTML><BODY></BODY></HTML> in the source and nothing more. Despite this, other PHP and MySQL scripts are working.

ARGH!

Thanks if you can help.

May 28th, 2003, 09:21 AM

Jester

Join Date: Apr 2007

Location: England

Posts: 271

Time spent in forums: < 1 sec
Reputation Power: 2

RE: Newbie PHP/MySQL problem

That's a good thing!

When php parses, it's invisible at source. What you are seeing is the <HTML><BODY></BODY></HTML> tags that you have put around your php code (remember that php does not have to be located within the <BODY> tag though - you can stick php right at the top and do your html afterwards. The only time that you would see something else from the below code is if there was a problem and the echo error or die statement come into play.

As there is nothing else being displayed it means that you are connected correctly to the db server and are allowed access to the selected db. If this was working in your first code then I suggest adding a check on your $result after running the sql like:

php Code:

Original - php Code
if (!$result) { echo 'opps'; exit(); }

 
if (!$result) {
echo 'opps';
exit();
}

to see if your sql is executing correctly. It may be that there is a problem with your $_GETs. (might be worth doing an echo $_GET['first_name']; etc for each of your variables at the top of your php to see if they are being passed correctly)

I also notice that you are using $_GET[first_name]; instead of $_GET['first_name']; this may be the cause of all your woes!

Good luck and let me know how you get on,

J

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: