StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPorting a PHP script from mysql_... to PDO
primarykey
Id
18170612
data
AcceptedAnswerId
18170701
AnswerCount
3
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-08-11T09:39:38.357
FavoriteCount
0
LastActivityDate
2013-08-11T09:51:46.720
LastEditDate
LastEditorUserId
0
OwnerUserId
1264426
ParentId
0
PostTypeId
1
Score
0
ViewCount
214
LastEditorDisplayName
text
Body
I am trying to port the database backup script found on <a href="http://www.daniloaz.com/en/560/programming/backup-de-bases-de-datos-mysql-con-php/" rel="nofollow">this page</a> because it is throwing a warning that <code>mysql_...</code> is deprecated. My efforts so far are below, but the script is throwing couple errors at me that I just don't know how to solve. I'm only slightly familiar with PHP, so it is quite possible that I'm making a beginner's mistake here. The error thrown is: <pre><code>Notice: Undefined variable: db in ......../index.php on line 109 Fatal error: Call to a member function query() on a non-object in ......../index.php on line 109 </code></pre> Line 109 is (and marked with // *******): <pre><code>foreach( $db->query('SHOW TABLES') as $row ) </code></pre> I've been playing around with <code>public</code>/<code>protected</code> (for <code>initializeDatabase</code>) and <code>global</code> (for <code>$db</code>) keywords, but I'm not sure if that is the cause or if I'm doing it wrong. Can anyone easily spot what I'm doing wrong here? <hr> <pre><code><?php /** * This file contains the Backup_Database class wich performs * a partial or complete backup of any given MySQL database * @author Daniel López Azaña <http://www.daniloaz.com> * @version 1.0 */ /** * Changes by jippie: * ereg_replace("\n","\\n",$row[$j]); => preg_replace( '/\n/ , "\\n" , $row[$j] ); * mysql_... => PDO */ // Report all errors error_reporting(E_ALL); /** * Define database parameters here */ define("DB_USER", 'username'); define("DB_PASSWORD", 'password'); define("DB_NAME", 'database'); define("DB_HOST", 'localhost'); define("OUTPUT_DIR", 'cache'); define("TABLES", '*'); /** * Instantiate Backup_Database and perform backup */ $backupDatabase = new Backup_Database(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); $status = $backupDatabase->backupTables(TABLES, OUTPUT_DIR) ? 'OK' : 'KO'; echo " Backup result: ".$status; /** * The Backup_Database class */ class Backup_Database { /** * Host where database is located */ var $host = ''; /** * Username used to connect to database */ var $username = ''; /** * Password used to connect to database */ var $passwd = ''; /** * Database to backup */ var $dbName = ''; /** * Database charset */ var $charset = ''; /** * Constructor initializes database */ function Backup_Database($host, $username, $passwd, $dbName, $charset = 'utf8') { $this->host = $host; $this->username = $username; $this->passwd = $passwd; $this->dbName = $dbName; $this->charset = $charset; $this->initializeDatabase(); } protected function initializeDatabase() { $db = new PDO("mysql:host=$this->host;dbname=$this->dbName;charset=$this->charset", $this->username, $this->passwd ); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); /* JPH: mysql_... is deprecated * $conn = mysql_connect($this->host, $this->username, $this->passwd); * mysql_select_db($this->dbName, $conn); * if (! mysql_set_charset ($this->charset, $conn)) * { * mysql_query('SET NAMES '.$this->charset); * } */ } /** * Backup the whole database or just some tables * Use '*' for whole database or 'table1 table2 table3...' * @param string $tables */ public function backupTables($tables = '*', $outputDir = '.') { try { /** * Tables to export */ if($tables == '*') { $tables = array(); // $result = mysql_query('SHOW TABLES'); // while($row = mysql_fetch_row($result)) // ******* foreach( $db->query('SHOW TABLES') as $row ) { $tables[] = $row[0]; } } else { $tables = is_array($tables) ? $tables : explode(',',$tables); } $sql = 'CREATE DATABASE IF NOT EXISTS '.$this->dbName.";\n\n"; $sql .= 'USE '.$this->dbName.";\n\n"; /** * Iterate tables */ foreach($tables as $table) { echo "Backing up ".$table." table..."; // $result = mysql_query('SELECT * FROM '.$table); // $numFields = mysql_num_fields($result); $result = $db->query( 'SELECT * FROM ' . $table ); $numFields = $result->columnCount(); $sql .= 'DROP TABLE IF EXISTS '.$table.';'; // $row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table)); $result2 = $db->query( 'SHOW CREATE TABLE ' . $table ); $row2 = $result2->fetch(); $sql.= "\n\n".$row2[1].";\n\n"; for ($i = 0; $i < $numFields; $i++) { // while($row = mysql_fetch_row($result)) while( $row = $result2->fetch() ) { $sql .= 'INSERT INTO '.$table.' VALUES('; for($j=0; $j<$numFields; $j++) { $row[$j] = addslashes($row[$j]); $row[$j] = preg_replace( '/\n/' , "\\n" , $row[$j] ); if (isset($row[$j])) { $sql .= '"'.$row[$j].'"' ; } else { $sql.= '""'; } if ($j < ($numFields-1)) { $sql .= ','; } } $sql.= ");\n"; } } $sql.="\n\n\n"; echo " OK" . " "; } } catch (Exception $e) { var_dump($e->getMessage()); return false; } return $this->saveFile($sql, $outputDir); } /** * Save SQL to file * @param string $sql */ protected function saveFile(&$sql, $outputDir = '.') { if (!$sql) return false; try { $handle = fopen($outputDir.'/db-backup-'.$this->dbName.'-'.date("Ymd-His", time()).'.sql','w+'); fwrite($handle, $sql); fclose($handle); } catch (Exception $e) { var_dump($e->getMessage()); return false; } return true; } } </code></pre>
Tags
<php><pdo>
Title
Porting a PHP script from mysql_... to PDO
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USjippie
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.