drekha
-
Posts
2 -
Joined
-
Last visited
Never
drekha's Achievements
Newbie (1/5)
0
Reputation
-
HELP!!insert data in database using user input
drekha replied to avishek.gc's topic in Apache HTTP Server
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. -
I am not able to insert data in my database through forms.Please help .I expect this site is very active in helping newbies.. My code is : form.php <?php echo" <html> <form name=\"AccessInterface\" action=\"process.php\" method=post> DoctorsID:<input name=\"DoctorsID\" type=\"text\" size=\"25\" ><br> Organization:<input name=\"Organization\" type=\"text\" size=\"25\" ><br> password:<input name=\"password\" type=\"text\" size=\"25\" ><br> <input type=Submit value=\"insert\"> </form> </html> "; ?> process.php <html> <?php $cn=odbc_connect('doctordb','root',' '); echo"connected"; if(!$cn) Error_handler("nop connection",$cn); $query="Select * from Table1"; $cr=odbc_exec($cn,$query); $nbrow=0; while( odbc_fetch_row( $cr )) { $nbrow++; echo"<tr><th>DoctorsID</th><th>Organization</th><th>password</th></tr>\n"; $DoctorsID=odbc_result($cr,1); $Organization=odbc_result($cr,2); $password=odbc_result($cr,3); echo"<tr><td>$DoctorsID</td><td>$Organization</td><td>$password</td></tr>\n"; } odbc_close($cn); exit(); $cn=odbc_connect('doctordb','root',' '); $query1="Insert into Table1 values('$DoctorsID'],'$Organization','$password)"; $cr1=odbc_exec($cn,$query1); odbc_close($cn); ?> </html>