Re: Dynamically update mysql field
| From: | sam rumaizan | Date: | Wed, 09 May 2007 11:18:31 +0000 |
| Subject: | Re: Dynamically update mysql field | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-27854@lists.php.net to get a copy of this message | ||
Copy and paste my code in your editor and run it then you will understand what I need
<------------------------------------------------start code
--------------------------------------->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<HTML>
<HEAD>
<TITLE>data</TITLE>
</HEAD>
<BODY>
<H1> <font color ="red">You can change the information in any cell and
submit it to mysql to update the original database.
Basically when the user views his/her information he/she should have the option to change the
information.</font>
</H1>
<form>
<TABLE BORDER=1 CELLSPACING=0 CELLPADDING=0 WIDTH="100%">
<TR ALIGN="CENTER">
<TH>NAME</TH>
<TH>JOB TITLE</TH>
<TH> COLOR</TH>
<TH>ADDRESS</TH>
<TH>PHONE NO</TH>
</TR>
<TR ALIGN="CENTER" HEIGHT="80" >
<TD> data form mysql :<br><b>SAM <br><input type="submit"
name="update" value="update this cell"><br><font color
="red">You can change the information and submit it to mysql to update the original
database.</font> </TD>
<TD> data form mysql :<br><b>ENGENEER </TD>
<TD> data form mysql :<br><b>RED </TD>
<TD> data form mysql :<br><b>OKLAHOMA </TD>
<TD> data form mysql :<br><b>405-12452 </TD>
</TR>
<TR ALIGN="CENTER" HEIGHT="80" >
<TD> data form mysql :<br><b>JOHN </TD>
<TD> data form mysql :<br><b>DESIGNER <br><input type="submit"
name="update" value="update this cell"><br><font color
="red">You can change the information and submit it to mysql to update the original
database.</font> </TD>
<TD> data form mysql :<br><b>BLUE </TD>
<TD> data form mysql :<br><b>COLORADO </TD>
<TD> data form mysql :<br><b>303-5458 </TD>
</TR>
<TR ALIGN="CENTER" HEIGHT="80" >
<TD> data form mysql :<br><b>MIKE</TD>
<TD> data form mysql :<br><b>STUDENT </TD>
<TD> data form mysql :<br><b>GREEN<br><input type="submit"
name="update" value="update this cell"><br><font color
="red">You can change the information and submit it to mysql to update the original
database. </font> </TD>
<TD> data form mysql :<br><b>UTAH </TD>
<TD> data form mysql :<br><b>504-5670 </TD>
</TR>
<TR ALIGN="CENTER" HEIGHT="80" >
<TD> data form mysql :<br><b>JULI</TD>
<TD> data form mysql :<br><b>TEACHER</TD>
<TD> data form mysql :<br><b>PINK<br><input type="submit"
name="update" value="update this cell"><br><font color
="red">You can change the information and submit it to mysql to update the original
database.</font> </TD>
<TD> data form mysql :<br><b>TEXES </TD>
<TD> data form mysql :<br><b>405-6364 </TD>
</TR>
</TABLE>
</form>
</BODY>
</HTML>
<------------------------------------------------End code
--------------------------------------->
Aleksandar Vojnovic <muadib@consoriana.com> wrote:
Of course it can be done, but please be more specific about what you
wish to achieve.
Aleksander
sam rumaizan wrote:
> Dynamically update mysql field
>
> I have a function that will populate the table cells (TD) with data (information) from mysql
> database.
> What I need to do is to allow the user to update the cell information (information was pulled
> from mysql database) from the table cells (TD) then the data get updated in mysql. So when I pull
> the data again I can see the new information.
> Is there any way to do this using PHP?
>
>
>
>
>
>
> ---------------------------------
> Ahhh...imagining that irresistible "new car" smell?
> Check outnew cars at Yahoo! Autos.
>
---------------------------------
Get your own web address.
Have a HUGE year through Yahoo! Small Business.