 |
|
คือว่าหนูจะส่ง id ไปกับลิงค์อะค่ะ เเต่มันไม่ยอมส่งไป ต้องเขียนยังไงค่ะ รบกวนด้วยนะค่ะ พอดีเขียนโค๊ดไม่เก่งอะคะ ขอบคุณล่วงหน้านะค่ะ
<?php
$con = mysqli_connect('localhost','root','rootroot','finishpj');
if($_POST['insert'] == 'insert' ){
$sql = "INSERT INTO project (name_th,name_eng,academie_year_init,advsid,academie_year_finished,type_p)
VALUES ('".$_POST["name_th"]."' ,
'".$_POST["name_eng"]."' ,
'".$_POST["academie_year_init"]."' ,
'".$_POST["advsid"]."' ,
'".$_POST["academie_year_finished"]."',
'".$_POST["type_p"]."' );";
$result = mysqli_query($con,$sql);
//echo $sql."<br>";
$sql0="select * from project where name_th = '".$_POST["name_th"]."'";
$rs0 = mysqli_query($con,$sql0);
$row = mysqli_fetch_assoc($rs0);
echo $row["project_id"]."<br>";
for($i=0;$i<count($_POST["type"]);$i++){
$sql1="select * from project where name_th = '".$_POST["name_th"]."'";
$rs1 = mysqli_query($con,$sql1);
if($rs1 && $rs1->num_rows>0){
while($row = mysqli_fetch_assoc($rs1)){
if($_POST["type"][$i] != ""){
$sql2 = "INSERT INTO project_type(type,project_id)values
('".$_POST["type"][$i]."',
'".$row["project_id"]."')";
$result2 = mysqli_query($con,$sql2);
//echo $sql2."<br>";
}
}
}
}
for($i=0;$i<count($_POST["stdid"]);$i++){
$sql3 = "select * from project where name_th = '".$_POST["name_th"]."'";
$rs = mysqli_query($con,$sql3);
//echo $sql3."<p>";
if($rs && $rs->num_rows>0){
while($row = mysqli_fetch_assoc($rs)){
if($_POST["stdid"][$i] != ""){
$sql4 = "INSERT INTO student_project(project_id, stdid)values
('".$row['project_id']."',
'".$_POST["stdid"][$i]."')";
$result4 = mysqli_query($con,$sql4);
//echo $sql4."<p>";
}
}
}
}
}
if($_POST['update'] == 'update'){
$sql5 = "UPDATE project SET
name_th = '".$_POST["name_th"]."' ,
name_eng = '".$_POST["name_eng"]."' ,
academie_year_init = '".$_POST["academie_year_init"]."' ,
advsid = '".$_POST["advsid"]."' ,
academie_year_finished = '".$_POST["academie_year_finished"]."',
type_p = '".$_POST["type_p"]."'
WHERE project_id = '".$_POST["project_id"]."' ";
$up = mysqli_query($con,$sql5);
//echo $sql5.'<br>.';
if($_POST["stdid"]!=''){
$delete1 = "delete from student_project WHERE project_id = '".$_POST["project_id"]."' ";
$rs_delete = mysqli_query($con,$delete1);
//echo $delete1.'<br>.';
for($i=0;$i<count($_POST["stdid"]);$i++){
//echo 'count :'.count($_POST["type"]);
//if($rs3 && $rs3->num_rows>0){
//while($row = mysqli_fetch_assoc($rs3)){
if($_POST["stdid"][$i] != "" && $_POST["stdid"]!= "" ){
$in = "insert into student_project(stdid,project_id) VALUES
('".$_POST["stdid"][$i]."',
'".$_POST["project_id"]."');";
;
$insert = mysqli_query($con,$in);
//echo $in.'<br>.';
}
}
}
if($_POST["type"]!=''){
$delete = "delete from project_type WHERE project_id = '".$_POST["project_id"]."' ";
$rs_delete = mysqli_query($con,$delete);
//echo $delete.'<br>.';
for($i=0;$i<count($_POST["type"]);$i++){
//echo 'count :'.count($_POST["type"]);
//if($rs3 && $rs3->num_rows>0){
//while($row = mysqli_fetch_assoc($rs3)){
if($_POST["type"][$i] != "" && $_POST["type"]!= "" ){
$sql7 = "insert into project_type(type, project_id) VALUES
('".$_POST["type"][$i]."',
'".$_POST["project_id"]."');";
;
$up2 = mysqli_query($con,$sql7);
//echo $sql7.'<br>.';
}
}
}
}
//echo 'บันทึกข้อมูลของท่านเรียบร้อย'.'<br>';
?>
<a href="show_insertproject.php?project_id=<?php echo $row["projecy_id"];?>"alt="กลับสู่หน้าหลัก">กลับสู่หน้าหลัก</a>
|
 |
 |
 |
 |
| Date :
2018-06-21 11:51:32 |
By :
chanatip |
|
 |
 |
 |
 |
|
|
 |
