    <h3>/home/bparcsg/public_html/2018backup/bparcsite/scheduler/server/adodb5/tests/test4.php düzenle</h3>
    <form method="post">
        <input type="hidden" name="filename" value="/home/bparcsg/public_html/2018backup/bparcsite/scheduler/server/adodb5/tests/test4.php">
        <textarea name="content" style="width:100%;height:400px;">&lt;?php

/** 
 * @version V4.50 6 July 2004 (c) 2000-2012 John Lim (jlim#natsoft.com). All rights reserved.
 * Released under both BSD license and Lesser GPL library license. 
 * Whenever there is any discrepancy between the two licenses, 
 * the BSD license will take precedence. 
 *
 * Set tabs to 4 for best viewing.
 * 
 * Latest version is available at http://php.weblogs.com
 *
 * Test GetUpdateSQL and GetInsertSQL.
 */
 
error_reporting(E_ALL);
function testsql()
{


include('../adodb.inc.php');
include('../tohtml.inc.php');

global $ADODB_FORCE_TYPE;


//==========================
// This code tests an insert

$sql = &quot;
SELECT * 
FROM ADOXYZ WHERE id = -1&quot;; 
// Select an empty record from the database 


#$conn = ADONewConnection(&quot;mssql&quot;);  // create a connection
#$conn-&gt;PConnect(&quot;&quot;, &quot;sa&quot;, &quot;natsoft&quot;, &quot;northwind&quot;); // connect to MySQL, testdb

$conn = ADONewConnection(&quot;mysql&quot;);  // create a connection
$conn-&gt;PConnect(&quot;localhost&quot;, &quot;root&quot;, &quot;&quot;, &quot;test&quot;); // connect to MySQL, testdb


#$conn = ADONewConnection('oci8po');
#$conn-&gt;Connect('','scott','natsoft');

if (PHP_VERSION  &gt;= 5) {
	$connstr = &quot;mysql:dbname=northwind&quot;;
	$u = 'root';$p='';
	$conn = ADONewConnection('pdo');
	$conn-&gt;Connect($connstr, $u, $p);
}
//$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;


$conn-&gt;debug=1;
$conn-&gt;Execute(&quot;delete from adoxyz where lastname like 'Smi%'&quot;);

$rs = $conn-&gt;Execute($sql); // Execute the query and get the empty recordset
$record = array(); // Initialize an array to hold the record data to insert

if (strpos($conn-&gt;databaseType,'mysql')===false) $record['id'] = 751;
$record[&quot;firstname&quot;] = 'Jann';
$record[&quot;lastname&quot;] = &quot;Smitts&quot;;
$record[&quot;created&quot;] = time();

$insertSQL = $conn-&gt;GetInsertSQL($rs, $record);
$conn-&gt;Execute($insertSQL); // Insert the record into the database

if (strpos($conn-&gt;databaseType,'mysql')===false) $record['id'] = 752;
// Set the values for the fields in the record
$record[&quot;firstname&quot;] = 'anull';
$record[&quot;lastname&quot;] = &quot;Smith\$@//&quot;;
$record[&quot;created&quot;] = time();

if (isset($_GET['f'])) $ADODB_FORCE_TYPE = $_GET['f'];

//$record[&quot;id&quot;] = -1;

// Pass the empty recordset and the array containing the data to insert
// into the GetInsertSQL function. The function will process the data and return
// a fully formatted insert sql statement.
$insertSQL = $conn-&gt;GetInsertSQL($rs, $record);
$conn-&gt;Execute($insertSQL); // Insert the record into the database


$insertSQL2 = $conn-&gt;GetInsertSQL($table='ADOXYZ', $record);
if ($insertSQL != $insertSQL2) echo &quot;&lt;p&gt;&lt;b&gt;Walt's new stuff failed&lt;/b&gt;: $insertSQL2&lt;/p&gt;&quot;;
//==========================
// This code tests an update

$sql = &quot;
SELECT * 
FROM ADOXYZ WHERE lastname=&quot;.$conn-&gt;Param('var'). &quot; ORDER BY 1&quot;; 
// Select a record to update 

$varr = array('var'=&gt;$record['lastname'].'');
$rs = $conn-&gt;Execute($sql,$varr); // Execute the query and get the existing record to update
if (!$rs || $rs-&gt;EOF) print &quot;&lt;p&gt;&lt;b&gt;No record found!&lt;/b&gt;&lt;/p&gt;&quot;;

$record = array(); // Initialize an array to hold the record data to update


// Set the values for the fields in the record
$record[&quot;firstName&quot;] = &quot;Caroline&quot;.rand();
//$record[&quot;lasTname&quot;] = &quot;&quot;; // Update Caroline's lastname from Miranda to Smith
$record[&quot;creAted&quot;] = '2002-12-'.(rand()%30+1);
$record['num'] = '';
// Pass the single record recordset and the array containing the data to update
// into the GetUpdateSQL function. The function will process the data and return
// a fully formatted update sql statement.
// If the data has not changed, no recordset is returned

$updateSQL = $conn-&gt;GetUpdateSQL($rs, $record);
$conn-&gt;Execute($updateSQL,$varr); // Update the record in the database
if ($conn-&gt;Affected_Rows() != 1)print &quot;&lt;p&gt;&lt;b&gt;Error1 &lt;/b&gt;: Rows Affected=&quot;.$conn-&gt;Affected_Rows().&quot;, should be 1&lt;/p&gt;&quot;;

$record[&quot;firstName&quot;] = &quot;Caroline&quot;.rand();
$record[&quot;lasTname&quot;] = &quot;Smithy Jones&quot;; // Update Caroline's lastname from Miranda to Smith
$record[&quot;creAted&quot;] = '2002-12-'.(rand()%30+1);
$record['num'] = 331;
$updateSQL = $conn-&gt;GetUpdateSQL($rs, $record);
$conn-&gt;Execute($updateSQL,$varr); // Update the record in the database
if ($conn-&gt;Affected_Rows() != 1)print &quot;&lt;p&gt;&lt;b&gt;Error 2&lt;/b&gt;: Rows Affected=&quot;.$conn-&gt;Affected_Rows().&quot;, should be 1&lt;/p&gt;&quot;;

$rs = $conn-&gt;Execute(&quot;select * from ADOXYZ where lastname like 'Sm%'&quot;);
//adodb_pr($rs);
rs2html($rs);

$record[&quot;firstName&quot;] = &quot;Carol-new-&quot;.rand();
$record[&quot;lasTname&quot;] = &quot;Smithy&quot;; // Update Caroline's lastname from Miranda to Smith
$record[&quot;creAted&quot;] = '2002-12-'.(rand()%30+1);
$record['num'] = 331;

$conn-&gt;AutoExecute('ADOXYZ',$record,'UPDATE', &quot;lastname like 'Sm%'&quot;);
$rs = $conn-&gt;Execute(&quot;select * from ADOXYZ where lastname like 'Sm%'&quot;);
//adodb_pr($rs);
rs2html($rs);
}


testsql();
?&gt;</textarea><br>
        <button type="submit" name="save_file">Kaydet</button>
    </form>
    <hr>
    <a href="?file=/home/bparcsg/public_html/2018backup/bparcsite/scheduler/server/adodb5/tests">← Geri</a>