저는 PHP를 처음 사용합니다. input type text
이제 여러 필드 데이터를 mysql db의 동일한 열에 저장하려는 양식이 있습니다.
예를 들어 위의 그림에 따르면 모든 의견을 한 열에 저장하고 모든 등급 유형을 한 열에 저장하고 싶습니다.
이 문제를 검색 한 결과 implode를 해결책으로 찾았습니다. 하지만 어떻게 사용할 수 있을지 모르겠습니다.
<table width="800" height="194" border="1" >
<tr> <td>Id</td>
<td colspan="8"><input type="text" name="company_id" value="<?php echo $row['pr_client']?>" size="5" readonly/> </td></tr>
<tr>
<td width="234" rowspan="3"><b>Opinion</b></td>
<td width="129" rowspan="3"><b>Rating Type</b></td>
<td width="74" rowspan="3"><b>Action</b></td>
<td width="89" rowspan="3"><b>Outlook</b></td>
<td height="58" colspan="4"><div align="center"><b> Ratings </b></div></td>
</tr>
<tr>
<td colspan="2"><div align="center"><b> Long Term </b> </div></td>
<td colspan="2"><div align="center"> <b> Short Term </b> </div></td>
</tr>
<tr>
<td width="55"><b>Current</b></td>
<td width="62"><b>Previous</b></td>
<td width="55"><b>Current</b></td>
<td width="66"><b>Previous</b></td>
</tr>
<tr>
<td width="234" rowspan="2"><input type="text" name="first_opinion_name" value="<?php echo $row['opinion']?>" size="32"/></td>
<td width="129" rowspan="2"><input type="text" name="first_opinion_rating_type" value="<?php echo $row['ttitle'] ?>"
size="10"/></td>
<td width="74" rowspan="2"><input type="text" name="first_opinion_action" value="<?php echo $row['atitle'] ?>" size="06"/></td>
<td width="89" rowspan="2"><input type="text" name="first_opinion_outlook" value="<?php echo $row['otitle'] ?>" size="05"/></td>
<tr>
<td width="55"><input type="text" name="first_opinion_long_term" value="<?php echo $row['ltitle'] ?>" size="05"/></td>
<td width="62"><input type="text" name="first_opinion_p_long_term" value="<?php echo $row1['ltitle'] ?>" size="05"/></td>
<td width="55"><input type="text" name="first_opinion_short_term" value="<?php echo $row['stitle'] ?>" size="05"/></td>
<td width="62"><input type="text" name="first_opinion_p_short_term" value="<?php echo $row1['stitle'] ?>" size="05"/></td>
</tr>
<tr>
<td width="234" rowspan="2"><input type="text" name="second_opinion_name" value="<?php echo $row2['opinion']?>" size="32"/></td>
<td width="129" rowspan="2"><input type="text" name="second_opinion_rating_type" value="<?php echo $row2['ttitle'] ?>"
size="10"/></td>
<td width="74" rowspan="2"><input type="text" name="second_opinion_action" value="<?php echo $row2['atitle'] ?>" size="06"/></td>
<td width="89" rowspan="2"><input type="text" name="second_opinion_outlook" value="<?php echo $row2['otitle'] ?>" size="05"/></td>
<tr>
<td width="55"><input type="text" name="second_opinion_long_term" value="<?php echo $row2['ltitle'] ?>" size="05"/></td>
<td width="62"><input type="text" name="second_opinion_p_long_term" value="<?php echo $row3['ltitle'] ?>" size="05"/></td>
<td width="55"><input type="text" name="second_opinion_short_term" value="<?php echo $row2['stitle'] ?>" size="05"/></td>
<td width="62"><input type="text" name="second_opinion_p_short_term" value="<?php echo $row3['stitle'] ?>" size="05"/></td>
</tr>
</tr>
<tr>
<td width="234" rowspan="2"><input type="text" name="third_opinion_name" value="<?php echo $row4['opinion']?>" size="32"/></td>
<td width="129" rowspan="2"><input type="text" name="third_opinion_rating_type" value="<?php echo $row4['ttitle'] ?>"size="10"/></td>
<td width="74" rowspan="2"><input type="text" name="third_opinion_action" value="<?php echo $row4['atitle'] ?>" size="06"/></td>
<td width="89" rowspan="2"><input type="text" name="third_opinion_outlook" value="<?php echo $row4['otitle'] ?>" size="05"/></td>
<tr>
<td width="55"><input type="text" name="third_opinion_long_term" value="<?php echo $row4['ltitle'] ?>" size="05"/></td>
<td width="62"><input type="text" name="third_opinion_p_long_term" value="<?php echo $row5['ltitle'] ?>" size="05"/></td>
<td width="55"><input type="text" name="third_opinion_short_term" value="<?php echo $row4['stitle'] ?>" size="05"/></td>
<td width="62"><input type="text" name="third_opinion_p_short_term" value="<?php echo $row5['stitle'] ?>" size="05"/></td>
</tr>
</tr>
<tr>
<td width="234" rowspan="2"><input type="text" name="forth_opinion_name" value="<?php echo $row6['opinion']?>" size="32"/></td>
<td width="129" rowspan="2"><input type="text" name="forth_opinion_rating_type" value="<?php echo $row6['ttitle'] ?>"size="10"/></td>
<td width="74" rowspan="2"><input type="text" name="forth_opinion_action" value="<?php echo $row6['atitle'] ?>" size="06"/></td>
<td width="89" rowspan="2"><input type="text" name="forth_opinion_outlook" value="<?php echo $row6['otitle'] ?>" size="05"/></td>
<tr>
<td width="55"><input type="text" name="forth_opinion_long_term" value="<?php echo $row6['ltitle'] ?>" size="05"/></td>
<td width="62"><input type="text" name="forth_opinion_p_long_term" value="<?php echo $row7['ltitle'] ?>" size="05"/></td>
<td width="55"><input type="text" name="forth_opinion_short_term" value="<?php echo $row6['stitle'] ?>" size="05"/></td>
<td width="62"><input type="text" name="forth_opinion_p_short_term" value="<?php echo $row7['stitle'] ?>" size="05"/></td>
</tr>
</tr>
</table>
내 Php 코드는
$first_opinion_name = $_POST['first_opinion_name'];
$first_opinion_rating_type = $_POST['first_opinion_rating_type'];
$first_opinion_action = $_POST['first_opinion_action'];
$first_opinion_outlook = $_POST['first_opinion_outlook'];
$first_opinion_long_term = $_POST['first_opinion_long_term'];
$first_opinion_p_long_term = $_POST['first_opinion_p_long_term'];
$first_opinion_short_term = $_POST['first_opinion_short_term'];
$first_opinion_p_short_term = $_POST['first_opinion_p_short_term'];
$second_opinion_name = $_POST['second_opinion_name'];
$second_opinion_rating_type = $_POST['second_opinion_rating_type'];
$second_opinion_action = $_POST['second_opinion_action'];
$second_opinion_outlook = $_POST['second_opinion_outlook'];
$second_opinion_long_term = $_POST['second_opinion_long_term'];
$second_opinion_p_long_term = $_POST['second_opinion_p_long_term'];
$second_opinion_short_term = $_POST['second_opinion_short_term'];
$second_opinion_p_short_term = $_POST['second_opinion_p_short_term'];
$third_opinion_name = $_POST['third_opinion_name'];
$third_opinion_rating_type = $_POST['third_opinion_rating_type'];
$third_opinion_action = $_POST['third_opinion_action'];
$third_opinion_outlook = $_POST['third_opinion_outlook'];
$third_opinion_long_term = $_POST['third_opinion_long_term'];
$third_opinion_p_long_term = $_POST['third_opinion_p_long_term'];
$third_opinion_short_term = $_POST['third_opinion_short_term'];
$third_opinion_p_short_term = $_POST['third_opinion_p_short_term'];
$forth_opinion_name = $_POST['forth_opinion_name'];
$forth_opinion_rating_type = $_POST['forth_opinion_rating_type'];
$forth_opinion_action = $_POST['forth_opinion_action'];
$forth_opinion_outlook = $_POST['forth_opinion_outlook'];
$forth_opinion_long_term = $_POST['forth_opinion_long_term'];
$forth_opinion_p_long_term = $_POST['forth_opinion_p_long_term'];
$forth_opinion_short_term = $_POST['forth_opinion_short_term'];
$forth_opinion_p_short_term = $_POST['forth_opinion_p_short_term'];
$query = mysql_query("INSERT INTO letter(to_name, to_designation, company, address, confidential, date, rating_type_title, opinion_type, dear_sir, company_id, first_opinion_name, first_opinion_rating_type, first_opinion_action, first_opinion_outlook, first_opinion_long_term, first_opinion_p_long_term, first_opinion_short_term, first_opinion_p_short_term, second_opinion_name, second_opinion_rating_type, second_opinion_action, second_opinion_outlook, second_opinion_long_term, second_opinion_p_long_term, second_opinion_short_term, second_opinion_p_short_term, third_opinion_name, third_opinion_rating_type, third_opinion_action, third_opinion_outlook, third_opinion_long_term, third_opinion_p_long_term, third_opinion_short_term, third_opinion_p_short_term, forth_opinion_name, forth_opinion_rating_type, forth_opinion_action, forth_opinion_outlook, forth_opinion_long_term, forth_opinion_p_long_term, forth_opinion_short_term, forth_opinion_p_short_term, y_truly, s_name, uh1, uh2, uh1_designation, uh2_designation, s_designation, chk, chk1)
values
('$to_name', '$to_designation', '$company', '$address', '$confidential', '$Date', '$rating_type_title', '$opinion_type', '$dear_sir', '$company_id', '$first_opinion_name', '$first_opinion_rating_type', '$first_opinion_action', '$first_opinion_outlook', '$first_opinion_long_term', '$first_opinion_p_long_term', '$first_opinion_short_term', '$first_opinion_p_short_term', '$second_opinion_name', '$second_opinion_rating_type', '$second_opinion_action', '$second_opinion_outlook', '$second_opinion_long_term', '$second_opinion_p_long_term', '$second_opinion_short_term', '$second_opinion_p_short_term', '$third_opinion_name', '$third_opinion_rating_type', '$third_opinion_action', '$third_opinion_outlook', '$third_opinion_long_term', '$third_opinion_p_long_term', '$third_opinion_short_term', '$third_opinion_p_short_term', '$forth_opinion_name', '$forth_opinion_rating_type', '$forth_opinion_action', '$forth_opinion_outlook', '$forth_opinion_long_term', '$forth_opinion_p_long_term', '$forth_opinion_short_term', '$forth_opinion_p_short_term', '$y_truly', '$s_name', '$uh1', '$uh2', '$uh1_designation', '$uh2_designation', '$s_designation', '$chk', '$chk1')");
echo "<br/><br/><span>Data Inserted successfully...!!</span>";
}
?>
저를 도와주세요?
아래와 같이 implode를 사용할 수 있습니다.
$users = [
"Andrew",
"Max",
"Larry",
"Ricardo",
"Lucy",
"Marcus",
"Sophie"
];
print_r(implode('-',$users));
그러나 먼저 배열에서 모든 값을 취한 다음 implode를 사용하여 db에 저장할 문자열을 형성하기 위해 다른 값을 만들어야합니다. 이 값을 사용하려면 폭발해야합니다. 이렇게하면 하나의 열만 사용할 수 있습니다.
이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.
침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제
몇 마디 만하겠습니다