HELP Please - Adding fields to a databas

Anon

If anyone has experience with PHP and MySQL please help me on this:

I need to add fields to a MySQL table and include the inputs from a <form> in this file.

1 - How do I add fields to a MySQL table
ex: City, State, Zip
2 - What kind of command do you type in PHP?
<form name="Register" action="myfile.php" method="post">
<input class=textbox type="text" name="City" size=25 maxlength=255>
<input class=textbox type="text" name="State" size=25 maxlength=255>
<input class=textbox type="text" name="Zip" size=25 maxlength=255>

Now how does this add it to the database?

Marc

thimble

First you need to connect to the database with your name and password and create a query. I personally prefer to set the passwords and table names in a diffrent php file and then reffer to it, so if any changes have to be made you need to do them only once.

Here's an example of such a file:

varia.php

<?
$db_server="localhost"
$db_pass="mypass"
$db_name="dbname"
$db_table="dbtable"
?>

Then when you click on your form's submit buton the "myfile.php" in your example needs to connect to the database using the password info and put the data in the $db_table.

Here an example of such a file:
you ned a mysql table with the field State City and zip

myfile.php

<?
require("varia.php")

//mysql query to fire at the database
$sql = "INSERT INTO $db_table (city, state, zip) VALUES ('$City', '$State', '$Zip')";

//connect to the database
$connection = mysql_connect("$db_server", "$db_name", "$db_pass") or die("error no conection");

//fire query at database
$sql_result = mysql_query($sql, $connection) or die("an error occured");

I use a lot of variables, they are not necsecary for small applications, but if the application grows (and it always does) this is the best method. put the things you think can or might change in the future (like passwords) in a seperate file and "require" it in all you php pages

I hope i've helped you,

if any questions {
ask them }
elsif{ good luck!}

Johan

Anon

config.php

$my_server="localhost";
$my_name="dbname";
$my_username="myusername";
$my_pass="mypassword";
$my_table="mytable";

index.php

<?
require("config.php");

$connection = mysql_connect("$db_server", "$db_name", "$db_pass") or die("error no conection");

$sql = "INSERT INTO $db_table (name, email, city) VALUES ('$name', '$email', '$city')";

$sql_result = mysql_query($sql, $connection) or die("an error occured");

I just tried to test the script..but, This don't work..

thimble

no, it wont...

the variables in the configin the config file "config.php" are named i.e. "my_server"
en in the "index.php" file is the name $db_server" used.

To correct the error change the names in the config.php script to "$db_server" , "$db_name" and so on...

Greetingzz,

Johan