$sql = "INSERT INTO testTable values ('', '$_POST[testField]')";
should be
$var = $_POST["testField"];
$sql = "INSERT INTO testTable values ('', '$var')";
/sagar
----- Original Message -----
From: "Mecnun" <mecnunbabe@xxxxxxxxx>
To: <php-general@xxxxxxxxxxxxx>
Sent: Wednesday, December 08, 2004 4:23 PM
Subject: i'm beginner and i couldn't solve the problem
> I'm usin php, apache and mysql on my computer. I have run some scripts. so
i'm sure i installed them correctly. One of my script don't run properly,
also it doesnt give error.
> I'm trying to send some data to my database by using a form. The database
can get the auto incremented number but doesn't get whatever I type into the
text box in the form. My code is below:
> ------------------------------------------------------
> <?php
> file://open the connection
> $conn = mysql_connect("localhost", "selimatmaca", "BETULBETUL");
> file://pick the database to use
> mysql_select_db("testDB", $conn);
> file://create the sql statement
> $sql = "INSERT INTO testTable values ('', '$_POST[testField]')";
> file://execute
> if
sql_query($sql,$conn)){
> echo "Record Added";
> } else{
> echo "Somethin went wrong";
> }
> ?>
> --------------------------------------------------------------
>
>
> mysql> select * from testTable;
> +----+--------------+
> | id | testField |
> +----+--------------+
> | 1 | some value |
> | 2 | some value |
> | 3 | |
> | 4 | |
> | 5 | |
> | 6 | |
> | 7 | |
> | 8 | |
> | 9 | [testField] |
> | 10 | [testField] |
> | 11 | |
> | 12 | |
> | 13 | |
> | 14 | |
> +----+--------------+
> 14 rows in set (0.00 sec)
>
>
> The database dont show the "testField" data, but it shows the numbers.
> Also this is my html form:
>
>
>
> <!DOCTYPE HTML PUBLIC "-//W3C/
/DTD HTML 4.01 Transitional//EN">
> <html>
> <head>
> <title>An Insert Form</title>
> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
> </head>
> <body>
> <FORM ACTION="insert.php" METHOD=POST>
> <P> Type something in:<br>
> <input type=text name="testField" size=30>
> <input type="submit" name="submit" value="Insert Record">
> </P>
> </FORM>
> </body>
> </html>
>
>
> There is another script for which I dont use a html form. I send the data
directly from the script and it works fine. Codes are here:
>
> <html>
> <head>
> <title>Untitled Document</title>
> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
> </head>
> <body>
> <?php
> $conn = mysql_connect("localhost", "selimatmaca", "BETULBETUL");
> mysql_select_db("testDB", $conn);
> $sql = "INSERT INTO testTable values ('', 'some value')";
> if (mysql_query($sql, $conn))
> {
> echo "record added";
> }
> else
> {
> echo "Something went wrong";
> }
> ?>
> </body>
> </html>
>
>
> so, please tell me where I'm doing wrong. Thanks a lot.
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail - Find what you need with new enhanced search. Learn more.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
