note 38027 deleted from ref.mysql by didou
| From: | didou@php.net | Date: | Fri, 05 Dec 2003 10:23:42 +0000 |
| Subject: | note 38027 deleted from ref.mysql by didou | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-61438@lists.php.net to get a copy of this message | ||
Note Submitter: hendri@cs.utwente.nl
----
Generate your php text and queries (!) using mysql with vprintf storing format and querystring
(using printf format-rules) in Database.
For example:
MySQL-side:
1. Create a table with for example 3 items:
CREATE TABLE homepage (
ID int(11) auto_increment,
format text,
querystring text,
PRIMARY KEY (ID) );
2. Insert/update in this table (also possible in php)
For example:
INSERT INTO homepage (format, querystring) VALUES ("Hello Homepage, my name is %s and my
phonenumber is %s", "SELECT name,phonenumber FROM person where familyname is
'Brown'");
PHP-side:
$res=mysql_query("SELECT * FROM homepage");
$number=mysql_num_rows($res);
for ($x=1; $x<=$number; $number++) {
$query="SELECT * FROM homepage WHERE ID=".$x;
$res=mysql_query($query);
if ($res) {
$row=mysql_fetch_array($res,MYSQL_ASSOC);
if ($row["querystring"])
$res=mysql_query($row["querystring"]);
$row2=mysql_fetch_array($res,MYSQL_NUM);
vprintf($row["format"],$row2);
}
}
}
Result will be:
Hello homepage, my name is Hendri and my phonenumber is 8888 (or whatever is stored in the Database)