Sveiki.
Vēlos, lai jūs novērtējat, palabojat šo mysql klasi, gaidu ari ieteikumus, ko uzlabot, pielikt klāt vai atnemt nost :)
Links uz klases kodu..
http://paste.php.lv/c2d23691ef207838132e68e189b81b3d?lang=php
Uzlabotā versija:
http://paste.php.lv/fa459bd4fef70eb6b381ac373eac9c0d?lang=php
Upgrade 2:
http://paste.php.lv/9cb55f79745bdddf0c6ff381c055c6ac?lang=php
Daži piemēriņi kā lietot klasi.
//mysql savienojuma izveide
include("../secure/classes/mysql.class.php");
$sql = new MySQL("elisits", "elisitsparole", "elisits");
$sql->query("INSERT INTO users VALUES('', 'Trac3', 'parole')");
$sql->query("INSERT INTO users VALUES('', %s, %s)", "lietotajs", "parole");
$sql->query("INSERT INTO users VALUES('', 'Trac3 otrais', 'parole')");
$sql->query("INSERT INTO users VALUES('', %s, %s)", "lietotajs otrais", "parole");
$data = $sql->getResult("SELECT * FROM users");
for($i=0;$i<count($data);$i++){
echo $data[$i]->UID." - ".$data[$i]->name." - ".$data[$i]->pass."<br />";
}
echo $sql->getVar("SELECT name FROM users WHERE UID=2")."<br />";
$sql->query("SELECT * FROM users WHERE UID < 3");
$data2 = $sql->getResult();
for($i=0;$i<count($data2);$i++){
echo $data2[$i]->UID." - ".$data2[$i]->name." - ".$data2[$i]->pass."<br />";
}
$data3 = $sql->getRow();
echo $data3->UID." - ".$data3->name." - ".$data3->pass."<br />";
$data3 = $sql->getRow(false, 1); // x un y skaitishana no nulles :)
echo $data3->UID." - ".$data3->name." - ".$data3->pass."<br />";
echo $sql->getVar()."<br />";
echo $sql->getVar(false, 2, 1)."<br />";
$sql->query("SELECT * FROM hkfadjs"); //neeksistejosha tabula lai apskatitos kludas pazinojumu :)
echo $sql->getError();