Php & Mysql Problem

**georgeuk83** · May 26, 2007 14:54

i am reading the book

"BUILDING YOUR OWN DATABASE DRIVEN WEBSITE USING PHP & MYSQL" and im stuck. i tried the example with the joke database but it doesnt seem to work. ive successfull created the table but when i write the code to display the data nothing comes up.

here is my code

PHP Code:


<html>
<head>
<title>our list of jokes</title>
<head>
<body>

<?php


$dbcnx = @mysql_connect('localhost', 'root', 'mypasswd');
if (!$dbcnx) {
    exit('<p>Unable to connect to the ' .
    'database server at this time.</p>');
}

if (!@mysql_select_db('ijdb')) {
    exit('<p>Unable to locate the joke ' .
    'database at this time.</p>');
}

?>
<p>here are all the jokes in our database:</p>
<blockquote>
<?php

$result = @mysql_query('SELECT joketext FROM joke');
if (!$result) {
    exit('<p>Error performing query: ' .mysql_error() . '</p>');
}




while ($row = mysql_fetch_array($result)) {
    echo '<p>' . $row['joketext'] . '</p>';
}

?>

</blockquote>
</body>
</html>

**Jelena** · May 26, 2007 14:57

Do you have anything entered in a db table?

You might want to add a check to see if query returned any results?

PHP Code:


<html>
<head>
<title>our list of jokes</title>
<head>
<body>

<?php


$dbcnx = @mysql_connect('localhost', 'root', 'mypasswd');
if (!$dbcnx) {
    exit('<p>Unable to connect to the ' .
    'database server at this time.</p>');
}

if (!@mysql_select_db('ijdb')) {
    exit('<p>Unable to locate the joke ' .
    'database at this time.</p>');
}

?>
<p>here are all the jokes in our database:</p>
<blockquote>
<?php

$result = @mysql_query('SELECT joketext FROM joke');
if (!$result) {
    exit('<p>Error performing query: ' .mysql_error() . '</p>');
}

if(mysql_num_rows($result) == 0)
{
    echo '<p>No jokes at the moment.</p>';
}


while ($row = mysql_fetch_array($result)) {
    echo '<p>' . $row['joketext'] . '</p>';
}

?>

</blockquote>
</body>
</html>

**georgeuk83** · May 26, 2007 15:05

i just tried this code. the same thing. just a blank screen comes up. i have saved the file as jokelist.php in my C:\Inetpub\wwwroot folder.

i type localhost/jokelist.php and nuthing comes

yes there is in my table. i have added one line only. one joke and one date.

**byron3@earthlink** · May 26, 2007 15:15

Try using http://localhost/jokelist.php, your basic non php html code and echo statements should show if the php file is being processed.

Byron Thomas

**georgeuk83** · May 26, 2007 15:19

nothing same again. blank page

**trhynard** · May 26, 2007 15:38

If you view the source of the blank page is there any HTML tags or nothing at all?

**georgeuk83** · May 26, 2007 15:56

there is only up to the body part

<html>
<head>
<title>our list of jokes</title>
<head>
<body>

**byron3@earthlink** · May 26, 2007 15:58

Take the following and place it into a file called info.php :

PHP Code:


<?php

phpinfo();

?>

Load this page into a web browser, You have not said but I take it that you are using IIS on the same computer you are browsing on. If you are on a workstation and your server is a different machine you will need to use the IP address of the server, I work on a network and my serverhas an IP address of 192.168.0.1.
Otherwise http://localhost/info.php should output the php configuration information of your installed version of php. If you get a blank page you need to reconfigure your installation.

Byron Thomas

**georgeuk83** · May 26, 2007 16:07

php info works ok

what can i do now

**byron3@earthlink** · May 26, 2007 16:10

Take the @ error suppressions out of your code.

Byron Thomas

**georgeuk83** · May 26, 2007 16:15

this is what i got now

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in C:\Inetpub\wwwroot\jokelist.php on line 11

We were unable to connect to the database server at this time.

**byron3@earthlink** · May 26, 2007 16:22

I use the following code :

PHP Code:


function db_open(){

    $db = mysql_connect('localhost', 'app_User_Name', 'password');

    if (!$db) {

        die('Could not connect: ' . mysql_error());

    }

    

    mysql_select_db( 'Database_to_use' );

    

    if (mysql_errno()) {

        echo 'Could not open connection<br>';

        echo 'Error Number : ' .mysql_errno();

        exit;

        } Else {

            return $db;

        }

}

Make sure you create a user name for your app and that user has select privileges and any other needed within this app, such as insert , update or delete.

Byron Thomas

**georgeuk83** · May 26, 2007 16:31

i took this code from the book. thats why i used it. im not very familiar with php yet.

**byron3@earthlink** · May 26, 2007 16:38

Use whichever code you are comfortable with, to solve the problem go to your mysqladmin and create a user besides 'root'.

mysql> grant select, insert, update, delete
on ijdb
to [User Name] identified by 'mypasswd';

Byron Thomas

**georgeuk83** · May 26, 2007 16:48

ok i downloaded mysql admin. now i gotta create a username? and put it in my code?

what does the above code mean u wrote

mysql> grant select, insert, update, delete
on ijdb
to [User Name] identified by 'mypasswd';

i just tried to connect to mysql admin but cannot. it is asking me for password

**byron3@earthlink** · May 26, 2007 16:58

That would be the command you could run from a command-line interface after logging into mysql. How did you create the table? Did you log in to mysql via a command-line prompt? mysql -h hostname -u username -p? How did you set a password for the root user?

Byron Thomas

**georgeuk83** · May 26, 2007 17:00

i didnt set a password for root as said in the book
yes through command line.

**byron3@earthlink** · May 26, 2007 17:21

Did you install mysqladmin?
Under user administration you should be able to create a user and assign a password to that user for the ijdb.

**georgeuk83** · May 27, 2007 04:04

i did but when i start it this comes up and i dont know what to do

http://img526.imageshack.us/img526/7623/adminwn5.jpg

**georgeuk83** · May 27, 2007 07:02

ok i created a new username and inserted it into my php code. but the problem still remains

**georgeuk83** · May 28, 2007 03:01

i need help guys!!!!

**superuser2** · May 28, 2007 18:36

Hmm... the database is running at localhost on port 3306 (default MYSQL port)?

Make sure "localhost" is allowed to connect as well.

**georgeuk83** · May 29, 2007 13:41

i ve done the database on my webhost now and still not working. i dont know whats wrong

Warning: mysql_query() [function.mysql-query]: Access denied for user 'georgeuk'@'localhost' (using password: NO) in /home/georgeuk/public_html/jokelist.php on line 46

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/georgeuk/public_html/jokelist.php on line 46

Error performing query: Access denied for user 'georgeuk'@'localhost' (using password: NO)

**superuser2** · May 29, 2007 14:09

You're not sending them our password. Please show us your current connection code (replace your password with "*"s but don't change your original code.

User Tag List

Thread: Php & Mysql Problem

Thread Tools

Display

Php & Mysql Problem

Bookmarks

Bookmarks

Posting Permissions