Location: PHPKode > scripts > Perfect Database File > perfect-database-file-2/dbf_test.php
<?php

$sql = "SElEcT * from tabela1 WherE  `id` >  't ORDERe\'ste' or `numerico` > 5.98 OR numero2n <= 6.98 OR other  =  't \'\'\'r LIMITy' AND (`campo` != 'obadf dd fdfasaeeetaaaa' AnD campo2 <= '5' OR `numero` not LIKE 3.19 AND `oid` not LIkE 'bosjfhdsbf jdshfasdsa \'b') and trf LIKE 'dfsf' ORDeR by hjg,teste limit 9";

$sql = "SELECT * FROM clientes limit 1 order by id desc,dominio	limit 0,8";

$sql = "SELECT teste,oid,trs FROM tabela1   ORDER BY list1,list2 DESC, hjg DESC,`teste` ASC,asc desc,campo5, campo6  LIMIT 9";

$sql = "SELECT teste,oid,trs FROM tabela1 WHERE  id>'t ORDERe\'ste'  AND other='t \'\'\'r LIMITy' AND (campo != 'obaaaaa' OR oid NOT LIKE 'bosasdsa \'b') AND trf LIKE 'dfsf' ORDER BY hjg,teste";

$sql = "SELECT teste,oid,trs FROM tabela1 WHERE  id>'t ORDERe\'ste'  AND other='t \'\'\'r LIMITy' AND (campo != 'obaaaaa' OR oid NOT LIKE 'bosasdsa \'b') AND trf LIKE 'dfsf' LIMIT 9,15 ORDER BY hjg,teste DESC";

$sql = "INSeRT INTo `clientes` values (0,0,4.3)";

$sql = "DELETE FROM `clientes` where id=1";

$sql = "UPDATE `clientes` set dominio=null where id=2";

// Dump test
$sql = "INSERT INTO `clientes` values 
(1,'eduardo.net','Eduardo Cruz','hide@address.com','MTIz') ,
(2,'google.com.br','Mister GooGle','hide@address.com','MTIz') ,
(4,'dgfsdf.net','irene','hide@address.com','MTIz');

INSERT INTO `emails` values 
('ticketsadd',NULL,'hide@address.com','uaheuaehu','tid',1,'p','seu nome eh {nome} e seu id eh {id}. Novo ticket, id eh {tid} <br>\r\n{hostname} | {dia} | {hora}') ,
('nao_pagou',NULL,'hide@address.com','voce naum pagou',NULL,1,'p','Prezado {nome} dono do site {dominio}, <br>\r\nVoce tem ateh o dia {dia} às {hora} para pagar') ,
('boletosend','hide@address.com','hide@address.com','aeeeeeeee','var1,var2',1,'p','uhahuhahuauh\r\npara o cliente {dominio} de nome {nome}<br>\r\nsi fudeu!!!!!!!!! {var1} auhahuuhauhauh {var2} \" \' \"\r\n<br>\r\n{hostname} | {dia} | {hora}') ,
('teste','hide@address.com','hide@address.com','Teste','teste,teste2,teste3,teste5',1,'h','aewwwwwwwwwww {teste} {teste2} {id}') ,
('testex',NULL,'hide@address.com','testex','var1,var2,var3',1,'p','aew') ,
('novo_cliente',NULL,'hide@address.com','vc eh novo aki','dominio2,ftp,login,senha',1,'p','Olá {nome}, <br>\r\nVocê se cadastrou aqui no dia {dia} às {hora}. <br>\r\nSeu dominio novo é: {dominio2} <br>\r\nSeu ftp é: {ftp} <br>\r\nseu login {login} <br>\r\nsenha {senha}');

-- Tabela operadores

INSERT INTO `operadores` values 
(1,'eduardo','Reginaldo Silva','Geral','202cb962ac59075b964b07152d234b70');

INSERT INTO `sadicionais` values 
(5,'10000 GB de transferencia',1) ,
(3,'10gb de espa&ccedil;o em disco',30);

INSERT INTO `tickets_1` values 
(9,2,'titulo again',NULL,1,'o','Suporte',1062726300) ,
(18,1,'fydfhghfgh',1,1,'o','Suporte',1062867163) ,
(19,1,'adsasd',1,1,'c','Administra&ccedil;&atilde;o',1062867287) ,
(20,1,'fdhgfhgfh',1,NULL,'o','Financeiro',1062951886) ,
(21,4,'testeeeeeeeeeeee',NULL,1,'o','Suporte',1063740385);

INSERT INTO `tickets_2` values 
(39,21,1,'o','testeeeeeeeeeeeee de novoooooooooooooo',1063740430,'127.0.0.1') ,
(32,18,1,'c','fala tio',1062867227,'127.0.0.1') ,
(35,19,1,'o','asdasd',1062867363,'127.0.0.1') ,
(36,9,1,'o','ae {a=http://www.masterville.com.br=}link{/a} &quot;aeee&quot;',1062944921,'200.181.211.55') ,
(37,20,1,'c','hfdghgfh',1062951886,'127.0.0.1') ,
(38,21,1,'o','testeeeeeeeeeeee',1063740385,'127.0.0.1') ,
(30,9,1,'o','aew {neg}negrito{/neg} {ita}italico{/ita}',1062866738,'127.0.0.1') ,
(34,19,1,'c','dadasd',1062867287,'127.0.0.1');
";

$sql2 = "
		      CREATE TABLE `cadicionais` (
  `id` int(11) NOT NULL auto_increment key,
  `paystatus` char  NULL ,
  teste
) ,
`clientes` (
  `id` int(11) NOT NULL auto_increment key,
  `dominio` char (20000) NULL default 'vilmoca',
  money (12) not Null default 9.8
  );";

$sql2 = "drop table clientes; drop table cadicionais";
$dbf->query("drop table cadicionais");

$q = $dbf->db_query("db", $sql);
$q = $dbf->db_query("db", "SElect * from clientes");
$i=0;

// fetc_row and fetch_array
// num_rows
while ($row = $dbf->fetch_row($q))
{
	print_r($row);
	$i++;
}
echo $i;

$q2 = $dbf->query("LIST databases");
while ($row = $dbf->fetch_array($q2))
{
	print_r($row);
}

$q3 = $dbf->db_query("db", "LIST tables");
while ($row = $dbf->fetch_array($q3))
{
	print_r($row);
}

$q3 = $dbf->query("LIST fields of table clientes");
while ($row = $dbf->fetch_array($q3))
{
	print_r($row);
}
echo $dbf->result($q3, 1, "name");
echo "\n".$dbf->num_rows($q3)."\n";

$q3 = $dbf->query("show create table clientes");
$createtb = $dbf->fetch_array($q3);
	print_r($createtb);

?>
Return current item: Perfect Database File