Form to header.php for custom page title

carlnunes

Been searching through the forum and found a couple of related topics but still confused as to which direction to take my next step. I have a neat script working(which I will gladly share 🙂 ) and want to add an admin feature that allows user to write a custom page title to the header.php file. Also add custom text to other parts of the site so as to create a template like website.
Any ideas or comments are much appreciated!
Okay! I got the form to enter the data into the database, now how do I get it to echo between the <title> tags?

vaaaska

I followed that link and found a big tutorial that I'm not going to read. You're going to need to post the relevant code in order for us to really have any idea about what you are doing.

But, if you want to 'echo' something out between the title tags then why don't you just do that?

lozza1978

you are gonna have too explain yourself a little better,

Am i right in saying that you want to echo some sql info between the <title> tags ?,

can you please provide us with smoe more info please,

cheers

carlnunes

I actually got this to work after I read a post about the record having to be UNIQUE. I now realize that UPDATE and INSERT are two differant commands and only work in certain situations. The record "title" is origianlly blank so only INSERT will work to add a record to the field "title". UPDATE will then update an existing record. If anyone has an idea or script on how we can check for a record and either UPDATE or INSERT according to the record status, PLEASE let me know.

Okay here's what I have so far:

dbtables.sql text file:

Table structure for Website Title

#
DROP TABLE IF EXISTS per_web;

CREATE TABLE per_web (
title varchar(50)

);

header:

<?
$title = $_POST[title];
$connection = mysql_connect("localhost","username","password")
or die ("Couldn't connect to server.");
$db = mysql_select_db("sbcompse_login", $connection) or die("Couldn't select database.");
$query = "SELECT title FROM per_web";

$result = mysql_query($query);
if (!$result) {
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $query;
die($message);
}
$title = mysql_fetch_array($result);

form:

/**
Website Title
/
?>
<h3>Website Title </h3>
<FORM METHOD=POST ACTION="add.php3">
Enter the website title information to personalize this website. <br>
<input type="text" name="title">
<input type="submit" value="Website Title">
</form>
</td>
</tr>

add.php3 script:

<?
$DBhost = "localhost";
$DBuser = "username";
$DBpass = "password";
$DBName = "sbcompse_login";
$table = "per_web";
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");

@mysql_select_db("$DBName") or die("Unable to select
database $DBName");

$sqlquery = $sql = "UPDATE per_web SET title = '$title'";

$results = mysql_query($sqlquery) or die(mysql_error());

mysql_close();

print "<HTML><TITLE> PHP and MySQL </TITLE><BODY
BGCOLOR=\"#FFFFFF\"><center><table border=\"0\"
width=\"500\"><tr><td>";
print "<p><font face=\"verdana\" size=\"+0\"> <center>You
Just Entered This Information Into the
Database<p><blockquote>";
print "Website Title : $title<p></blockquote></td></tr></table>
</center></BODY></HTML>";
?>

Rodney_H_

carlnunes wrote:
If anyone has an idea or script on how we can check for a record and either UPDATE or INSERT
according to the record status, PLEASE let me know.

Why not have two pages: One to ADD a record and the second to UPDATE a record?

carlnunes wrote:

<?
$DBhost = "localhost";
$DBuser = "username";
$DBpass = "password";
$DBName = "sbcompse_login";
$table = "per_web";
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");
@mysql_select_db("$DBName") or die("Unable to select
database $DBName");
$sqlquery = $sql = "UPDATE per_web SET title = '$title'";
$results = mysql_query($sqlquery) or die(mysql_error());
mysql_close();
print "<HTML><TITLE> PHP and MySQL </TITLE><BODY
BGCOLOR=\"#FFFFFF\"><center><table border=\"0\"
width=\"500\"><tr><td>";
print "<p><font face=\"verdana\" size=\"+0\"> <center>You
Just Entered This Information Into the
Database<p><blockquote>";
print "Website Title : $title<p></blockquote></td></tr></table>
</center></BODY></HTML>";
?>

Am I missing something? How do you grab the title information from the form html onto this "add.php3 script"? Don't you need something like this???

<?php
// if posted title is not empty
if (!empty(trim($_POST['title']))){
// capture info from form
$title = trim($_POST['title']);
}
// else error message and exit.
else {
echo "you did not enter a title. please go back and try again.";
exit;
}

Also, instead of printing all the html, I recommend that you do something like this:

<?php
mysql_close();
?>

<HTML>
<head> /* don't forget this! */
<TITLE> PHP and MySQL </TITLE>
<style type="text/css">
body {
background:#FFFFFF;
}
p.message {
font-family:verdana; 
font-size:12px;
text-align:center;
}
</style>
</head>
<BODY>

<table border="0" width="500" align="center">
<tr>
<td>
<p class="message">You Just Entered This Information Into the Database:</p>
<blockquote><?php 
// pring title
print "Website Title : $title";
?></blockquote>
</td>
</tr>
</table>
</BODY>
</HTML>