Php notes
From DreamsteepWiki
|
PRINT HTML FROM AN ARRAY
<html>
<head>
</head>
<body>
<?php
$TESTOUTPUT = array('a','b','c');
$size = count($TESTOUTPUT);
print '<table border="1">';
for ($a=0;$a<$size;$a++)
{
print '<tr><td>'.$TESTOUTPUT[$a].'</td><td>Row 1 Cell 2</td></tr>';
}
print '</table>';
?>
</body>
</html>
GET THE QUERY STRING FROM URL
$QUERYSTR= ( $_SERVER['QUERY_STRING'] ); echo $QUERYSTR;
RUN A PYTHON
<?php
print ( shell_exec("python ./butt.py") ) ;
echo "ALL DONE ";
?>
primes = [0,1,2,5,10] print '<table><tr><td colspan="2"><h2>list of primes</h2></td></tr>' for x in range(len(primes)): print x print '</table>' raw_input()
FILE IO
READ A FILE
<html>
<head>
</head>
<body>
<?php
$myFile = "C://file.TXT";
$fh = fopen($myFile, 'r');
$theData = fgets($fh);
fclose($fh);
echo $theData;
?>
</body>
</html>
ARRAYS , VARIABLES
$foo= get_loaded_extensions(); print $foo[0];
IF STATEMENTS
if ($link=pg_connect($connect_parametrs))
{
print "oH HAI !";
}
WEB STUFF
get server IP address
$serverIP=$_SERVER['REMOTE_ADDR']; echo "document.write(\"Your IP address is: <b>" . $serverIP . "</b>\")";
$foo= get_loaded_extensions();
$size = count($foo);
for ($a=0;$a<$size;$a++)
{
print $foo[$a];
print "\n";
}
RUN A COMMAND FROM PHP
<?php
print ( shell_exec("ls C:/") ) ;
echo "ALL DONE ";
?>
DATABASES
SQL AND PHP
<?php
$my_sqli = new mysqli("localhost" ,"user","password","database");
if (mysqli_connect_errno() ){
printf("Connect failed %s,\n",mysqli_connect_error() );
}else{
printf("host info : %s\n",mysqli_get_host_info($mysqli)) ;
}
?>
/* Create controls */
this.controls.addControl = new OpenLayers.Control.DrawFeature(
Y.gis.layer.edit, OpenLayers.Handler.Polygon, {
'displayClass' : 'olControlDrawFeaturePolygon',
callbacks : {
"done" : this.addAction
},
title : Y.gis.translate.addControl
});
this.controls.deleteControl = new OpenLayers.Control.SelectFeature(
Y.gis.layer.edit, {
'displayClass' : 'olControlDeleteVertex',
onSelect : this.deleteAction,
title : Y.gis.translate.deleteControl
});
this.controls.editControl = new OpenLayers.Control.ModifyFeature(
Y.gis.layer.edit, {
'displayClass' : 'olControlMoveVertex',
onModificationEnd : this.editAction,
title : Y.gis.translate.editControl
});
/* Send geometries to the server */
//Add geometry
addAction: function(geometry) {
var editgeom = Y.gis.control.editgeom;
var addCallback = {
success: editgeom.addSuccess,
scope: editgeom
};
var request = YAHOO.util.Connect.asyncRequest('POST', Y.gis.config.httpPath + "/editgeom/add/geometry/" + geometry, addCallback);
},
addSuccess: function(o) {
},
//Edit geometry
editAction: function(feature) {
var editgeom = Y.gis.control.editgeom;
var editCallback = {
success: editgeom.editSuccess,
scope: editgeom
};
var request = YAHOO.util.Connect.asyncRequest('POST', Y.gis.config.httpPath + "/editgeom/update/id/" + feature.attributes.gid + "/geometry/" + feature.geometry, editCallback);
},
editSuccess: function(o) {
},
<?php
class Iagis_Validate_Geometry extends Zend_Validate_Abstract
{
const INVALID_GEOMETRY = 'invalidGeometry';
protected $_messageTemplates = array(
self::INVALID_GEOMETRY => "Invalid geometry"
);
public function isValid($value)
{
$config = Zend_Registry::get('config');
$db = Zend_Registry::get('db');
$value = $db->quote($value);
$theGeom = "geometryFromText($value, {$config->map->srid})";
$sql = "select st_isValid($theGeom) as result";
try {
$isValid = $db->fetchRow($sql)->result;
if($isValid) {
return true;
}
} catch (Zend_Db_Exception $e) {
throw new Exception(self::INVALID_GEOMETRY);
return false;
}
}
}
