seach MySQL data then update

uwictech · October 7, 2009

Hi all,

First of all, I am a complete novice, but I’m trying my best.

I have a data base with 6 fields, id, equ, ext, udf, udf2, udf3. I have created a web site that does various things like swap values, create new values, delete and search values.

I'm struggling with searching for a particular value then editing fields and updating it. I hope that makes sense?

Below is my code, I hope you can help.

Jamie

_{_{<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">}}

_{_<html>}

_{_<head>}

_{_{<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">}}

_{_{<title></title>}}

_{_</head>}

_{_<?php}

_{_{//connect to database}}

_{_{require("inc/conf.php");}}

_{_{if ($_POST['submit'])}}

_{_{//run ext query}}

_{_{}

_{_{$ext_form = $_POST['ext'];}}

_{_{$extract = mysql_query ("SELECT * FROM cy_equ WHERE ext='$ext_form'");}}

_{_{$numrows = mysql_num_rows ($extract);}}

_{_{while ($row = mysql_fetch_assoc($extract))}}

_{_{}

_{_{$equ = $row['equ'];}}

_{_{$ext = $row['ext'];}}

_{_{$udf = $row['udf'];}}

_{_{$udf2 = $row['udf2'];}}

_{_{$udf3 = $row['udf3'];}}

_{_}}

_{_?>}

_{_<?php}

_{_{//swap ext numbers}}

_{_{require("conf.php");}}

_{_{if ($_POST['swap'])}}

_{_{}

_{_{$exta = $_POST['exta'];}}

_{_{$extb = $_POST['extb'];}}

_{_{$result = mysql_query("SELECT id FROM cy_equ WHERE ext='$exta'");}}

_{_{$row = mysql_fetch_assoc($result);}}

_{_{$ida = $row['id'];}}

_{_{$result = mysql_query("SELECT id FROM cy_equ WHERE ext='$extb'");}}

_{_{$row = mysql_fetch_assoc($result);}}

_{_{$idb = $row['id'];}}

_{_{$update = mysql_query("UPDATE cy_equ SET ext='$extb' WHERE id='$ida'");}}

_{_{$update = mysql_query("UPDATE cy_equ SET ext='$exta' WHERE id='$idb'");}}

_{_}}

_{_?>}

_{_<?php}

_{_{//delete ext}}

_{_{$deleting=("DELETE FROM cy_equ WHERE ext='$_POST[extdelete]'");}}

_{_{if (!mysql_query($deleting))}}

_{_{}

_{_{die('Error: ' . mysql_error());}}

_{_}}

_{_?>}

_{_<?php}

_{_{//create ext}}

_{_{$insert="INSERT INTO cy_equ (equ, ext, udf, udf2, udf3) VALUES ('$_POST[equcreate]','$_POST[extcreate]','$_POST[udfcreate]','$_POST[udfcreate2]','$_POST[udfcreate3]')";}}

_{_{if (!mysql_query($insert))}}

_{_{}

_{_{die('Error: ' . mysql_error());}}

_{_}}

_{_?>}

_{_<?php}

_{_{//update ext}}

_{_{if ($_POST['search'])}}

_{_{}

_{_{$ext_formupdate = $_POST['ext'];}}

_{_{$extract = mysql_query ("SELECT * FROM cy_equ WHERE ext='$ext_formupdate'");}}

_{_{$numrows = mysql_num_rows ($extract);}}

_{_{while ($row = mysql_fetch_assoc($extract))}}

_{_{}

_{_{$id = $row['id'];}}

_{_{$equupdate = $row['equ'];}}

_{_{$extupdate = $row['ext'];}}

_{_{$udfupdate = $row['udf'];}}

_{_{$udf2update = $row['udf2'];}}

_{_{$udf3update = $row['udf3'];}}

_{_}}

_{_{if ($_POST['update'])}}

_{_{}

_{_{$sql = "UPDATE 'cy_equ' SET 'equ' = $_POST[equupdate], 'ext' = $_POST[extupdate], 'udf' = $_POST[udfupdate], 'udf2' = $_POST[udfupdate2], 'udf3' = $_POST[udfupdate3] 'id' = $_POST[id] WHERE id ='$_POST[id]'";}}

_{_{mysql_query($sql) or die(mysql_error());}}

_{_}}

_{_?>}

_{_<body>}

_{_{<div class="boxextqry">}}

_{_{<h3> Ext Query </h3>}}

_{_{<form name="form1" method="post" action="../index1.php?page=tele">}}

_{_{<p> Input Ext: <input type="number" name="ext" size="1" maxlength="4"/></p><br>}}

_{_{<p> EXT = <font color="red"><?php echo $ext; ?> </font> </p>}}

_{_{<p> EQU = <font color="red"><?php echo $equ; ?> </font></p>}}

_{_{<p> UDF = <font color="red"><?php echo $udf; ?> </font></p>}}

_{_{<p> UDF2 = <font color="red"><?php echo $udf2; ?> </font></p>}}

_{_{<p> UDF3 = <font color="red"><?php echo $udf3; ?> </font></p>}}

_{_{<p><input type="submit" name="submit" value="GET DATA"/></p>}}

_{_</form>}

_{_</div>}

_{_{<div class="boxextswap">}}

_{_{<h3> Ext Swap </h3>}}

_{_{<form name="form2" method="post" action="../index1.php?page=tele">}}

_{_{<p> Ext-A: <input type="number" name="exta" size="1" maxlength="4"/></p>}}

_{_{<p> Ext-B: <input type="number" name="extb" size="1" maxlength="4"/></p>}}

_{_{<p><input type="submit" name="swap" value="SWAP"/></p>}}

_{_</form>}

_{_</div>}

_{_{<div class="boxextdelete">}}

_{_{<h3> Ext Delete </h3>}}

_{_{<form name="form3" method="post" action="../index1.php?page=tele">}}

_{_{<p> Ext: <input type="number" name="extdelete" size="1" maxlength="4"/></p>}}

_{_{<p><input type="submit" name="delete" value="DELETE"/></p>}}

_{_</form>}

_{_</div>}

_{_{<div class="boxextcreate">}}

_{_{<h3> Ext Create </h3>}}

_{_{<form name="form4" method="post" action="../index1.php?page=tele">}}

_{_{<p> EQU: <input type="number" name="equcreate" size="8" maxlength="20"/></p>}}

_{_{<p> EXT: <input type="number" name="extcreate" size="1" maxlength="4"/></p>}}

_{_{<p> UDF: <input type="number" name="udfcreate" size="1" maxlength="4"/></p>}}

_{_{<p> UDF2: <input type="number" name="udfcreate2" size="1" maxlength="4"/></p>}}

_{_{<p> UDF3: <input type="number" name="udfcreate3" size="1" maxlength="4"/></p>}}

_{_{<p><input type="submit" name="create" value="CREATE"/></p>}}

_{_</form>}

_{_</div>}

_{_{<div class="boxextupdate">}}

_{_{<h3> Ext Update </h3>}}

_{_{<form name="form5" method="post" action="../index1.php?page=tele">}}

_{_{<p> Input Ext: <input type="number" name="ext" size="1" maxlength="4"/></p><br>}}

_{_{<p> Ext: <input type="number" name="extupdate" value="<?php echo $extupdate; ?>" size="1" maxlength="4"/></p>}}

_{_{<p> EQU: <input type="number" name="equupdate" value="<?php echo $equupdate; ?>" size="8" maxlength="20"/></p>}}

_{_{<p> UDF: <input type="number" name="udfupdate" value="<?php echo $udfupdate; ?>" size="1" maxlength="4"/></p>}}

_{_{<p> UDF2: <input type="number" name="udf2update" value="<?php echo $udf2update; ?>" size="1" maxlength="4"/></p>}}

_{_{<p> UDF3: <input type="number" name="udf3update" value="<?php echo $udf3update; ?> " size="1" maxlength="4"/></p>}}

_{_{<p> id: <input type="number" name="id" value="<?php echo $id; ?> " size="1" maxlength="4"/></p>}}

_{_{<p><input type="submit" name="search" value="SEARCH"/></p>}}

_{_{<p><input type="submit" name="update" value="UPDATE"/></p>}}

_{_</form>}

_{_</div>}

_{_</body>}

_{_</html>}

_{_</body>}

_{_</html>}

Jahren · October 7, 2009

You're going to need to be more specific

uwictech · October 7, 2009

Sorry,

Basically, I can search for information and display the results into input boxes. I would then like to maniplulate that data and click an update button to update the database.

Here is the code I currently have:-

_{<div class="boxextupdate">}

_{<h3> Ext Update </h3>}

_{<form name="form5" method="post" action="../index1.php?page=tele">}

_{<p> Input Ext: <input type="number" name="ext" size="1" maxlength="4"/></p><br>}

_{<p> Ext: <input type="number" name="extupdate" value="<?php echo $extupdate; ?>" size="1" maxlength="4"/></p>}

_{<p> EQU: <input type="number" name="equupdate" value="<?php echo $equupdate; ?>" size="8" maxlength="20"/></p>}

_{<p> UDF: <input type="number" name="udfupdate" value="<?php echo $udfupdate; ?>" size="1" maxlength="4"/></p>}

_{<p> UDF2: <input type="number" name="udf2update" value="<?php echo $udf2update; ?>" size="1" maxlength="4"/></p>}

_{<p> UDF3: <input type="number" name="udf3update" value="<?php echo $udf3update; ?> " size="1" maxlength="4"/></p>}

_{<p> id: <input type="number" name="id" value="<?php echo $id; ?> " size="1" maxlength="4"/></p>}

_{<p><input type="submit" name="search" value="SEARCH"/></p>}

_{<p><input type="submit" name="update" value="UPDATE"/></p>}

_<?php

_{//update ext}

_{if ($_POST['search'])}

_{

_{$ext_formupdate = $_POST['ext'];}

_{$extract = mysql_query ("SELECT * FROM cy_equ WHERE ext='$ext_formupdate'");}

_{$numrows = mysql_num_rows ($extract);}

_{while ($row = mysql_fetch_assoc($extract))}

_{

_{$id = $row['id'];}

_{$equupdate = $row['equ'];}

_{$extupdate = $row['ext'];}

_{$udfupdate = $row['udf'];}

_{$udf2update = $row['udf2'];}

_{$udf3update = $row['udf3'];}

_}

_{if ($_POST['update'])}

_{

_{$sql = "UPDATE 'cy_equ' SET 'equ' = $_POST[equupdate], 'ext' = $_POST[extupdate], 'udf' = $_POST[udfupdate], 'udf2' = $_POST[udfupdate2], 'udf3' = $_POST[udfupdate3] 'id' = $_POST[id] WHERE id ='$_POST[id]'";}

_{mysql_query($sql) or die(mysql_error());}

_}

_?>

Sign In

seach MySQL data then update

Recommended Posts

uwictech

Link to comment

Share on other sites

Jahren

Link to comment

Share on other sites

uwictech

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information