MySQL Dump by PHP
<?php
$server = "myHost";
$user = "myUser";
$pass = "myPassword";
$db = "myDb";
mysql_connect($server, $user, $pass);
mysql_select_db($db);
$tables = mysql_list_tables($db);
while ($td = mysql_fetch_array($tables))
{
$table = $td[0];
$r = mysql_query("SHOW CREATE TABLE `$table`");
if ($r)
{
$insert_sql = "";
$d = mysql_fetch_array($r);
$d[1] .= ";";
$SQL[] = str_replace("\n", "", $d[1]);
$table_query = mysql_query("SELECT * FROM `$table`");
$num_fields = mysql_num_fields($table_query);
while ($fetch_row = mysql_fetch_array($table_query))
{
$insert_sql .= "INSERT INTO $table VALUES(";
for ($n=1;$n<=$num_fields;$n++)
{
$m = $n - 1;
$insert_sql .= "'".mysql_real_escape_string($fetch_row[$m])."', ";
}
$insert_sql = substr($insert_sql,0,-2);
$insert_sql .= ");\n";
}
if ($insert_sql!= "")
{
$SQL[] = $insert_sql;
}
}
}
echo implode("\r", $SQL);
?>
Write to file
<?php
$text=("Hello World, Please Replace Me!");
$write_to_file=fopen("SimpleTextFile.txt","a");
fwrite($write_to_file,$text);
fclose($write_to_file);
echo ("File successfully written");
?>
PHP Doc
/**
* <<**SelectionInsertionPlaceholder**>>
*
* @copyright YourCompany
* @author YourName
* @version $Id$
**/
Added to PHP by Christopher Mioduszewski
PHP switch
switch ($op)
{
case 'op1':
//code to be executed if $op = op1;
break;
case 'op2':
//code to be executed if $op = op2;
break;
default:
//code to be executed
//if expression is different
//from both op1 and op2;
}
Added to PHP by David Reed
AMFPHP class
<?php
class service {
public function __construct() {
}
/**
* description
* @returns value
*/
function name() {
}
}
?>