so frustrating!!

djkrissy

Hi there, any help much appreciated, I am new to php/mysql although i have a solid understanding of javascript so scripting usually makes sense to me! I have been trying to do a tutorial, i have had success on a server i have access to, but not on my home based server, I have apache http server 2.2, mysql 5.0, php 5, along with phpmyadmin (working fine) and phpbuilder on evaluation (working fine done tutorials no sweat)

on home computer this works fine =
<?php
$user=" ";
$password=" ";
$database=" ";
mysql_connect('localhost',$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="CREATE TABLE contacts1 (id int(6) NOT NULL auto_increment,first varchar(15) NOT NULL,last varchar(15) NOT NULL,phone varchar(20) NOT NULL,mobile varchar(20) NOT NULL,fax varchar(20) NOT NULL,email varchar(30) NOT NULL,web varchar(30) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))";
mysql_query($query);
mysql_close();
?>
it creates the table no sweat! great everything is configured lol

but this =
<?php
$username=" ";
$password=" ";
$database=" ";

mysql_connect('localhost',$username,$password);

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

$query = "INSERT INTO 'contacts' VALUES ('','John','Smith','01234 567890','00112 334455','01234 567891','johnsmith@gowansnet.com','http://www.gowansnet.com')";
mysql_query($query);
mysql_close();
?>
runs with no errors, but no values are added?

like i said it worked fine on my websites server, but not on my home server? Im thinking there might be a php extension i am missing, but if phpmyadmin and phpmaker5 are working? Please help me out here, i know its probably somthing stupid lol

Chris🙂

Chriss.

Piranha

I have a few tips for you that probably will help you solve that problem, and a few additional problems as well:

You should use mysqli-functions and not mysql-functions. To be honest I'm not that much into PHP, so I can't explain the difference in a good way. Just trust me, or search for it 🙂
Normally when you insert into a database you use the following syntax:
```
insert into table (columna, columnb) values ('valuea', 'valueb')
```
If you use this syntax and change the table it will still work. If you don't specify what columns to use the query would break, and you would have to go through all your queries. With this approach you should leave out the auto_incremented column, it will be handled automatically.
Use the following syntax to spot errors in the sql query (I hope I got it right)
```
$query = "something";
mysql_query($query) or die ('SQL error: ' . mysql_error());
```
When the query fails it will print the error on the page.
You use the code INSERT INTO 'contacts'. It should be backticks: INSERT INTO ´contacts´(or if it is INSERT INTO contacts).
Usually you don't create the tables in the PHP code. Better to first create the tables and then just use them in PHP.
When using email addresses, web page addresses and other variable-length strings you should use a datatype that is longer that will be used. 30 characters for a web page is not enough.
It helps if you create the table with the same name that you later use to insert rows...

djkrissy

Thanks for the info, the code i used was copied and pasted from a tutorial site, will take on board your hints and hopefully solve the problem!

Thanks for taking the time to respond i am very grateful!

Chriss

djkrissy

You nailed it! spot on everything working as planned! now i can on and expand from the basics, im guessing the code i was using was very old and outdated, even though it worked on ixhostings servers!

Thanks again!

Chriss