Difference between revisions of "Php"
Line 14: | Line 14: | ||
===PHP questions=== | ===PHP questions=== | ||
====howto MYSQL -> JSON==== | |||
<syntaxhighlight> | |||
$sth = mysql_query("SELECT ..."); | |||
$rows = array(); | |||
while($r = mysql_fetch_assoc($sth)) { | |||
$rows[] = $r; | |||
} | |||
print json_encode($rows); | |||
<syntaxhighlight> | |||
===misc=== | |||
====howto see if a character is in a string==== | |||
you need the ! to test if $somechar==";" (strcmp returns 0 if true) | |||
*if(!strcmp($somechar, ";")) { | |||
:as seen in assess/wikiquiz/wikivo2db.php | |||
to get from text area w/o losing linebreaks | |||
*$apage=nl2br(stripslashes($_POST[apage])); | |||
to iterate through the lines in a string | |||
*foreach (preg_split("/(\r?\n)/", $apage) as $line) | |||
===refs=== | |||
[http://www.php-editors.com/articles/simple_php_classes.php good class tutorial] | |||
http://www.weberdev.com/Manuals/PHP/function.get-meta-tags.html | |||
authentication script http://sitebuilt.net/w/index.php?title=Comp&action=edit§ion=9 | |||
====howto - populate multi-dimensional arrays ==== | |||
<poem> | |||
/*multi-dimensional arrays */ | |||
$a = array(); | |||
$a[0][0] = "a"; | |||
$a[0][1] = "b"; | |||
$a[1][0] = "y"; | |||
$a[1][1] = "z"; | |||
$firephp->log($a, 'nearrtest'); | |||
</poem> |
Revision as of 10:13, 17 January 2013
bits of code I always forget
stdclass-storing-data-object-instead-array
reading command line arguments
<syntaxhighlight> <?php echo count($argv); if (count($argv)<2){ //if no command line argument echo("script requires command line argument with name of db to backup"); exit(); } $db = $argv[1]; ?> </syntaxhighlight>
PHP questions
howto MYSQL -> JSON
<syntaxhighlight> $sth = mysql_query("SELECT ..."); $rows = array(); while($r = mysql_fetch_assoc($sth)) {
$rows[] = $r;
} print json_encode($rows); <syntaxhighlight>
misc
howto see if a character is in a string
you need the ! to test if $somechar==";" (strcmp returns 0 if true)
- if(!strcmp($somechar, ";")) {
- as seen in assess/wikiquiz/wikivo2db.php
to get from text area w/o losing linebreaks
- $apage=nl2br(stripslashes($_POST[apage]));
to iterate through the lines in a string
- foreach (preg_split("/(\r?\n)/", $apage) as $line)
refs
http://www.weberdev.com/Manuals/PHP/function.get-meta-tags.html
authentication script http://sitebuilt.net/w/index.php?title=Comp&action=edit§ion=9
howto - populate multi-dimensional arrays
/*multi-dimensional arrays */
$a = array();
$a[0][0] = "a";
$a[0][1] = "b";
$a[1][0] = "y";
$a[1][1] = "z";
$firephp->log($a, 'nearrtest');