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

techfolks php tutorials logo
Codeigniter Email Verification Email Verification using Codeigniter Email Verification using PHP PHP Tutorials

Email Verification Confirmation Using PHP Codeigniter

viveik

Below is a simple program which shows email verification confirmation using a unique code, implemented in PHP,Mysql, Codeigniter. PHP Codeigniter Email Verification Step 1 :Create a table as shown below with email_verification_code as necessary column: [mysql] CREATE TABLE `users` ( `user_id` int(10) NOT NULL auto_increment, `first_name` varchar(45) NOT NULL, `last_name` varchar(45) NOT NULL, `email_verification_code` varchar(45) […]

techfolks php tutorials logo
PHP Uncategorized

How to use Google map Address in PHP

viveik

Let’s Start, First we Getting latitude and longitude from Address in Google Maps Using PHP. The script is given below. Google map Address in PHP In Above code, we just pass the latitude and longitude point (,). See $Lat for latitude and $Lon for longitude . In script code iset the zoom level to 5 […]
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