<?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','eduardomcruz@terra.com.br','MTIz') ,
(2,'google.com.br','Mister GooGle','mistergoogle@terra.com.br','MTIz') ,
(4,'dgfsdf.net','irene','eueumesmo@irene.com','MTIz');
INSERT INTO `emails` values
('ticketsadd',NULL,'eduardo@localhost.localdomain','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,'financas@host.com.br','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','suporte@brashost.com.br','teste@terra.co','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','teste@teste.co.br','teste@teste.com.br','Teste','teste,teste2,teste3,teste5',1,'h','aewwwwwwwwwww {teste} {teste2} {id}') ,
('testex',NULL,'teste@teste.com.br','testex','var1,var2,var3',1,'p','aew') ,
('novo_cliente',NULL,'suporte@eduardohost.net','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ç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çã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} "aeee"',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);
?>
|
Stumble It!
Bookmark in del.icio.us
Download
