Coda Clips

php tags with echo variable

<?php echo $<<**SelectionInsertionPlaceholder**>>; ?>

Added to by ndub

Install Clip


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);
?>

Added to by Dawson

Install Clip


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");
?>

Added to by Dawson

Install Clip


Oneline print_r for php

echo "<pre>".print_r(<<**SelectionInsertionPlaceholder**>>,1)."</pre>";

Added to by Ben

Install Clip


PHP Doc

/**
 * <<**SelectionInsertionPlaceholder**>>
 *
 * @copyright YourCompany
 * @author YourName
 * @version $Id$
**/

Added to by Christopher Mioduszewski

Install Clip


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 by David Reed

Install Clip


Include

<?php
include(example.php)
?>

Added to by Chris O'Donnell

Install Clip


AMFPHP class

<?php
class service {
	public function __construct() {
	}
	/**
	 * description
	 * @returns value
	 */
	function name() {	
	}
}
?>

Added to by christian

Install Clip


Sponsored Links: