Using Mysql query with where condition

Question

I have decoded the Json and now want to submit in the database,

How can i use this query with where condition?

if(is_array($arr)){

    $sql = "INSERT INTO wp_posts (post_title, post_type) values ";

    $valuesArr = array();
    foreach($arr as $row){

        $email = mysql_real_escape_string( $row['property_name'] );
        $post = mysql_real_escape_string( $row['post_type'] );

        $valuesArr[] = "('$email', '$post')";


    }

    $sql .= implode(',', $valuesArr);

    mysql_query($sql) or exit(mysql_error()); 
}

var_dump($arr) to check whether it is the expected two dimensional array or not — rakeshjain, Mar 06 '14 at 12:00
check this link. you should stop using `mysql_*` functions http://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php — krishna, Mar 06 '14 at 12:11

score 0 · Accepted Answer · answered Mar 06 '14 at 11:53

if(is_array($arr)){ $valuesArr = array(); foreach($arr as $row){ $email = mysql_real_escape_string( $row['property_name'] ); $post = mysql_real_escape_string( $row['post_type'] ); $sql = "update wp_posts set post_title='".$email."', post_type='".$post."' where X=Y"; mysql_query($sql) or exit(mysql_error()); } }

Using Mysql query with where condition

1 Answers1