← Back
Editing: classq.php
<?php $outFlds = array ('id', 'az', 'op', 'pg', 'invio'); class doQuery { function freeQuery ($sql, $typeRet) { global $conn; $rowsArr = array (); $ris = mysql_query ($sql, $conn) or die ($sql."<br>".mysql_error()); if (strpos ($sql, 'ELECT') == 1) { if ($typeRet == 0) while ($row = mysql_fetch_object ($ris)) array_push ($rowsArr, $row); else if ($typeRet == 1) while ($row = mysql_fetch_row ($ris)) array_push ($rowsArr, $row); return $rowsArr; } else return 1; } function delete () { global $table, $id; $query2 = new doQuery(); $sql = "DELETE FROM `$table` WHERE `id` = $id LIMIT 1"; $query2->freeQuery ($sql, 0); } function delPhoto ($field) { global $table, $id, $updir; $query2 = new doQuery(); $sql = "SELECT `$field` FROM `$table` WHERE `id`='$id' LIMIT 1"; $row = $query2->freeQuery ($sql, 1); if ($row[0][0] != "") unlink ($updir.$row[0][0]); } function insert ($fields, $noempty) { global $table, $id, $outFlds, $dateFlds; $query2 = new doQuery(); $ef = 0; $cond = ""; for ($i=0; $i<count($noempty); $i++) if ($fields[$noempty[$i]] == "") $ef = 1; if (!$ef) { foreach ($fields as $key=>$val) if (!in_array ($key, $outFlds)) { $fieldL.= "`$key`,"; if (in_array ($key, $dateFlds)) $valueL.= "'".data2date ($val)."',"; else $valueL.= "'".addslashes ($val)."',"; } $fieldL = rtrim ($fieldL, ','); $valueL = rtrim ($valueL, ','); $sql = "INSERT INTO `".$table."` (".$fieldL.") VALUES (".$valueL.")"; $query2->freeQuery ($sql, 0); } } function update ($fields, $noempty) { global $table, $id, $outFlds, $dateFlds; $query2 = new doQuery(); $ef = 0; for ($i=0; $i<count($noempty); $i++) if ($fields[$noempty[$i]] == "") echo $fields[$noempty[$i]];#$ef = 1; if (!$ef) { $sql = "UPDATE `$table` SET"; foreach ($fields as $key=>$val) if (!in_array ($key, $outFlds)) if (in_array ($key, $dateFlds)) $sql.= " `$key` = '".data2date ($val)."',"; else $sql.= " `".$key."` = '".addslashes ($val)."',"; $sql = rtrim ($sql, ',')." WHERE `id` = ".$id." LIMIT 1"; $query2->freeQuery ($sql, 0); } } function selectById ($typeRet) { global $table, $id; $query2 = new doQuery(); $sql = "SELECT * FROM `$table` WHERE `id` = $id LIMIT 1"; $row = $query2->freeQuery ($sql, $typeRet); return $row[0]; } function selectFldAs ($table, $fields) { global $id, $outFlds; $query2 = new doQuery(); foreach ($fields as $key=>$val) if (!in_array ($key, $outFlds)) $fieldL.= " `$key` AS `$val`,"; $fieldL = rtrim ($fieldL, ','); $sql = "SELECT $fieldL FROM `$table` WHERE `id` = $id LIMIT 1"; $row = $query2->freeQuery ($sql, 0); return $row[0]; } function selectAll ($table, $ord, $pag, $typeRet, $whCond) { global $id, $az, $perpg, $pgTot; $query2 = new doQuery(); $rowsArr = array (); if ($pag) { $cntRows = $query2->rowsCount ($table); $pgTot = ceil ($cntRows/$perpg); $limit = " LIMIT ".($perpg*($pag-1)).", $perpg"; } $sql = "SELECT * FROM `$table` WHERE 1 $whCond"; if ($az == "ed") $sql.= " AND `id` != $id"; if (count($ord)) { $sql.= " ORDER BY"; foreach ($ord as $key=>$val) $sql.= " `$key` $val,"; } $sql = rtrim ($sql, ',').$limit; $row = $query2->freeQuery ($sql, $typeRet); return $row; } function rowsCount ($table) { $query3 = new doQuery(); $sql = "SELECT COUNT(`id`) AS `count` FROM `$table` WHERE 1"; $row = $query3->freeQuery ($sql, 0); return $row[0]->count; } } ?>
Save File
Cancel