MySQL

[abc123ben]

Hello,

Need help again .

OK. Well, I'm reading a PHP & MySQL book, and at the moment on Chapter 4, basically explaining about MySQL queries and that. And it's explaining in good detail. But there's one problem, it doesn't show you "exactly" what to put in the file to make an SQL query:

I go to file manager on my site, and use an SQL query, as follows:

<html>
<head><title>SQL query:</title></head>
<body>
<?php

CREATE DATABASE Test

?>

</body></html>

I have a feeling it isn't how you do an SQL query, well that way anyway. So what's the correct SQL code to do an SQL query please?

Sorry, very new to this .

 

[Barrucadu]

Hello,

Need help again .

OK. Well, I'm reading a PHP & MySQL book, and at the moment on Chapter 4, basically explaining about MySQL queries and that. And it's explaining in good detail. But there's one problem, it doesn't show you "exactly" what to put in the file to make an SQL query:

I go to file manager on my site, and use an SQL query, as follows:

<html>
<head><title>SQL query:</title></head>
<body>
<?php

CREATE DATABASE Test

?>

</body></html>

I have a feeling it isn't how you do an SQL query, well that way anyway. So what's the correct SQL code to do an SQL query please?

Sorry, very new to this .

First of all, you need a database connection, here is the code to conenct to a database, and execute a query:

<?php
mysql_connect('server_name', 'username', 'password')or die(mysql_error());
mysql_select_db('database_name')or die(mysql_error());
mysql_query('query here')or die(mysql_error());
mysql_close();
?>

 

[Keral_Patel]

Here it is.

<?php
$host = "localhost"; //Because in most cases it is localhost
$user = "root"; //If you are doing this on your Home PC.
$pass = ""; //Not needed if connecting as root and you havent set it. If you have set it then use that password here.

$link = mysql_connect( $host, $user, $pass );
if (! $link )
	die("Couldn't connect to MYSQL");

$mysql_query("CREATE DATABASE Test"); //This creates the database.

mysql_close($link); //Closing the connection. If you want to do more process then don't close it put this at the end of the file.
?>

Update: Mikor beat me to it.

 

[abc123ben]

Thanks . But I get this error:


Fatal error: Call to undefined function: () in /home/bensgfx/public_html/query.php on line

:s

 

[Keral_Patel]

put the code of the script here.

What have you written in query.php?

 

[abc123ben]

<?php
$host = "localhost"; //Because in most cases it is localhost
$user = "bensgfx"; //If you are doing this on your Home PC.
$pass = ""; //Not needed if connecting as root and you havent set it. If you have set it then use that password here.

$link = mysql_connect( $host, $user, $pass );
if (! $link )
    die("Couldn't connect to MYSQL");

$mysql_query("CREATE DATABASE MemberTest"); //This creates the database.

mysql_close($link); //Closing the connection. If you want to do more process then don't close it put this at the end of the file.
?>

I did use a password, but I'm not posting it. Any help appreciated.

 

[Keral_Patel]

<?php
$host = "localhost";
$user = "bensgfx";
$pass = "";
$link = mysql_connect( $host, $user, $pass );
$r = $mysql_query("CREATE DATABASE MemberTest");
?>

Okay to make it less confusing try the above one with your password.

 

[TwistMyArm]

Try using 'root' as your username, too. I don't know why MySQL would default to your PC username when running on a 'home PC'.

 

[Dan]

The problem is you are using $mysql_query. Change that to just mysql_query (no $).

 

[yeppers]

The problem is you are using $mysql_query. Change that to just mysql_query (no $).

What he said lol.

Ben, do you know if you have phpMyAdmin? (This usually comes with CPanel, if you have CPanel).