Jump to content


Photo

HELP!!insert data in database using user input


  • Please log in to reply
1 reply to this topic

#1 avishek.gc

avishek.gc
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 09 February 2006 - 05:44 PM

in one area i got stuck,when i try to insert data into database, it is not working,suppose when i take user input from a form and try to echo user input in other page it is working...but when i try to insert that user input into my database...it is not inserted in database.do i have to change anything in php.ini file..
i am using the following code..but data is not inserted in the database. my insert.php is given(where i am taking only name and roll as an input from a form and try to insert it into database but it is not working...data is not inserted....the php file is given below...
[size=4]


<?php
$link = mysql_connect('localhost', 'root', '*****');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'connected succesfully';
mysql_select_db('mydb');
$query = "INSERT INTO new (name,roll) values ($_POST['name'],$_POST['roll'])";
$result = mysql_query($query);
mysql_free_result($result);
mysql_close();

?>
PLEASE HELP ME IF ANYBODY KNOWS THE ANSWER.........
THANKS A LOT FOR READING...
avishek.gc@gmail.com

#2 drekha

drekha
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 22 February 2006 - 06:53 PM

Were you able to solve the problem .i am having the same problem and working on it since a week.I am using MSAccess as data base and Apache as a server.But I am not able to insert in my table through form
iF YOU KNOW THE ANSWER PLEASE ...HELP.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users