MySQL PHP HTML
1, Table_arr "" In the HTML code is saved. Used to display a table on a Web page.
2. The field of the code snippet in the database that holds Table_arr "" is in the text type.
My problem is that with one more save $table_arr[] content, such as Outstanding_thesis_tab, you can't perform an insert operation. Otherwise you can. I want to know where this problem is.
$first _step= "INSERT INTO lw_process (process_stu_num,dic_id,t_stu_select_title,p_stu_select_title,t_ter_select_ Stu,p_ter_select_stu,t_stu_select_ter,p_stu_select_ter,t_open_title,p_open_title,t_sub_original_ver,p_sub_ Original_ver,t_mid_check,p_mid_check,t_sub_final_ver,p_sub_final_ver,t_input_score,p_input_score,now_statue, Final_statue,author_promise_tab,ter_promise_tab,open_title_tab,mid_check_stu_tab,mid_check_ter_tab,tutor_score _tab,review_score_tab,reply_score_tab,complex_score_tab,reply_record_tab, Outstanding_thesis_tab) VALUES (". $_ post[' User_num ']. ",". $_post[' dic_id ']. ",". $time _arr[' T_stu_select_title ']. "', 0, '". $time _arr[' t_ter_select_ Stu ']. "', 0, '". $time _arr[' T_stu_select_ter ']. "', 0, '". $time _arr[' T_open_title ']. "', 0, '". $time _arr[' t_sub_ Original_ver ']. "', 0, '". $time _arr[' T_mid_check ']. "', 0, '". $time _arr[' T_sub_final_ver ']. "', 0, '". $time _arr[' T_ Input_score ']. "', 0,0,0, '". $table _arr[' Author's pledge of Commitment ']. "', '". $table _arr[' teacher commitment guarantee ']. "', '". $table _arr[' Report form ']. "', '". $ table_arr[' Interim check table '. "', '". $table_arr[' mid-term inspection teacher checklist '. "', '". $table _arr[' graduation thesis (Design) Guide Teachers ' performance Assessment form '. ', ' ". $table _arr[' Assessment of Teachers ' performance rating table ']." ', ' ". $table _arr[' Defense scoring table ']. "', '". $table _arr[' Comprehensive Assessment form ']. "', '". $table _arr[' defense record form ']. "', '". $table _arr[' Excellent paper recommendation table '].
$first _step_rec = mysql_query ($first _step, $conn);
Reply to discussion (solution)
$first _step_rec = mysql_query ($first _step, $conn) or Die (Mysql_error ()); What's wrong with that?
$first _step_rec = mysql_query ($first _step, $conn) or Die (Mysql_error ()); What's wrong with that?
I can't debug now, the database is in the company. $first _step_rec = mysql_query ($first _step, $conn). This sentence executes $FIRST_STEP_REC use isset to judge the result is false
Var_dump (), with isset cannot be false
Var_dump (), with isset cannot be false
$first _step_rec = mysql_query ($first _step, $conn);
Well, not isset ();
My judgment statement is
if ($first _step_rec)
echo "OK";
However, the results are not output.
In the SQL command you gave
Field List is 31 fields
The parameter list is 30 items
The two don't match, of course it's going to be an error
In the SQL command you gave
Field List is 31 fields
The parameter list is 30 items
The two don't match, of course it's going to be an error
It's all 31, and I counted 3. I wonder if the field content is too long. The HTML code is stored in my table_arr['. Will there be too many and other restrictions, I am a novice, this problem is in trouble. It's not a two-step walk. It will either insert 10 tables or insert two tables (I am divided into 10 tables once, two tables 1 times).
Ask you to post a mysql_error (); After the results, everything is clear.
Ask you to post a mysql_error (); After the results, everything is clear.
Yes, thank you for reminding me, but that code was shot right out of the bucket. Learned the Mysql_error () this. I'll pay attention next time.