Planetarion Forums

Flying Monkey · 29 Mar 2006, 13:24

I'm really stuck with this. I've never done anything like this before and now for uni we have to do 2 projects using MySQL and php. I've installed apache, php and MySQL on my computer and the apache and php seem to work but I've no idea how to use the SQL

I copied a php script from a book that is just supposed to connect to the sql and show a message saying that its connected but it just shows a blank page which I take it to mean that its not connecting properly.

Code:

<?php $user = "username";

$conn = mysql_connect( "localhost", $user, "password" );
if($conn){
$msg="Congratulations $user, you connected to MySQL"; }
?>

<html><head><title>Connecting user</title></head>
<body><h3> <?php echo($msg); ?> </h3></body></html>

Also what is the $user supposed to be? Does it have to have a specific value? Any help would be grately apprieciated (in language for someone whos crap with computers to understand

), I've been trying to get it to work all day

NEWSBOT3 · 29 Mar 2006, 14:07

Quote:

Originally Posted by Flying Monkey

I'm really stuck with this. I've never done anything like this before and now for uni we have to do 2 projects using MySQL and php. I've installed apache, php and MySQL on my computer and the apache and php seem to work but I've no idea how to use the SQL

I copied a php script from a book that is just supposed to connect to the sql and show a message saying that its connected but it just shows a blank page which I take it to mean that its not connecting properly.

Code:

<?php $user = "username";

$conn = mysql_connect( "localhost", $user, "password" );
if($conn){
$msg="Congratulations $user, you connected to MySQL"; }
?>

<html><head><title>Connecting user</title></head>
<body><h3> <?php echo($msg); ?> </h3></body></html>

Also what is the $user supposed to be? Does it have to have a specific value? Any help would be grately apprieciated (in language for someone whos crap with computers to understand

), I've been trying to get it to work all day

$ = variable in php
thats not going to work because your sql password and username are probably not right
try setting it like

Code:

$user="NB3SQL";
$password="NB3letmein";

$conn = mysql_connect( "localhost", $user, "password" );
if($conn){

etc

those are the username and password for the mysql server.
assuming you've got that setup and running.

Flying Monkey · 29 Mar 2006, 15:32

Still doesn't work, its doing all strange things that no one I've talked to knows why. Including saying the MySQL.dll file doesn't exist when I can see it on the screen

I think something must have gone wrong with the installation and its gonna be a case of waiting till I'm back at uni and getting someone round to fix it for me

Phil^ · 29 Mar 2006, 16:43

have you copied libmysql.dll from /path/to/mysql/bin to /path/to/apache or /path/to/php or something?
php_mysql.dll needs to be in there too

Doorsdown · 1 Apr 2006, 07:53

try doing this

Code:

<? phpinfo(); ?>

and see if php is configured to use mysql

and if it is

Code:

<?

$host = "localhost";
$user = "your_users";
$password = "your_pass";

$conn = mysql_connect($host,$user,$password) or die(mysql_error());
//the rest of the code
?>

Shyne · 4 Apr 2006, 15:29

FlyingMonkey, contact me on IRC and I'll fix you up