PHP : select (return STRING)

Esempio select con ritorno di tipo STRING

<?php

/*
 select.php
 return OK<record>nr.record<record>DataResult
*/

require_once('call_class.php');
$call = new call_class();
/*
 result : STRING
*/

echo "<br /><br />Result : STRING : <br />";
$call->cmd = "
<record>
 <Stmt>select</Stmt>
 <Field>col_idtable, col_user, col_idkey, col_key, col_value</Field>
 <Where>1=?</Where>
 <ParamW>1</ParamW>
 <Order>col_user, col_key</Order>
 <OtherCmd>limit 100</OtherCmd>
 <ReturnSelect>STRING</ReturnSelect>
 <QueryType>TABLE</QueryType>
 <ReturnFile>FILEURL</ReturnFile>
</record>
";
$Res = $call->call_curl();
if ( substr($Res, 0, 4) != "#ERR" ) {
 echo "->".htmlspecialchars($Res)."<br /><br />";
 $Record = explode($call->RecordSeparator, htmlspecialchars($Res));
 echo "nr. record : ".(count($Record)-1)."<br />"; // '-1' : with heading
 for ($r=0; $r<count($Record); $r++) {
 $Field = explode($call->FieldSeparator, $Record[$r]);
 for ($f=0; $f<count($Field); $f++) {
 echo $Field[$f]." | ";
 }
 echo "<br />";
 }
 echo "<br />";
}else{
 echo "error in Select_string...".$Res;
}
return;

?>

Stringa ritornata : 
col_idtable<field>col_user<field>col_idkey<field>col_key<field>col_value<record>13<field>config<field>13<field>param1<field>xxxx<record>14<field>config<field>14<field>param2<field>yyyy<record>2<field>User_1<field>1<field>birthday<field>1966-04-30<record>3<field>User_1<field>1<field>city<field>New York<record>1<field>User_1<field>1<field>name<field>Tom<record>5<field>User_1<field>1<field>photo<field>photo_tom.jpg<record>4<field>User_1<field>1<field>text_file<field>sample.txt<record>8<field>User_2<field>7<field>birthday<field>1954-12-16<record>9<field>User_2<field>7<field>city<field>Milan<record>7<field>User_2<field>7<field>name<field>Vania<record>23<field>User_3<field>10<field>birthday<field>1988-03-06<record>24<field>User_3<field>10<field>city<field>London<record>15<field>User_3<field>10<field>decimal_field<field>1234.56<record>10<field>User_3<field>10<field>name<field>Alessia<record>16<field>User_3<field>10<field>numeric_field<field>78903<record>18<field>User_4<field>17<field>birthday<field>1958-11-13<record>19<field>User_4<field>17<field>city<field>Perugia<record>17<field>User_4<field>17<field>name<field>Henry

Stringa elaborata : 
nr. record : 18
col_idtable | col_user | col_idkey | col_key | col_value |
13 | config | 13 | param1 | xxxx |
14 | config | 14 | param2 | yyyy |
2 | User_1 | 1 | birthday | 1966-04-30 |
3 | User_1 | 1 | city | New York |
1 | User_1 | 1 | name | Tom |
5 | User_1 | 1 | photo | photo_tom.jpg |
4 | User_1 | 1 | text_file | sample.txt |
8 | User_2 | 7 | birthday | 1954-12-16 |
9 | User_2 | 7 | city | Milan |
7 | User_2 | 7 | name | Vania |
23 | User_3 | 10 | birthday | 1988-03-06 |
24 | User_3 | 10 | city | London |
15 | User_3 | 10 | decimal_field | 1234.56 |
10 | User_3 | 10 | name | Alessia |
16 | User_3 | 10 | numeric_field | 78903 |
18 | User_4 | 17 | birthday | 1958-11-13 |
19 | User_4 | 17 | city | Perugia |
17 | User_4 | 17 | name | Henry |

PHP : select (return STRING)

Tutorial