MySQL Tutorial 2 - Inserting entries into database

In this tutorial I teach you how to insert values into the database, another important part of databases as you need a way always for users to add comments on your website or by them storing information on your guest book or forum etc.

Category:

Howto & Style

Tags:

• MYSQL
• TUTORIALS
• FREE
• WEB
• DESIGN

[monofono2006]

@simeon310 variables can't have spaces.

[simeon310]

Thanks by the way for the tutorial. My question is why the code did not work. Here is the code for reference:

$name = "John";

$last name = "Doe";

$query = mysql_query("insert into customer values ('','$name', '$last name')");

Thanks Again

[BiggestOfDaddies]

I have a form page to add user information to a database and I want some of the fields to be optional. If all fields are filled in, it works perfectly. But if any of the form fields are blank, nothing adds. How do I get the blank form fields to translate into simply leaving the database field blank?

[CALAVIDEOS2013]

Try to increase the volume in your sound settings

[Ruzdee]

loud up your microphone please.. :(

i hear your typing keyboard louder than your voice.. :(

[PrototypeZZ]

Tnx..:D it works..:D

[ikalwewe]

i dont understand, why is there the $sign.INSERT INTO `trialtable` (`email`, `name`, `country`, `url`, `pending`, `password`, `showemail`, `showurl`, `added`) VALUES..?

[HuumeKauppias]

@anaik1 The sound is fine.

[anaik1]

What? Information seems great, but can barely hear a word you are saying! It's a shame too, you seem very knowledgeable.

[philnauer]

@naruto3zo Thanks for that, that was the missing piece I was looking for, now I can get on with the real application of MySQLing... Cheers!!!