Changeset 583 for trunk/pages/admin_novinky_modify.php

Timestamp:

May 7, 2009, 9:15:17 AM (15 years ago)

Author:

george

Message:

• Opraveno: Chyba v CSS stylech způsobovala špatné zobrazení rámečků tabulek a stylů dalších prvnků.
• Upraveno: Sjednocen styl různých tabulek.
• Upraveno: Přepis nejednotného přístupu k databázi přes jiné proměnné a konstanty než dle konfigurace proměnné $Config.

File:

• trunk/pages/admin_novinky_modify.php (modified) (4 diffs)

trunk/pages/admin_novinky_modify.php

@@ -22 +22 @@
 endif;
 
-mysql_connect($db_server, $db_user, $db_pass);
-  mysql_select_db($db_webu);
-  mysql_query("SET NAMES 'utf8'");
- $pocet = mysql_num_rows(mysql_query("SELECT id FROM articles $where"));
+$DbResult = $db->query("SELECT id FROM articles $where")
+$pocet = $DbResult->num_rows;
    
    if($pocet != 0):
    echo"<table align=center border=1><tr><td><b>Autor</b><td><b>Datum</b><td><b>Nadpis</b><td></tr>";
    
- $query = mysql_query("SELECT * from articles $where order by date DESC");
- while($row = mysql_fetch_array($query)){
+ $query = $db->query("SELECT * from articles $where order by date DESC");
+ while($row = $query->fetch_array($query))
+ {
  $id = $row['id'];
  echo"<tr>
@@ -52 +51 @@
  $id = $_POST['id'];
 
-mysql_connect($db_server, $db_user, $db_pass);
-  mysql_select_db($db_webu);
-  mysql_query("SET NAMES 'utf8'");
-   $query = mysql_query("SELECT * from articles where id='$id'");
+   $query = $db->query("SELECT * from articles where id='$id'");
    
-   while($row = mysql_fetch_array($query)){
+   while($row = $query->fetch_array())
+   {
    $autor = $row['autor'];
     $title = $row['title'];
@@ -112 +109 @@
           if($upravit==1 and $lvl > 0):
            
-  mysql_connect($db_server, $db_user, $db_pass);
-  mysql_select_db($db_webu);
-  mysql_query("SET NAMES 'utf8'");
-   $upravit_autor = mysql_query("update articles set autor='$autor' where id='$id'");
-   $upravit_title = mysql_query("update articles set title='$title' where id='$id'");
-   $upravit_text = mysql_query("update articles set text='$text' where id='$id'");
-   $upravit_kategorie = mysql_query("update articles set category='$kategorie' where id='$id'");
+
+   $upravit_autor = $db->query("update articles set autor='$autor' where id='$id'");
+   $upravit_title = $db->query("update articles set title='$title' where id='$id'");
+   $upravit_text = $db->query("update articles set text='$text' where id='$id'");
+   $upravit_kategorie = $db->query("update articles set category='$kategorie' where id='$id'");
   
    if($upravit_autor and $upravit_title and $upravit_text and $upravit_kategorie):
@@ -141 +136 @@
  
  ?>
-   
- 
-   
-   
-   
-   
-   
-   
-   
-   
-