Implement If condition in PHP array

Question

I am new to PHP function. I think following problem can be solved using function. Here I am able to store html form data in database which is passed from ajax using following code. But I am little bit confused where to implement if condition. If Data has been submitted, I want to stop data replication.

My working php code

if(isset($_POST["section_name"])){
 $section_name = $_POST["section_name"];
 $class_id = $_POST["class_id"];

 for($count = 0; $count<count($section_name); $count++)
 {
     $query =$con->prepare('INSERT INTO section(class_id, section_name) VALUES (:class_id, :section_name)');
     $query->bindParam(':class_id', $class_id);
     $query->bindParam(':section_name', $section_name[$count]);
     $query->execute();
     echo "Section has been assigned";
     }   

     }

Now, I want to include above code in following else condition.

 $query =$con->query('SELECT * FROM section');
    while($row=$query->fetch(PDO::FETCH_ASSOC)){
    if(($_POST["class_id"]==$row["class_id"])&&($_POST["section_name"]==$row["section_name"])){
        echo "Section has already assigned in this class ";

    }
    else{
        // insert...
    }
    }

When I try to merge code, I can't handle. Please help me

alanfcm · Accepted Answer · 2018-04-20 18:00:30Z

1

You have pretty much everything, you just need to wrap it in a function like this:

function insert() {
    if(isset($_POST["section_name"])){
        $section_name = $_POST["section_name"];
        $class_id = $_POST["class_id"];

        for($count = 0; $count<count($section_name); $count++)
        {
            $query =$con->prepare('INSERT INTO section(class_id, section_name) VALUES (:class_id, :section_name)');
            $query->bindParam(':class_id', $class_id);
            $query->bindParam(':section_name', $section_name[$count]);
            $query->execute();
            echo "Section has been assigned";
        }   

    }
}

And then you call it like this:

$query =$con->query('SELECT * FROM section');
while($row=$query->fetch(PDO::FETCH_ASSOC)){
if(($_POST["class_id"]==$row["class_id"])&&($_POST["section_name"]==$row["section_name"])){
    echo "Section has already assigned in this class ";

}
else{
    insert();
}
}

answered Apr 20, 2018 at 18:00

alanfcm

6633 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Dipak Over a year ago

thanks it works, but echo message is looping more than once. How to echo outside of loop. So it would be echo only once

alanfcm Over a year ago

just put it outside the for loop.

Dipak Over a year ago

Oh no, I just see database, It has inserted same data twice and more. I think problem is caused calling function within while loop. How to solve ?

alanfcm Over a year ago

Instead of querying for all the records, you should use a WHERE clause comparing class_id, section_name. If it return records you know it already exists, if not then you do the insert.

Collectives™ on Stack Overflow

Implement If condition in PHP array

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related