Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : Article System

[brcolow]

Im gunn make this quick and to the point.
I want to have a system where my staff can write reviews to a page called name_of_game.php and that page gets linked on this page www.flashstand.com/articles.php but im clueless on how to do this part, after writing toa flatfile, i need to access certain parts of it and put i on the Name_of_game.php and also how to make that file AND how to link to it. Thanks, Mike

[CChard]

Use a database if you can. Not a flat file.

[ShockHost]

For a start, Structure the system so authorized users can input reviews in mysql database then have articles.php pull it from the database.

Im no guru, so I can't really help you much.

[brcolow]

ok ill use mysql, i have a database set up, so how do i access it and wirte the html form varibles into it AND THEN access information from it to make the article?

[ShockHost]

Im thinking your not too much of a backend man, I would say go to hotscripts.com and fetch yourself a script. I bet there are plenty to choose from then you could customise it to fit your needs.

[brcolow]

well, i dont tink this is too hard to make, and i searched hotscripts and they dont have what i need, all i need is a simple tutorial on how to write html form information to the database and then pulll that information from somewhere else using php, any website i can gom to that will explain this?

[brcolow]

Ok now, i basically have it,

PHP Code:

<?
if (!$title || !$about || !$title || !$price)
{
    echo "You have not completed all of the required feilds in your article report.<br>"
."please go back and try again.";
    exit;
}

$title = addslashes($title);
$about = addslashes($about);
$screenshots = addslashes($screenshots);
$source = addslashes($source);

@ $db = mysql_pconnect("localhost", "mike", "cool");
if (!$db)
}
    echo "Could not connect to database.";
    exit;
}
mysql_select_db("news");
$query = "inert into articles values
    ('".$title"', '".$about."', '".$screenshots"', '".$source."')";
$result = mysql_query($query);
if ($result)
    echo mysql_affected_rows()." Article insterted into database.";
?>

The thing i need to do is, make a file named $title.php so people can actually go to it, but im unclear on how to do this, thanks for the help, mike