PHPize | SQLize | SQLtest

<?php $sql = 'INSERT INTO basic_table (indx, values1, values2) VALUES (:val1, :val2, :val3)'; $data = [ ":val1" => $uid, ":val2" => $ip, ":val3" => $device ]; $pdo->prepare($sql)->exexute($data); // VS. $operations['OP'] = array( "STRUCTURE" => array( 'INSERT INTO' => "basic_table (indx, values1, values2)", 'VALUES' => " (:val1, :val2, :val3)", 'VALUES' => " (:val1, :val2, :val3)" ), // structure create only by programmer this part safe from inputs "VALUES" => array( ":val1" => "$uid", ":val2" => "$ip", ":val3" => "$device" ) // binding parameters (PDO prepared st.) ); $access = new my_op($pdo); $doing_operation = $access->handle_query($operations, "@@@"); print $doing_operation;