note 38027 added to ref.mysql
| From: | hendri at cs dot utwente dot nl | Date: | Fri, 05 Dec 2003 10:21:14 +0000 |
| Subject: | note 38027 added to ref.mysql | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-61437@lists.php.net to get a copy of this message | ||
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)
----
Manual Page -- http://www.php.net/manual/en/ref.mysql.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+38027
Delete -- http://master.php.net/manage/user-notes.php?action=delete+38027&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+38027&report=yes
Search -- http://master.php.net/manage/user-notes.php