Need help inserting database info into HTML

kwblue

Hello,

I have some information in MySQL and an HTML template file. The HTML file right now has placeholders in it instead of the information that I want. Currently to update my website I use search and replace across some of the files.

Here is some code:

$database->setQuery( $query );
$rows =$database->loadObjectList();
$total = count( $rows );

foreach ($rows as $row){

$cid = $row->ContentID;
$cont = $row->Content;
$mytext = "<table border=1><tr><td>%s</td><td>%s</td></tr></table>";

echo sprintf($mytext, $cid, $cont);
}

This is just an example of pulling my information out and putting it into some kind of format...

What I would like to do, is use this idea.. Except replace about 10 items with 10 variables from my database. The file is just a text file with HTML code in it. Within that I would replace the information and output it to the screen.

Hope that makes sense and that someone can help me along!

Thanks!

sneakyimp

I'm not exactly an expert on the performance of search-and-replace functions, but there are quite a few that exist in php.

My advice would be to make really obvious, unique placeholder text in my html template...something like:

<html>
<body>
Welcome, %%%USERNAME%%%
</body>
</html>

then i would read the HTML template into a string variable using a php function like file_get_contents(). once you have the html template in a string variable, you can use something like ereg_replace() or preg_replace() or perhaps even str_replace().

this may not be the most efficient way to do it, but it's pretty simple. i know that phpBB uses some sort of template structure...it's a bit more complicated...and i think it had some kind of security issue that you have to be really careful about.

you can also check out TinyButStrong....not sure where to find it. it's a little php project which, if i remember correctly, does exactly what you want.

studenthelp

I am having the same problem with the connection and html and ms access. I am making a guestbook but my code is not connecting to the database. The code in asp look like the following:

<% @language = vbscript %>
<% Option Explicit %>
<%Response.Buffer = false %>
<script language = vbscript runat = server>

Dim connObj, rsObj, strSQL, cmdObj
Dim AddName, AddPhone, AddE-mail, AddComments

Set connObj = Server.CreateObject("ADODB.Connection")

connObj.Open="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath

("F:/Senior Project/Contact_Info.mdb")
'connObj.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath
("Contact_Info.mdb") )

Set cmdObj = Server. CreateObject ("ADODB. Command")
cmdObj .ActiveConnection = connObj
Set rsObj = Server.CreateObject("ADODB.Recordset")

AddName = Request. Form ("Name" )
AddPhone = Request.Form ("Phone")
AddE-mail = Request. Form ("E-mail" )
AddComments = Request. Form ("Comments")

strSQL = "INSERT INTO Contact Information (Name,Phone,E-mail,Comments)"
strSQL = strSQL & "VALUES ("
strSQL = strSQL & "'" & AddName & "',"
strSQL = strSQL & "'" & AddLNAME & "',"
strSQL = strSQL & "'" & AddFNAME & "',"
strSQL = strSQL & "'" & AddCAM & "')"

cmdObj.CommandText = strSQL
cmdObj.Execute
connObj .Close

</script>

and i was wondering if the same code is suppose to be in the html code.

sneakyimp

studenthelp:

This is not an ASP forum. That is a microsoft technology. If you want help for that, you are going to need to find a different forum. This site is dedicated to PHP, not ASP. Maybe you can call Micro$oft tech support?