$params2 = array('p1' => 3, 'p2' => 4); $col = 'ID'; $setup = true; break; case 'db2': $strsql0 = 'select * from contacts where id IN (?, ?)'; $params = array(1, 3); $params2 = array(2, 4); $col = 'ID'; $setup = true; break; case 'sqlsrv': $strsql0 = 'select * from contacts where id IN (?, ?)'; $params = array(1, 3); $params2 = array(2, 4); $col = 'id'; $setup = true; break; } //***************************************************** // Are We Setup? Run Tests. //***************************************************** if ($setup) { print_array(qdb_exec($data_source, $strsql0, $params, $col, $qdba_opts)); print_array(qdb_exec($data_source, $strsql0, $params2, $col, $qdba_opts)); } else { print div($no_setup_msg, array('class' => 'message_box no_setup')); } } else { print div($no_bind_msg, array('class' => 'message_box notice')); }
$data1->data_query($strsql1); //------------------------------------------------ // Insert Row #2 //------------------------------------------------ if ($tmp_debug) { qdb_list($data_source, $strsql2, false, $qdba_opts); } else { qdb_list($data_source, $strsql2); } //------------------------------------------------ // Insert Row #3 //------------------------------------------------ if ($tmp_debug) { qdb_exec($data_source, $strsql3, $params, false, $qdba_opts); } else { qdb_exec($data_source, $strsql3, $params); } //------------------------------------------------ // Insert Row #4 //------------------------------------------------ //print_array($test_vals[3]); $contact = new contact(false); $contact->use_bind_params(); $contact->import($test_vals[3]); $print_only = false; if ($print_only && $tmp_debug) { $contact->print_only(); print $contact->save(); $contact->dump('data'); } else { $contact->save();
$affect_rows = $data1->execute(array('issss', 10, 'bob', 'bobson', 'Toowalk', 'MN')); //----------------------------------------------------------- // "qdb_list()" //----------------------------------------------------------- //$data1->execute(array('issss', 11, 'john', 'smith', 'Racine', 'WI')); qdb_list($data_source, "\n\tinsert into contacts \n\t\t(id, first_name, last_name, city, state) \n\t\tvalues \n\t\t(11, 'john', 'smith', 'Racine', 'WI')\n"); //----------------------------------------------------------- // "qdb_exec()" //----------------------------------------------------------- //$data1->execute(array('issss', 12, 'todd', 'tomom', 'Where', 'FL')); $id = 12; $fname = 'todd'; $lname = 'tomrom'; $city = 'Where'; $state = 'FL'; qdb_exec($data_source, $strsql2, array('issss', &$id, &$fname, &$lname, &$city, &$state)); //----------------------------------------------------------- // "DIO" //----------------------------------------------------------- //$data1->execute(array('issss', 13, 'ricky', 'richards', 'Here', 'OH')); // Create New Object $contact = new contact(false); $contact->use_bind_params(); $contact->set_field_data('id', 13); $contact->set_field_data('first_name', 'ricky'); $contact->set_field_data('last_name', 'richards'); $contact->set_field_data('city', 'Here'); $contact->set_field_data('state', 'OH'); //$contact->print_only(); //print $contact->save(); $contact->save();