php and mysql connection in LAMP

Question

I am using Ubuntu 12.10 and i have installed LAMP. While i was learning PHP i came across a topic of connecting mysql and php. This is the code i learn

<?php

$db = mysql_connect('localhost','root','dbpass') or die('Unable to connect. Check your connection ');

$query = 'CREATE DATABASE IF NOT EXISTS moviesite';
mysql_query($query,$db) or die(mysql_error($db));

mysql_select_db('moviesite',$db) or die(mysql_error($db));

$query2 = 'CREATE TABLE movie (movie_id integer not null, moviename varchar(255) not null, movierating integer not null)';

mysql_query($query,$db) or die(mysql_error($db));

echo "movie database succecfully created ";

?>

When i try this in my windows environment (i have dual boot windows and ubuntu) , it works fine. In windows i am using eastPHP. But in ubuntu it doesn't shows anything. I have tried to find syntax errors but its just the same given in a book. So what can be the problem ?

troelskn · Accepted Answer · 2012-10-23 08:37:56Z

1

If you get a blank page in the browser, you probably have a fatal error or a server configuration issue. Assuming you use Apache, look in the Apache error logs for some clues. On Ubuntu, it would be in /var/log/apache2/error.log per default.

answered Oct 23, 2012 at 8:37

troelskn

118k27 gold badges135 silver badges156 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user1263375 Over a year ago

It says - : "[Tue Oct 23 13:50:15 2012] [error] [client 127.0.0.1] PHP Fatal error: Call to undefined function mysql_connect() in /var/www/dbcon2.php on line 8 " But isn't my function correct ?

troelskn Over a year ago

In that case, you probably need to install the mysql extension. Try with sudo apt-get install php5-mysql

Collectives™ on Stack Overflow

php and mysql connection in LAMP

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related