MySql update form script?

dihan · #1 (**permalink**) 01-09-04, 10:23 AM

Have anyone got a simple form script that can be used to input data to a table on MySql?

i.e

name
address
age
sex

MySql Table-

Name--Address-------Age-----Sex
john---22 smith rd----29------male
david--21 smith rd----22------male

PHP Code:


			
<?PHP

// Connect to database

$link = mysql_connect('localhost','user', 'password')

    or die("Could not connect");

mysql_select_db('select_db')

    or die("Could not select database");



 //?????





// Content

echo '<body bgcolor="#155271" leftmargin="0" topmargin="0" rightmargin="0" bottommargin="0">

<form name='guestlist' method='post'>

  <TABLE width="395" height="119" border=0 cellPadding=3 cellSpacing=2 bgcolor="#0F364A">

    <TBODY>

      <TR> 

        <TD class=mainText width="56"><b>Name</b></TD>

        <TD width="305" class=frmInput> <INPUT class=mainFormBox style="WIDTH: 320px" type="text" name="name"></TD>

      </TR>

      <TR> 

        <TD class=mainText width="56"><B>Address</B></TD>

        <TD class=frmInput> <INPUT name="address" type="text" class=mainFormBox id="address" style="WIDTH: 320px"></TD>

      </TR>

      <TR> 

        <TD class=mainText width="56"><b>Age</b></TD>

        <TD class=frmInput> <INPUT name="age" type="text" class=mainFormBox id="age" style="WIDTH: 320px"></TD>

      </TR>

            <TR> 

        <TD class=mainText width="56"><b>Sex</b></TD>

        <TD class=frmInput> <INPUT name="sex" type="text" class=mainFormBox id="sex" style="WIDTH: 320px"></TD>

      </TR>

      <TR> 

        <TD class=frmDescription width="56">&nbsp;</TD>

        <TD class=frmInput> <div align="right"> 

            <INPUT type=image name="submit" value="Submit" height=20 width=109 src="sendrequest.jpg" align=Submit >

          </div></TD>

      </TR>

    </TBODY>

  </TABLE>

</form>

  </body>';



mysql_close();

?>

NeverMind · #2 (**permalink**) 01-09-04, 10:39 AM

PHP Code:


			
<?php

if (!isset($_POST['submit'])) {

 echo'<body bgcolor="#155271" leftmargin="0" topmargin="0" rightmargin="0" bottommargin="0">

<form name="guestlist" method="POST" action="./guestlist.php">

  <TABLE width="395" height="119" border=0 cellPadding=3 cellSpacing=2 bgcolor="#0F364A">

    <TBODY>

      <TR>

        <TD class=mainText width="56"><b>Name</b></TD>

        <TD width="305" class=frmInput> <INPUT class=mainFormBox style="WIDTH: 320px" type="text" name="name"></TD>

      </TR>

      <TR>

        <TD class=mainText width="56"><B>Address</B></TD>

        <TD class=frmInput> <INPUT name="address" type="text" class=mainFormBox id="address" style="WIDTH: 320px"></TD>

      </TR>

      <TR>

        <TD class=mainText width="56"><b>Age</b></TD>

        <TD class=frmInput> <INPUT name="age" type="text" class=mainFormBox id="age" style="WIDTH: 320px"></TD>

      </TR>

            <TR>

        <TD class=mainText width="56"><b>Sex</b></TD>

        <TD class=frmInput> <INPUT name="sex" type="text" class=mainFormBox id="sex" style="WIDTH: 320px"></TD>

      </TR>

      <TR>

        <TD class=frmDescription width="56">&nbsp;</TD>

        <TD class=frmInput> <div align="right">

        <input type="hidden" name="submit" value="done" />

            <INPUT type=image name="submit" value="Submit" height=20 width=109 src="sendrequest.jpg" align=Submit >

          </div></TD>

      </TR>

    </TBODY>

  </TABLE>

</form>

  </body>';

//note that I added a new field called submit and it's hidden ..



} else {



/*I added addslashes() so it escape any special char in the form ..

if you want to show your inserted record , you need to use stripslashes() to remove any slashes from the record ..

this is only to avoid some security problems in the query ..*/



$name=trim(addslashes($_POST['name']));

$address=trim(addslashes($_POST['address']));

$age=trim(addslashes($_POST['age']));

$sex=trim(addslashes($_POST['sex']));



$link = mysql_connect('localhost','select_user', 'password')

    or die("Could not connect");

mysql_select_db('select_db')

    or die("Could not select database");



$insert=mysql_query("INSERT INTO table (name, address, age, sex)

VALUES('$name', '$address', '$age', '$sex')")or

die('couldn\'t Insert record into database :'.mysql_error());



echo'The Record was inserted succesfully into Database';

}

?>

good luck

dihan · #3 (**permalink**) 01-09-04, 11:07 AM

Hey I tried out this: but no luck I thought it may have somthing to do with "<form name='guestlist' method='post'>" cause of the " ' ". Could that be it?

http://www.selectguestlist.com/index/update.php

PHP Code:


			
 <?PHP 

 

if (!isset($_POST['submit'])) { 

echo'<body bgcolor="#155271"> 

<LINK href="home/style.css" type=text/css rel=stylesheet>

<form name='guestlist' method='post'> 

  <TABLE width="395" height="119" border=0 cellPadding=3 cellSpacing=2 bgcolor="#0F364A"> 

    <TBODY> 

      <TR> 

        <TD class=mainText width="56"><b>Name</b></TD> 

        <TD width="305" class=frmInput> <INPUT class=mainFormBox style="WIDTH: 320px" type="text" name="name"></TD> 

      </TR> 

      <TR> 

        <TD class=mainText width="56"><B>Address</B></TD> 

        <TD class=frmInput> <INPUT name="address" type="text" class=mainFormBox id="address" style="WIDTH: 320px"></TD> 

      </TR> 

      <TR> 

        <TD class=mainText width="56"><b>Age</b></TD> 

        <TD class=frmInput> <INPUT name="age" type="text" class=mainFormBox id="age" style="WIDTH: 320px"></TD> 

      </TR> 

            <TR> 

        <TD class=mainText width="56"><b>Sex</b></TD> 

        <TD class=frmInput> <INPUT name="sex" type="text" class=mainFormBox id="sex" style="WIDTH: 320px"></TD> 

      </TR> 

      <TR> 

        <TD class=frmDescription width="56">&nbsp;</TD> 

        <TD class=frmInput> <div align="right"> 

            <INPUT type=image name="submit" value="Submit" height=20 width=109 src="guestlist/sendrequest.jpg" align=Submit > 

          </div></TD> 

      </TR> 

    </TBODY> 

  </TABLE> 

</form> 

  </body>'; 

} else { 



$name=trim(addslashes($_POST['name'])); 

$address=trim(addslashes($_POST['address'])); 

$age=trim(addslashes($_POST['age'])); 

$sex=trim(addslashes($_POST['sex'])); 



$link = mysql_connect('localhost','select_user', 'select_password') 

    or die("Could not connect"); 

mysql_select_db('select_db') 

    or die("Could not select database"); 



$insert=mysql_query("INSERT INTO table (name, address, age, sex) 

VALUES('$name', '$address', '$age', '$sex')"); 



$affected=mysql_affected_rows(); 



echo $affected .' Record was inserted into Database'; 

} 



?>

NeverMind · #4 (**permalink**) 01-09-04, 11:34 AM

opps I forgot something very important ..
try this one now :

PHP Code:


			
<?php

    if (!isset($_POST['submit'])) {

    echo'<body bgcolor="#155271" leftmargin="0" topmargin="0" rightmargin="0" bottommargin="0">

    <form name="guestlist" method="POST" action="'.$_SERVER['PHP_SELF'].'">

      <TABLE width="395" height="119" border=0 cellPadding=3 cellSpacing=2 bgcolor="#0F364A">

        <TBODY>

          <TR>

            <TD class=mainText width="56"><b>Name</b></TD>

            <TD width="305" class=frmInput> <INPUT class=mainFormBox style="WIDTH: 320px" type="text" name="name"></TD>

          </TR>

          <TR>

            <TD class=mainText width="56"><B>Address</B></TD>

            <TD class=frmInput> <INPUT name="address" type="text" class=mainFormBox id="address" style="WIDTH: 320px"></TD>

          </TR>

          <TR>

            <TD class=mainText width="56"><b>Age</b></TD>

            <TD class=frmInput> <INPUT name="age" type="text" class=mainFormBox id="age" style="WIDTH: 320px"></TD>

          </TR>

                <TR>

            <TD class=mainText width="56"><b>Sex</b></TD>

            <TD class=frmInput> <INPUT name="sex" type="text" class=mainFormBox id="sex" style="WIDTH: 320px"></TD>

          </TR>

          <TR>

            <TD class=frmDescription width="56">&nbsp;</TD>

            <TD class=frmInput> <div align="right">

            <input type="hidden" name="submit" value="done" />

                <INPUT type=image name="submit" value="Submit" height=20 width=109 src="sendrequest.jpg" align=Submit >

              </div></TD>

          </TR>

        </TBODY>

      </TABLE>

    </form>

      </body>';

    //note that I added a new field called submit and it's hidden ..



    } else {



    /*I added addslashes() so it escape any special char in the form ..

    if you want to show your inserted record , you need to use stripslashes() to remove any slashes from the record ..

    this is only to avoid some security problems in the query ..*/



    $name=trim(addslashes($_POST['name']));

    $address=trim(addslashes($_POST['address']));

    $age=trim(addslashes($_POST['age']));

    $sex=trim(addslashes($_POST['sex']));



    $link = mysql_connect('localhost','select_user', 'password')

        or die("Could not connect");

    mysql_select_db('select_db')

        or die("Could not select database");



    $insert=mysql_query("INSERT INTO table (name, address, age, sex)

    VALUES('$name', '$address', '$age', '$sex')")or

    die('couldn\'t Insert record into database :'.mysql_error());



    echo'The Record was inserted succesfully into Database';

    }

    ?>

it should redirct the posted into itself !! now this form submits the info to itself so you don't need any other file to do the process on the submitted info ..
this one should do

btw I tried the link you provided , after I submit why does it pass the vars in the URL ?

NeverMind · #5 (**permalink**) 01-09-04, 12:16 PM

Code:

couldn't Insert record into database :
You have an error in your SQL syntax near 'table (name, address, age, sex) VALUES('NeverMind', 'Makkah', '18', 'Male')' at line 1

you need to change 'table' to the real table name in the query ..
I've seen the error which comes after submition ..

dihan · #6 (**permalink**) 01-09-04, 12:21 PM

I called the table - table as it was a test but thats probably not a good idea. I'll just chnage it to something else

dihan · #7 (**permalink**) 01-09-04, 12:26 PM

Quote:

Originally Posted by NeverMind

Code:

couldn't Insert record into database :
You have an error in your SQL syntax near 'table (name, address, age, sex) VALUES('NeverMind', 'Makkah', '18', 'Male')' at line 1

you need to change 'table' to the real table name in the query ..
I've seen the error which comes after submition ..

I just did the Type as text. Could that be a problem

Field Type Attributes Null Default Extra Action
name text No Change Drop Primary Index Unique Fulltext
address text No Change Drop Primary Index Unique Fulltext
age text No Change Drop Primary Index Unique Fulltext
sex text No Change Drop Primary Index Unique Fulltext
Check All / Uncheck All With selected: Or

NeverMind · #8 (**permalink**) 01-10-04, 02:44 AM

I've seen that you'd removed the quote in the values ..
now try this query :

Code:

INSERT INTO table (name, Address, age, sex) VALUES ('$name', '$address', '$age', '$sex')

this is really strange ! I don't know what is the problem ..
maybe you didn't select the right database or the table !?

dihan · #9 (**permalink**) 01-10-04, 03:35 AM

OK dont call your table - "table" or "update", that was the problem.

Thanks for the help NeverMind, I think I'm going to put you/your site on the credits for this website. :-)