(1) code <body bgcolor=lightgreen> <?php if( $query= mysqli_query($con, $sql) ){ echo " [$sql] 成功!<br> "; } else { echo " [$sql] 失敗!<br> "; } return $query; } $query=executeSQL($con,$sql); echo "<table bgcolor=$bgcolor border=10>"; echo "<tr bgcolor=yellow>"; $fc= mysqli_num_fields($query) ; while ($field = mysqli_fetch_field($query)){ printf("<td>%s", $field->name); } echo "<td bgcolor=cyan>EDIT"; $rowc=0; while ($row = mysqli_fetch_array($query)){ echo "<tr>"; for ($i=0;$i<$fc;$i++){ echo "<td>" . $row[$i]; } echo "<td bgcolor=white><a href='a5.php?id=" . $row[0] . "'>Edit</a>"; $rowc++; } echo "</table>"; echo "<font color=red>共計有 $rowc 筆資料。<br><hr color=red></font>"; } if (!$con) { echo "Error: " . mysqli_connect_error(); exit(); } $sql = 'set names utf8'; $query=executeSQL($con,$sql); $sql= "select id,name,amount,tel from custs"; dumpRecordSetForEdit($sql,$con,"orange"); $id=$_GET['id'];$uname="mo"; if ($id<>NULL){ $sql="select id,name,amount,tel from custs where id='$id'"; echo "待修的資料錄(id=$id)如下<br>"; dumpRecordSetForEdit($sql,$con,"green"); $query=executeSQL($con,$sql); $row = mysqli_fetch_array($query); $uname=$row[1]; $uamount=$row[2]; $utel=$row[3]; echo "請修改下列待修資料並按確定來寫入編修:"; echo "<form>"; echo "id <input type=text name=uid size=4 value=$id>"; echo "name <input type=text name=uname size=8 value=$uname >"; echo "amount <input type=text size=6 name=uamount value=$uamount>"; echo "tel <input type=text size=9 name=utel value=$utel>"; echo "<input type=submit value=Submit>"; echo "</form><hr>"; } $uid=$_GET['uid']; $uname=$_GET['uname']; $uamount=$_GET['uamount']; $utel=$_GET['utel']; if ($uname<>NULL){ $sql= "update custs set name='$uname' ,amount=$uamount ,tel='$utel' where id='$uid'"; $query=executeSQL($con,$sql); } mysqli_close ($con); ?> </body> (2) middle [set names utf8] 成功!
共計有 4 筆資料。 待修的資料錄(id=10001)如下
共計有 1 筆資料。 [select id,name,amount,tel from custs where id='10001'] 成功! [set names utf8] 成功! [select id,name,amount,tel from custs] 成功!
共計有 4 筆資料。 [update custs set name='小草8888' ,amount=1000 ,tel='08-233375' where id='10001'] 成功! |