PHP Uncategorized

How to Convert all Mysql Tables to InnoDB Script

<?php // Connect to database // ... // Get all databases $Result = @mysql_query(&#x22;show databases&#x22;); $cnt = @mysql_num_rows($Result);
 while ($cnt) { $cnt--;
 if (!($Row = @mysql_fetch_array($Result))) {
 continue;

 } 
$database = $Row[0]; 
if (Strcasecmp($database,&#x27;information_schema&#x27;)==0) continue;
 echo &#x22;+ Converting [$database]rn&#x22;; 
flush(); 
// Select database if (!@mysql_select_db($database)) continue;
 // Iterate through all tables converting them one by one $Result1 = @mysql_query(&#x22;SHOW TABLES FROM $database&#x22;); 
$cnt1 = @mysql_num_rows($Result1); 
while ($cnt1) { $cnt1--; if (!($Row1 = @mysql_fetch_array($Result1))) { continue;
 } $tablename = $Row1[0]; @mysql_query(&#x22;alter table $database.$tablename engine=innodb&#x22;);
 } } ?&#x3E;

Related Articles
Javascript Mysql PHP

PHP Radio Button Example With Mysql DB

viveik

Simple PHP Radio button enable and disable textarea textbox example in php using Mysql

techfolks php tutorials logo
Excel Using PHP Excel Using PHP and Mysql Mysql PHP Sample Programs

Export to Excel Using PHP and Mysql

viveik

Below simple program will export mysql data values to excel sheet without using any PHP libraries. Export to Excel Using PHP and Mysql <!–?php &lt;/p&gt; &lt;p&gt;//write your db connection&lt;/p&gt; &lt;p&gt;$xlsFile= ‘file_’.date(‘Y-m-d’).’.xls’; &lt;br ?–>$separator = "t";</pre> $sql = "Select * from emp"; $Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password) or die("Failed to connect: " . mysql_error() . " […]
PHP

PHP Server Common Codes To Get Values

viveik

$_SERVER[“DOCUMENT_ROOT”] === /home/user/www$_SERVER[“SERVER_ADDR”] === 143.34.112.23$_SERVER[‘HTTP_HOST’] === example.com (or with WWW)$_SERVER[“REQUEST_URI”] === /folder1/folder2/yourfile.php?var=blabla#123__FILE__ === /home/user/www/folder1/folder2/yourfile.php —>//p.s. ON WINDOWS SERVERS, instead of / is basename(__FILE__) === yourfile.php__DIR__ === /home/user/www/folder1/folder2 [same: dirname(__FILE__)]$_SERVER[“QUERY_STRING”] === var=blabla#123$_SERVER[“REQUEST_URI”] === /folder1/folder2/yourfile.php?var=blabla#123 parse_url($_SERVER[“REQUEST_URI”], PHP_URL_PATH) === /folder1/folder2/yourfile.php $_SERVER[“PHP_SELF”] === /folder1/folder2/yourfile.php//if “parentfile.php” includes this “yourfile.php”(and inside it are the codes written), and “parentfile.php?a=123” is opened, then$_SERVER[“PHP_SELF”] […]