http://wiki.varhoo.cz/index.php?action=history&feed=atom&title=Knihovna_php_mysql
Knihovna php mysql - Historie editací
2026-05-25T12:32:26Z
Historie editací této stránky
MediaWiki 1.19.20+dfsg-0+deb7u3
http://wiki.varhoo.cz/index.php?title=Knihovna_php_mysql&diff=678&oldid=prev
89.103.134.239 v 11. 4. 2011, 20:30
2011-04-11T20:30:55Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Starší verze</td>
<td colspan='2' style="background-color: white; color:black;">Verze z 11. 4. 2011, 20:30</td>
</tr><tr>
<td colspan="2" class="diff-lineno">Řádka 127:</td>
<td colspan="2" class="diff-lineno">Řádka 127:</td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"><div> }</div></td>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"><div> }</div></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"><div> </div></td>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"><div> </div></td>
</tr>
<tr>
<td class="diff-marker">−</td>
<td style="background: #ffa; color:black; font-size: smaller;"><div><span class="diffchange diffchange-inline"> /</span>/ ziskání všech řádků z databáze</div></td>
<td class="diff-marker">+</td>
<td style="background: #cfc; color:black; font-size: smaller;"><div>/<span class="diffchange diffchange-inline">*</span> ziskání všech řádků z databáze<span class="diffchange diffchange-inline"> */</span></div></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"><div> function fetchAll($query) {</div></td>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"><div> function fetchAll($query) {</div></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"><div> return $this->queryArray($query);</div></td>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"><div> return $this->queryArray($query);</div></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"><div> }</div></td>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"><div> }</div></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"></td>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"></td>
</tr>
<tr>
<td class="diff-marker">−</td>
<td style="background: #ffa; color:black; font-size: smaller;"><div><span class="diffchange diffchange-inline"> /</span>/ získání prvního řádku z databáze</div></td>
<td class="diff-marker">+</td>
<td style="background: #cfc; color:black; font-size: smaller;"><div>/<span class="diffchange diffchange-inline">*</span> získání prvního řádku z databáze<span class="diffchange diffchange-inline"> */</span></div></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"><div> function fetchOne($query) {</div></td>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"><div> function fetchOne($query) {</div></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"><div> return $this->queryArray($query, 1);</div></td>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"><div> return $this->queryArray($query, 1);</div></td>
</tr>
</table>
89.103.134.239
http://wiki.varhoo.cz/index.php?title=Knihovna_php_mysql&diff=677&oldid=prev
89.103.134.239 v 11. 4. 2011, 20:30
2011-04-11T20:30:10Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Starší verze</td>
<td colspan='2' style="background-color: white; color:black;">Verze z 11. 4. 2011, 20:30</td>
</tr><tr>
<td colspan="2" class="diff-lineno">Řádka 1:</td>
<td colspan="2" class="diff-lineno">Řádka 1:</td>
</tr>
<tr>
<td class="diff-marker">−</td>
<td style="background: #ffa; color:black; font-size: smaller;"><div>Jednoduchá knihovna na zpracování dotazů mysql obsažená ve frameworku <span class="diffchange diffchange-inline">"</span>Vlašský ořech<span class="diffchange diffchange-inline">"</span></div></td>
<td class="diff-marker">+</td>
<td style="background: #cfc; color:black; font-size: smaller;"><div>Jednoduchá knihovna na zpracování dotazů mysql obsažená ve frameworku <span class="diffchange diffchange-inline">[[PHP/</span>Vlašský ořech<span class="diffchange diffchange-inline">]]</span></div></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"></td>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"><div> <?php</div></td>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"><div> <?php</div></td>
</tr>
</table>
89.103.134.239
http://wiki.varhoo.cz/index.php?title=Knihovna_php_mysql&diff=676&oldid=prev
89.103.134.239 v 11. 4. 2011, 20:29
2011-04-11T20:29:15Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Starší verze</td>
<td colspan='2' style="background-color: white; color:black;">Verze z 11. 4. 2011, 20:29</td>
</tr><tr>
<td colspan="2" class="diff-lineno">Řádka 1:</td>
<td colspan="2" class="diff-lineno">Řádka 1:</td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="background: #cfc; color:black; font-size: smaller;"><div>Jednoduchá knihovna na zpracování dotazů mysql obsažená ve frameworku "Vlašský ořech"</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="background: #cfc; color:black; font-size: smaller;"></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"><div> <?php</div></td>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"><div> <?php</div></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"><div> global $__mysql;</div></td>
<td class="diff-marker"> </td>
<td style="background: #eee; color:black; font-size: smaller;"><div> global $__mysql;</div></td>
</tr>
</table>
89.103.134.239
http://wiki.varhoo.cz/index.php?title=Knihovna_php_mysql&diff=675&oldid=prev
89.103.134.239: Nová stránka: <?php global $__mysql; class db extends mysql { } class mysql { var $error = array(); var $insertId = NULL; private $link; function __construct() { glo...
2011-04-11T20:27:43Z
<p>Nová stránka: <?php global $__mysql; class db extends mysql { } class mysql { var $error = array(); var $insertId = NULL; private $link; function __construct() { glo...</p>
<p><b>Nová stránka</b></p><div> <?php<br />
global $__mysql;<br />
class db extends mysql {<br />
}<br />
<br />
class mysql {<br />
var $error = array();<br />
var $insertId = NULL;<br />
private $link;<br />
<br />
function __construct() {<br />
global $__mysql, $settings;<br />
<br />
if($__mysql == NULL) {<br />
$__mysql = mysql_connect($settings["DB_HOST"],$settings["DB_USER"],$settings["DB_PASS"]);<br />
if(!$__mysql) die("{$settings["DB_HOST"]} not found");<br />
mysql_query("SET CHARACTER SET utf8",$__mysql);<br />
mysql_query("SET NAMES utf8",$__mysql);<br />
mysql_select_db($settings["DB_NAME"],$__mysql);<br />
}<br />
$this->link = $__mysql;<br />
<br />
$this->functionArray = array("NOW()");<br />
}<br />
<br />
function insert($table,$data) {<br />
<br />
if(!is_array($data) || empty($table)) {<br />
return "NOT_DATA";<br />
}<br />
<br />
foreach($data as $key => $col) {<br />
if(in_array($col,$this->functionArray))<br />
$set[] = "`{$key}`={$col}" ;<br />
else {<br />
$col = mysql_real_escape_string($col);<br />
$set[] = "`{$key}`='{$col}'" ;<br />
}<br />
}<br />
<br />
$query = "INSERT INTO `{$table}` SET ".implode(", ",$set);<br />
<br />
$this->query($query);<br />
<br />
$this->insertId = mysql_insert_id();<br />
<br />
return $this->insertId;<br />
}<br />
<br />
function query($query) {<br />
$this->query[]=$query;<br />
<br />
$result = mysql_query($query,$this->link);<br />
$this->lastInsertId = mysql_insert_id();<br />
$error = mysql_error();<br />
<br />
if($error!=NULL) {<br />
$this->error[] = $error;<br />
$this->log();<br />
return false;<br />
}<br />
<br />
return $result;<br />
}<br />
<br />
function log(){<br />
echo "MySQL Error: ".end($this->error)."\n";<br />
}<br />
<br />
function lastInsertId() {<br />
return $this->lastInsertId;<br />
}<br />
<br />
function update($table, $data, $where = NULL,$limit=1) {<br />
<br />
foreach($data as $key => $col) {<br />
if(in_array($col,$this->functionArray))<br />
$set[] = "`{$key}`={$col}" ;<br />
else {<br />
$col = mysql_real_escape_string($col);<br />
$set[] = "`{$key}`='{$col}'" ;<br />
}<br />
}<br />
<br />
if($where != NULL){<br />
$sql = "UPDATE `{$table}` SET ".implode(", ",$set)." WHERE {$where} LIMIT {$limit}";<br />
} else {<br />
$sql = "UPDATE `{$table}` SET ".implode(", ",$set)." ";<br />
}<br />
<br />
return $this->query($sql);<br />
}<br />
<br />
function queryArray($query, $number = NULL) {<br />
<br />
$result = $this->query($query);<br />
<br />
if($result) {<br />
while($row = mysql_fetch_object($result)) {<br />
$data[] = array_map("stripslashes",(array) $row);<br />
}<br />
}<br />
<br />
if($number!=NULL)<br />
return $data[$number-1];<br />
else<br />
return $data;<br />
<br />
}<br />
<br />
function queryObject($query, $number = NULL) {<br />
<br />
$result = $this->query($query);<br />
$data = array();<br />
if($result) {<br />
while($row = mysql_fetch_object($result)) {<br />
$data[] = array_map("stripslashes",$row);<br />
}<br />
}<br />
if($number!=NULL)<br />
return $data[$number-1];<br />
else<br />
return $data;<br />
<br />
}<br />
<br />
// ziskání všech řádků z databáze<br />
function fetchAll($query) {<br />
return $this->queryArray($query);<br />
}<br />
<br />
// získání prvního řádku z databáze<br />
function fetchOne($query) {<br />
return $this->queryArray($query, 1);<br />
}<br />
<br />
}<br />
?></div>
89.103.134.239