[RESOLVED] PHP5 and MySQL

hendy

Hi All,

This is my first post so please forive any stupid mistakes.

Im running PHP 5 with MySQL Server 5.0 and Apache 2.0.5

I have configured apache to work fine with PHP, but when i try to do a simple things like create a table through a php page it dosent work, im using the following code:

<?
$user="xxxxx";
$password="xxxxxxx";
$database="test";
mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="CREATE TABLE contacts (id int(6) NOT NULL auto_increment,first varchar(15) NOT NULL,last varchar(15))";
mysql_close();
?>

The page just comes up blank, no errors, nothing. When i go back to MySQL and check the database its still the same, just an empty set.

Ive tried using the "sticky" tutorial for setting up PHP to work with MySQL and followed it to the letter.

Anyone any ideas????

khendar

You are not executing your query. How can any errors be thrown if you aren't doing anything which can cause an error ?

$result = mysql_query($query);

Try that...

Oh...and fix your create table query 😉

hendy

Told you i was new LOL,

ps do i just add:
$result = mysql_query($query);

to the end of my code jsut before: mysql_close();

khendar

That'd be a good start 😛

I'd recommend you check out http://au.php.net/manual/en/ref.mysql.php to learn how to get more information about how the query went.

rincewind456

Whilst your learning, never run a query without using one of the error checks available.
I would suggest this

$result = mysql_query($query) or die(mysql_error());

hendy

Hi guys thanks for the replies, i dont seem to be able to get php to communicate with mysql, im using the following code:

<?
$user="xxxxxxxxx";
$password="xxxxxxxx";
$database="test";

mysql_connect(localhost,$user,$password);

@mysql_select_db($database) or die( "Unable to select database");

$query=CREATE TABLE contacts (id int(6) NOT NULL auto_increment,first varchar(15) NOT NULL,last varchar(15));

$result = mysql_query($query) or die(mysql_error()); 

mysql_close();
?>

Can anyone see what im doing wrong, ive followed all the instructions for installing PHP, Apache and MySQL - PHP works file with apache and ive enabled and copied the relevant dll's into the PHP directory, any help greatly appreciated.

Thanks

rincewind456

Your using short tags in php are they defined in the php.ini, if not this wont work. It's not a good idea to use short tags as when you move your scripts to a server that doesn't support it you will have a lot of fun going through all your files and changing them.

You don't want the @ in front of the db connection line, as that suppresses any errors, not something you want when your trying to find out if the script works.

You also have no quotes around your sql statement. Try this

<?php
$user="xxxxxxxxx"; 
$password="xxxxxxxx"; 
$database="test"; 

mysql_connect(localhost,$user,$password); 

mysql_select_db($database) or die( "Unable to select database"); 

$query="CREATE TABLE contacts (id int(6) NOT NULL auto_increment,first varchar(15) NOT NULL,last varchar(15))"; 

$result = mysql_query($query) or die(mysql_error()); 

mysql_close(); 
?>

Have you checked to see if you can connect to mysql through the command line?

Sxooter

Plus, a create table statement doesn't produce a lot of output, and whatever is being produced for output isn't going anywhere in your current script anyway.

hendy

Yeah i can connect through the command line and do whatever i want with the databases, ive since been able to get a php script to create a table using the following:

<?php

$dbhost = 'localhost';
$dbusername='root';
$dbuserpass='2233home';
$dbname = 'test';

$link_id = mysql_connect($dbhost, $dbusername, $dbuserpass) or die("Unable to connect to MySQL.");
print "Connected to MySQL<br>";

mysql_select_db ('test') or die ('Could not Connect to database');

// you're going to do lots more here soon

$query= 'CREATE TABLE contacts (id varchar(6),first varchar(15),last varchar(15))' or die("Unable to create table.");
print "Table Created Successfully.";
$result = mysql_query($query) or die(mysql_error());

mysql_close($dbh);

?>

Then i tried to insert data from a csv file but im not realy sure how to do this, i know the MySQL statment for doing it but not sure how to get this into PHP.

rince u said that i was using short tags... i didnt realise i was, is there list of full length tages anywhere?

Thanks

Sxooter

short tags are:

<? code goes here ?>

Long tags are:

<?php code goes here ?>

Those are the only tags rince was speaking of.

hendy

Thanks guys, ive got it sorted now, was able to get the csv file into the database, sorry if the questions are a bit dumb but i only downloaded sql php and apache last week so im kinda fumbling my way around in the dark a lot.

Help was greatly appreciated...Thanks