php: array type으로 post해서 mysql에 update하기
글쓴이: hex2900 / 작성시간: 월, 2014/08/11 - 12:11오전
제가 어떤 db에서 어떤 조건(where)으로 select해서 데이타를 받아서 text필드와 button을 만들고 text에 입력을 하고 버튼을 누르면
post method로 다른 php에서 받은후에 update하는 기능의 php를 만들려고 합니다.
그런데 특성상 할수 없이 array type으로 text를 만들어서 전송해야 하는데요, array type으로 post하는 코드중에 문제가 있는거 같습니다.
아직 초보라서 부탁 좀 드릴께요.
감사합니다.
test.php
<html> <head> <title> question write </title> test.php <html> <head> <title> </title> </head> <body bgcolor='white' onload=input.test[0].focus();> <form method='post' action='test_exe.php' name='input'> <input type=text name=test[]> <?php $style = "style='background-color:#F7FAFA; border:1 solid black;'"; $style_hand = "style='cursor : hand;;'"; $host="localhost"; $username="root"; $userpass=""; $dbname3="answersheet"; $connect = mysql_connect($host, $username, $userpass) or die("error1."); mysql_select_db($dbname3, $connect) or die("error2."); mysql_query("set session character_set_connection=utf8;"); mysql_query("set session character_set_results=utf8;"); mysql_query("set session character_set_client=utf8;"); $result3 = mysql_query("SELECT pid, answer FROM leegyubaek WHERE examID='EN2' ") or die(mysql_error()); //ID=$id[$j] AND examID=$examid[$j] $num_rows3 = mysql_num_rows($result3); $test=array(); echo(" <script language='JavaScript'> <!-- function aclick(form) { input.submit(); } //---> </script> "); for ($i =0; $i<$num_rows3; $i++) { echo("<table width='1000' border='0' align=left> <tr> <td> <table width='30%' border='1' cellspacing='0' cellpadding='3' bordercolor='white'> <tr> <td align='left' width='1000' bgcolor='white'>$i </td> <td bgcolor='white'> <input type='text' name='test[$i]' size='10' $style> </td> </tr> </table> </td> </tr> </table> "); } echo(" <table width='500' border='1' align=left> <tr> <td> <table width='90%' border='1' cellspacing='0' cellpadding='3' bordercolor='white'> <tr bgcolor='white'> <td colspan='2' align=center> <input type='button' value='submit' $style onClick='aclick()'> <input type='reset' value='reset' $style> </td> </tr> </table> </td> </tr> </table> <br><br><br><br><br><br> "); ?> </form> </body> </html>
test_exe.php
<html> <head> <title> </title> </head> <body bgcolor='white'> <?php $test=array(); $test = $_POST['test[]']; $num = count($test); $host="localhost"; $username="root"; $userpass=""; $dbname3="answersheet"; $connect = mysql_connect($host, $username, $userpass) or die("error1."); mysql_select_db($dbname3, $connect) or die("error2."); $name="leegyubaek"; for($pid=0; $pid <$num; $pid++){ mysql_query("update $name set score ='$test[$pid]' where pid='$pid' "); } mysql_close(); echo("<script language='JavaScript'> location = 'test.php' </script> "); ?> </body> </html>
Forums:
댓글 달기