Php

bits of code I always forget

howto - read 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>

howto - MYSQL -> JSON

<syntaxhighlight> $sth = mysql_query("SELECT ..."); $rows = array(); while($r = mysql_fetch_assoc($sth)) {

   $rows[] = $r;

} print json_encode($rows); </syntaxhighlight> or better <syntaxhighlight> <?php $pdo=new PDO("mysql:dbname=database;host=127.0.0.1","user","password"); $statement=$pdo->prepare("SELECT * FROM table"); $statement->execute(); $results=$statement->fetchAll(PDO::FETCH_ASSOC); $json=json_encode($results); ?> </syntaxhighlight>

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)

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

misc

multidimensional array

hosted/vocab/quiz/db2egg.php: uses multidimensional arrays

does sorting

• parsemeta.php
• txt2flp.pl
• parsephr.php

refs

get meta tag function

[http://sitebuilt.net/w/index.php?title=Comp&action=edit&section=9 authentication script