PHP, MySQL & Apache - Codewalkers

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

January 23rd, 2004, 01:51 PM

Garcia

Join Date: Apr 2007

Location: Aberdeen, Scotland

Posts: 19

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

PHP, MySQL & Apache

Hi, I've just installed Apache 2.0.48, PHP 4.3.4 and MySQL 3.23.49 on my Windows machine. I've got simple functions like phpinfo() and some code from a PHP & MySQL for Dummies book, and they both work fine - I'm getting information on PHP, and some tables from MySQL. However, a simple database interface included with the book, which has two fields, one for entering the database name, and the other for entering the query, just plain isn't working.
First up, the $PHP_SELF variable. I get the following error message:

Notice: Undefined variable: PHP_SELF in D:serverdummiesmysql_send.php on line 76
?form=yes method="post">

Okay, fair enough. I've replaced that with other variations of the same function, and the error message disappears. However, the problem of it not doing anything still stands.
To make it work, I've been told by the book to simply enter 'show databases', to display a list of all the databases. No prizes for guessing what happens (or doesn't happen).
Below is the entire code for the page, if anyone has any ideas on whats going on, please let me know so I can get back to work on my website

(installing PHP and MySQL on my machine was only as a testing area - I'm on 56k, so uploading all the time is a bit of a bother).

php Code:

Original - php Code

<html>
<head>
<title>SQL Query Sender</title>
</head>
<body>
<?php
 $user="root";
 $host="localhost";
 $password="";

/* Section that executes query */
 if (@$form == "yes")  
 {
   mysql_connect($host,$user,$password);
   mysql_select_db($database);
   $query = stripSlashes($query) ;
   $result = mysql_query($query);
   echo "Database Selected: <b>$database</b><br>
          Query: <b>$query</b>
          <h3>Results</h3>
          <hr>";
   if ($result == 0)
      echo("<b>Error " . mysql_errno() . ": " . mysql_error() . "</b>");

elseif (@mysql_num_rows($result) == 0)
      echo("<b>Query completed. No results returned.</b><br>");
   else
   {
     echo "<table border='1'>
           <thead>
            <tr>";
             for ($i = 0; $i < mysql_num_fields($result); $i++) 
             {
                 echo("<th>" . mysql_field_name($result,$i) . "</th>");
             }
     echo " </tr>
           </thead>
           <tbody>";
             for ($i = 0; $i < mysql_num_rows($result); $i++) 
             {
                echo "<tr>";
                $row = mysql_fetch_row($result);
                for ($j = 0; $j < mysql_num_fields($result); $j++) 
                {
                  echo("<td>" . $row[$j] . "</td>");
                }
                echo "</tr>";
             }
             echo "</tbody>
                  </table>";
   }
   echo "<hr><br>
         <form action=$PHP_SELF method=post>
          <input type=hidden name=query value="$query">
          <input type=hidden name=database value=$database>
          <input type=submit name="queryButton" value="New Query">
          <input type=submit name="queryButton" value="Edit Query">
         </form>";
   unset($form);
   exit();
 }

/* Section that requests user input of query */
 @$query = stripSlashes($query);
 if (@$queryButton != "Edit Query")  
 {
   $database = " ";
   $query = " ";
 }
?>

<form action=<?php echo $PHP_SELF ?>?form=yes method="post">
 <table>
  <tr>
   <td align="right"><b>Type in database name</b></td>
   <td>
     <input type=text name="database" value=<?php echo $database ?> >
   </td>
  </tr>
  <tr>
   <td align="right" valign="top"><b>Type in SQL query</b></td>
	 <td><textarea name="query" cols="60" rows="10"><?php echo $query ?></textarea>
   </td>
  </tr>
  <tr>
   <td colspan="2" align="center"><input type="submit" value="Submit Query"></td>
  </tr>
 </table>
</form>
</body>
</html>

<!-- Program Name:  mysql_send.php
     Description: PHP program that sends an SQL query to the 
                  MySQL server and displays the results.
-->
<html>
<head>
<title>SQL Query Sender</title>
</head>
<body>
<?php
 $user="root";
 $host="localhost";
 $password="";
 
 /* Section that executes query */
 if (@$form == "yes")  
 {
   mysql_connect($host,$user,$password);
   mysql_select_db($database);
   $query = stripSlashes($query) ;
   $result = mysql_query($query);
   echo "Database Selected: <b>$database</b><br>
          Query: <b>$query</b>
          <h3>Results</h3>
          <hr>";
   if ($result == 0)
      echo("<b>Error " . mysql_errno() . ": " . mysql_error() . "</b>");
 
   elseif (@mysql_num_rows($result) == 0)
      echo("<b>Query completed. No results returned.</b><br>");
   else
   {
     echo "<table border='1'>
           <thead>
            <tr>";
             for ($i = 0; $i < mysql_num_fields($result); $i++) 
             {
                 echo("<th>" . mysql_field_name($result,$i) . "</th>");
             }
     echo " </tr>
           </thead>
           <tbody>";
             for ($i = 0; $i < mysql_num_rows($result); $i++) 
             {
                echo "<tr>";
                $row = mysql_fetch_row($result);
                for ($j = 0; $j < mysql_num_fields($result); $j++) 
                {
                  echo("<td>" . $row[$j] . "</td>");
                }
                echo "</tr>";
             }
             echo "</tbody>
                  </table>";
   }
   echo "<hr><br>
         <form action=$PHP_SELF method=post>
          <input type=hidden name=query value="$query">
          <input type=hidden name=database value=$database>
          <input type=submit name="queryButton" value="New Query">
          <input type=submit name="queryButton" value="Edit Query">
         </form>";
   unset($form);
   exit();
 }
 
 /* Section that requests user input of query */
 @$query = stripSlashes($query);
 if (@$queryButton != "Edit Query")  
 {
   $database = " ";
   $query = " ";
 }
?>
 
<form action=<?php echo $PHP_SELF ?>?form=yes method="post">
 <table>
  <tr>
   <td align="right"><b>Type in database name</b></td>
   <td>
     <input type=text name="database" value=<?php echo $database ?> >
   </td>
  </tr>
  <tr>
   <td align="right" valign="top"><b>Type in SQL query</b></td>
     <td><textarea name="query" cols="60" rows="10"><?php echo $query ?></textarea>
   </td>
  </tr>
  <tr>
   <td colspan="2" align="center"><input type="submit" value="Submit Query"></td>
  </tr>
 </table>
</form>
</body>
</html>

Thanks.

January 23rd, 2004, 02:51 PM

nazly

Codewalkers Beginner (1000 - 1499 posts)

Join Date: Apr 2007

Location: Colombo,SriLanka

Posts: 1,325

Time spent in forums: 20 m 18 sec
Reputation Power: 3

RE: PHP, MySQL & Apache

I haven't gone through PHP & MySQL for Dummies book. It might be that it supports older version of PHP. (Not sure though) For the error that you are getting it might be that the register_globals setting is set to off in your php.ini file.
So instead of $PHP_SELF try using $_SERVER["PHP_SELF"]
Instead of $database try using $_POST["database"]
Instead of $query try using $_POST["query"]

Thats what I spotted for the moment. Try that out and see.

January 23rd, 2004, 07:27 PM

Andrew

Moderator

Join Date: Apr 2007

Location: United Kingdom

Posts: 1,937

Folding Points: 2429 Folding Title: Novice Folder

Time spent in forums: 4 Days 1 h 57 m 37 sec
Reputation Power: 3

RE: PHP, MySQL & Apache

dont forget your ;'s

January 23rd, 2004, 09:32 PM

Andrew

Moderator

Join Date: Apr 2007

Location: United Kingdom

Posts: 1,937

Time spent in forums: 4 Days 1 h 57 m 37 sec
Reputation Power: 3

RE: PHP, MySQL & Apache

Because you have missed some out.

January 23rd, 2004, 10:27 PM

nawlej

Contributing User

Join Date: Apr 2007

Location: Dallas, Tx. USA

Posts: 2,008

Time spent in forums: 11 h 7 m 51 sec
Reputation Power: 4

RE: PHP, MySQL & Apache

If you would like to use $PHP_SELF as a variable as the book suggests, you need to edit your php.ini file to turn register_globals [b]on[b]. Theoretically, the book is right, but it assumes you have globals turned on.

January 24th, 2004, 01:08 PM

Garcia

Join Date: Apr 2007

Location: Aberdeen, Scotland

Posts: 19

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

RE: RE: PHP, MySQL & Apache

Quote:

nawlej, you hero - works perfectly

Thanks a lot guys!

January 24th, 2004, 01:22 PM

nazly

Join Date: Apr 2007

Location: Colombo,SriLanka

Posts: 1,325

Time spent in forums: 20 m 18 sec
Reputation Power: 3

RE: PHP, MySQL & Apache

Quote:

nawlej, you hero - works perfectly

He is.. But other's aren't zero either.

The book is right for the time when it was written. But you need to get used to new releases of PHP. So only a book won't do the job for you. You need to be in touch. www.php.net the home of PHP is always the first option. And Codewalkers.com community will keep you up-to-date.

I recommend you to set the register_globals option to OFF. Even though you are a Newbie learn the better way.

Have a look at this http://www.php.net/register_globals

January 24th, 2004, 09:35 PM

Andrew

Moderator

Join Date: Apr 2007

Location: United Kingdom

Posts: 1,937

Time spent in forums: 4 Days 1 h 57 m 37 sec
Reputation Power: 3

RE: PHP, MySQL & Apache

Yeh You should write your scripts to cope with register_globals being turned off which is set as default on most servers. Even if you have register_globals on then there will come a day when you give the script to someone and it wont work because register_globals is off on their server and they cant turn it on because its a shared host. So its better to make your scripts work without register globals.

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: