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
email filters in php PHP Tips&Tricks

How to Validate Emails Using Filters in PHP

viveik

Using PHP Filters we can fully validate an email id and this filter option requires PHP 5 version. Below is the code for validating emails in PHP using filters, along with using explode and foreach loop and then inserting the correct emails in the mysql database. Multiple emails validation. Validate Emails Using Filters in PHP
PHP Sample Programs

How to Check the Last Day in Month

viveik

Check the Last Day in Month $startDate = “20150624”;$endDate = “20150722”;$startDate = strtotime($startDate);$endDate = strtotime($endDate);$dayLength = 60 * 60 * 24;$checkDateRange = ($endDate – $startDate) / $dayLength;$datesStartMonth = date(‘t’, $startDate);if ($checkDateRange > $datesStartMonth) {echo $error = “Date range should be with in one month”;}

PHP Mysql Visitor Counter Script
Mysql PHP PHP Scripts Sample Programs

PHP Mysql Visitor Counter Script

viveik

If you want to add a counter to a web page or a website then use the below simple PHP Counter Script using MySql. It is very easy to implement it and it counts whenever a page is being refreshed and the script won’t reduce page speed, unlike page counter scripts. PHP Visitor Counter Script […]