Free Weekly Tech Newsletter

longrawker · 12-06-2004, 02:06 PM

Hey.

The code that I’m trying to get to work is as follows. The problem is with the 7th, 8th, and 9th lines...

PHP Code:


			
<html>

<head>

<title>Test MySQL</title>

<body>

<!-- mysql_up.php -->

<?php

$host="";

$user="";

$password=" ";



mysql_connect($host,$user,$password);

$sql="show status";

$result = mysql_query($sql);

if ($result == 0)

   echo("<b>Error " . mysql_errno() . ": " . mysql_error() . "</b>"); elseif (mysql_num_rows($result) == 0)

   echo("<b>Query executed successfully!</b>");

else

{

?>

<!-- Table that displays the results -->

<table border="1">

  <tr><td><b>Variable_name</b></td><td><b>Value</b></td></tr>

  <?php

    for ($i = 0; $i < mysql_num_rows($result); $i++) {

      echo("<TR>");

      $row_array = mysql_fetch_row($result);

      for ($j = 0; $j < mysql_num_fields($result); $j++) {

        echo("<TD>" . $row_array[$j] . "</td>");

        }

        echo("</tr>");

    }

  ?>

</table>

<?php } ?>

</body>

</html>

The server that I'm uploading to is www.allbutnothing.com. I know my computer name, is the correct form for the host value computername.webserver.com?? How do I find my username and password?

I have installed PHP and MySQL, and the MySQLadmin.exe prog doesnt provide much help...

Thanks a lot.

aym · 12-06-2004, 03:05 PM

Contact your host admin, I only see a blog on that link.

**mairving** · 12-06-2004, 03:15 PM

Kind of confusing in your post. It looks like that you are wanting to test this on your local build before you upload it to your website. If so, host would be localhost. Default user would be 'root' and password would be blank ''.

$host = 'localhost';
$user = 'root';
$password = '';

You can't really run the script on your local computer using the database on the site.

longrawker · 12-07-2004, 10:04 AM

Quote:

Originally Posted by mairving

Kind of confusing in your post. It looks like that you are wanting to test this on your local build before you upload it to your website. If so, host would be localhost. Default user would be 'root' and password would be blank ''.

$host = 'localhost';
$user = 'root';
$password = '';

You can't really run the script on your local computer using the database on the site.

Actually, it's quite the opposite. I'm looking to test the database which is on my computer. I'm trying to find out what is wrong with those three lines of code... I dont understand the section in the book which deals with this.

"{shows lines of code that i posted originally, i copied the file from the CD, that's how i know there's nothing wrong with the code...}

Lines 7, 8, and 9 of that program need to be changed. These lines are

$host = 'hostname';
$user = 'mysqlaccount';
$password = 'mysqlpassword';

Change host to the name of the computer where MySQL is installed - for example, databasehost.mycompany.com. If the MySQL database is on the same computer as your web site, you can use localhost as the hostname.

Change mysqlaccountname and mysqlpassword to the appropriate values. If your MySQL account does not require a password, then type nothing between the quotes"

-that's from the book i'm using...

I'm totally lost here...

longrawker · 12-07-2004, 10:06 AM

Quote:

Originally Posted by aym_7

Contact your host admin, I only see a blog on that link.

Yeah, i know, allbutnothing.com is the server... or the domain name if you rather.

ltmccaul · 12-17-2004, 11:21 PM

that is their domain, you need to contact them to get this info, the host, your username and password that they will issue you. the domain is different from where they probably keep the MySQL server. so will need to talk to them and input the correct values into those lines.

12-06-2004, 02:06 PM	#1
longrawker Member (8 bit) Join Date: Jun 2004 Location: South Bucks, England Posts: 160	Maybe a little PHP/MySQL help is needed... Hey. The code that I’m trying to get to work is as follows. The problem is with the 7th, 8th, and 9th lines... PHP Code: <html> <head> <title>Test MySQL</title> <body> <!-- mysql_up.php --> <?php $host=""; $user=""; $password=" "; mysql_connect($host,$user,$password); $sql="show status"; $result = mysql_query($sql); if ($result == 0) echo("<b>Error " . mysql_errno() . ": " . mysql_error() . "</b>"); elseif (mysql_num_rows($result) == 0) echo("<b>Query executed successfully!</b>"); else { ?> <!-- Table that displays the results --> <table border="1"> <tr><td><b>Variable_name</b></td><td><b>Value</b></td></tr> <?php for ($i = 0; $i < mysql_num_rows($result); $i++) { echo("<TR>"); $row_array = mysql_fetch_row($result); for ($j = 0; $j < mysql_num_fields($result); $j++) { echo("<TD>" . $row_array[$j] . "</td>"); } echo("</tr>"); } ?> </table> <?php } ?> </body> </html> The server that I'm uploading to is www.allbutnothing.com. I know my computer name, is the correct form for the host value computername.webserver.com?? How do I find my username and password? I have installed PHP and MySQL, and the MySQLadmin.exe prog doesnt provide much help... Thanks a lot. Share Share this post on Digg Del.icio.us Technorati Twitter

12-06-2004, 03:05 PM	#2
aym Registered User Join Date: Nov 2001 Posts: 1,965	Contact your host admin, I only see a blog on that link. Share Share this post on Digg Del.icio.us Technorati Twitter

12-06-2004, 03:15 PM	#3
mairving Staff Premium Member Join Date: Jul 1999 Location: Arlington, TN Posts: 5,538	Kind of confusing in your post. It looks like that you are wanting to test this on your local build before you upload it to your website. If so, host would be localhost. Default user would be 'root' and password would be blank ''. $host = 'localhost'; $user = 'root'; $password = ''; You can't really run the script on your local computer using the database on the site. Share Share this post on Digg Del.icio.us Technorati Twitter __________________ Want to Make $$$$ with your Computer? No Risk! Simply press shift-4 four times in a row

12-17-2004, 11:21 PM	#6
ltmccaul Member (6 bit) Join Date: Dec 2004 Posts: 54	that is their domain, you need to contact them to get this info, the host, your username and password that they will issue you. the domain is different from where they probably keep the MySQL server. so will need to talk to them and input the correct values into those lines. Share Share this post on Digg Del.icio.us Technorati Twitter

Thread Tools	Search this Thread
Show Printable Version 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:

Need Some Help? Type Your Keywords Here:

Still Need Help? Type Your Keywords Here:

Free Weekly Tech Newsletter

Subscribe to THE INSIDER

Need Some Help? Type Your Keywords Here:

Still Need Help? Type Your Keywords Here:

Free Weekly Tech Newsletter