mysql content management with php

[je_vaughn]

Hi,
I have been reading all the post here and i want to thank all the people that take time out to help out us newbies.

I have created a site for my community in which people can come in and places ads about their pets and so forth.
the site works but what i want to do is once they place their ad it gets inserted in to the database and it is inmidiately available in the results page.

so my first issue is , I would like to find a way to put that ad on "hold" until i review the ad, and then once i see is ok, then i will publish it. but i don't know how to go about this.

second issue is that on the page (form) they insert the ad information once they click submit, it takes the data in to the database and the get redirected to a thank you page. the problem with this is that when they click the back button on the browser they go back to the input form, and all the data they just inputted still sitting there. if they were to click on the submit button again it will create the same ad again, thus having the possibility of having an infinite number of duplicated ads.
Again i find myself lost on this. Dont know how to go about disabiling the ability of going back to the form wiith just the browser back button.

what i am using is PHP 4 and mysql 3.23 ( i am using these old versions due to my hosting service).

Thanks in advance for all help you can throw my way.

🙂

[leatherback]

hold option:

Add a colum to the database holding the adds, called "public", value 1 and 0. default is 0. You have the option to OK it: set it to one.

Select against that colum in your query

Resubmit issue:
Do not try to stop them from resubmitting. Query the database against the title / content / userid / or whatever colum you need can distinguish posts. (User & titl?). If there is a match, just forward them to a page saying "The record was inserted":

j.

[je_vaughn]

Thank you for your quick reponse leatherback , it must have been less than 5 minutes. 🙂

Ok i undertand what you mean. i already created a new field, called it "public" and assigned a default value of 0. it works, but since i am using dreamweaver, i dont know much about codes. so if you would be so kind, could you tell me where in the code should i query for the field "public". how do i add this to my existing script. ??

here is a copy of the code i am using:

$currentPage = $_SERVER["PHP_SELF"];

$maxRows_RScomvenautos = 100;
$pageNum_RScomvenautos = 0;
if (isset($GET['pageNum_RScomvenautos'])) {
$pageNum_RScomvenautos = $GET['pageNum_RScomvenautos'];
}
$startRow_RScomvenautos = $pageNum_RScomvenautos * $maxRows_RScomvenautos;

mysql_select_db($database_comvenautos, $comvenautos);
$query_RScomvenautos = "SELECT * FROM comvenautos";
$query_limit_RScomvenautos = sprintf("%s LIMIT %d, %d", $query_RScomvenautos, $startRow_RScomvenautos, $maxRows_RScomvenautos);
$RScomvenautos = mysql_query($query_limit_RScomvenautos, $comvenautos) or die(mysql_error());
$row_RScomvenautos = mysql_fetch_assoc($RScomvenautos);

if (isset($GET['totalRows_RScomvenautos'])) {
$totalRows_RScomvenautos = $GET['totalRows_RScomvenautos'];
} else {
$all_RScomvenautos = mysql_query($query_RScomvenautos);
$totalRows_RScomvenautos = mysql_num_rows($all_RScomvenautos);
}
$totalPages_RScomvenautos = ceil($totalRows_RScomvenautos/$maxRows_RScomvenautos)-1;

$queryString_RScomvenautos = "";
if (!empty($SERVER['QUERY_STRING'])) {
$params = explode("&", $SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_RScomvenautos") == false &&
stristr($param, "totalRows_RScomvenautos") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_RScomvenautos = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_RScomvenautos = sprintf("&totalRows_RScomvenautos=%d%s", $totalRows_RScomvenautos, $queryString_RScomvenautos);
?>

Thanks again for your time.