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
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”] […]
PHP

Simple PHP Dropdown Menu Example

viveik

<html> <title>PHP Dropdown Menu Example</title> <head></head> <body> <form method=”POST” action=”phpdropdown.php”> <select name=”user”> <option value=”vivek” selected=’selected’>Vivek</option> <option value=”Raj”>Raj</option> <option value=”Vicky” >Vicky</option> </select> <input type=”submit” name=”go” value=”Go”> </form> </body> </html> <?php if(isset($_POST[“user”])) { $user = $_POST[“user”]; echo $user; } ?>  To get selected value use this < option value=”vivek” selected=’selected’>Vivek </ option>  Use this at top for […]
For Loop PHP Looping through Alphabets PHP

Using For Loop Looping through Alphabets letters

viveik

Using For Loop Looping through letters is possible for($i = ‘S’; $i != ‘AC’; $i++) {echo $i.’ ‘;} Note: $i <= ‘AC’ it only works with $i != ‘AC’  Output : S T U V W X Y Z AA AB