Creating a page from a database entry?

ElphieFabalaFae

I have a database for reviews, and from it I am able to call a mini index of it's content, listing only the date of the review and the author. I currently have a 'review icon' which links to the main review on another page via the review's id in the datebase. ie fanreviewid.php where id is replaced by the numerical equivalant in the database.

Anyway, what I was wondering is rather than actually manually having to create this fanreviewid.php page, if there was a way that I could automatically create the page to a set template and by using the same input that's used when the review is initially entered into the database.

So, if I were to enter the details of a 3rd review, when hitting sumbit, the information woud be 1) stored in the database, 2)automatically create a page called fanreview3.php.

I have in the past used the following script to directly write files to localhost, and I am wondering if this is perhaps somewhere I can start to build up from. However, I am unsure about what MySQL commands should be entered and where, if it is at all possible this way! Here's the code:

<?php	

$filename = "localhost\\new\\newfile.txt";

$file = fopen( $filename, "w" );
fwrite( $file, "This text appears in my new file \n\n" );
fclose( $file );
?>

<html>

 <head>
  <title>Writing a new file</title>
 </head>

 <body>

 <?php

if( file_exists( $filename ) )
{   
  $file_length = filesize( $filename );
  $msg ="File created at $filename ";
  $msg.="containing $file_length bytes";
  echo( $msg );
}
else { echo( "Unable to create file" ); }
 ?>

 </body>

</html>

Can anyone help?

kakki

sure,
you need a table and in that a col thats TEXT-type.

after that, you can INSERT contents of reviews in that col
if you want to create the file, use the standard mysql_ commands( see php.net )
and create that file....

ElphieFabalaFae

you need a table and in that a col thats TEXT-type.

after that, you can INSERT contents of reviews in that col

I am very confused (still very new to MySQL combined with PHP). In my 'website' database, I have a table called 'reviews', which has id (int), author (text), date (date), review (text). I currently enter the reviews into the database via a form which automatically updates the contents to the database. So, is that everything you said above, or do I need to create a different, seperate table for this process?

Secondly, I never seem to be able to find my way around php.net and cannot find anything on mysql_commands. I had a look through the MySQL section of the PHP manual, but I can't seem to find anything like what I am loooking for. Am I looking in the right place, or do I need to be searching else where? Thanks

kakki

nope,just do sth like this:

// mysql_connect ...
// $id is given( id of the review in DB )
// $filename is given, ( target-file )
$q=mysql_query( "SELECT review FROM website WHERE id=".$id );
$content=mysql_fetch_row( $q );
file_put_contents( $filename, $content[ 0 ] );

kakki

on the commands:
goto php.net
search for "mysql" in commands
the result-page shows all functions( on the lower part, youll see the mysql-commands )

ElphieFabalaFae

Okay, following your advice, I've managed to create a script. Initially I couldn't get the page to load at all, but I seem to have sorted that now. Anyway, the information is now being added to the database, but I seem unable to get the page to create properly. I have a feel this has to do with the way I've written $filename, but I can't figure it out.

<html><head>
<title>Add fan reviews to localhost</title></head>
<body>

<?php

$self =  $_SERVER['PHP_SELF'];
$fan_reviews_author =    $_POST['fan_reviews_author'];
$fan_reviews_email =    $_POST['fan_reviews_email'];
$fan_reviews_date =    $_POST['fan_reviews_date'];
$fan_reviews_review =    $_POST['fan_reviews_review'];
$id = ('fan_reviews_id');
$filename = ('fanreviews$id.inc.php');

?>

<form action="<?php echo( $self ); ?>" method="post">
Author: <input type="text" name="fan_reviews_author" size="15"><br>
Email Address: <input type="text" name="fan_reviews_email" size="15"><br>
Date (1983-06-16): <input type="text" name="fan_reviews_date" size="15""><br>
Review: <textarea type="text" name="fan_reviews_review" rows="10" cols="50"></textarea><p>
<input type="submit" value="Submit">
</form>

<?php 

#adding data to the database
if( $fan_reviews_author and $fan_reviews_email and $fan_reviews_date and $fan_reviews_review )
{
$conn=@mysql_connect( "localhost", "root", "" ) or die( "Err:Conn" );

 #select the specified database
 $rs = @mysql_select_db( "website", $conn) or die( "Err:Db" );

 #create the query
 $sql = "insert into fan_reviews ( fan_reviews_author, fan_reviews_email, fan_reviews_date, fan_reviews_review ) values ( \"$fan_reviews_author\", \"$fan_reviews_email\", \"$fan_reviews_date\", \"$fan_reviews_review\" )";

 #execute query
 $rs = mysql_query( $sql, $conn );

 if( $rs )
 {
   echo( "Record added:$fan_reviews_author $fan_reviews_email $fan_reviews_date $fan_reviews_review" );
 }
}

#creating new page

#create query
$q = mysql_query( "SELECT fan_reviews_review FROM fan_reviews WHERE fan_reviews_id=".$id );

$content = mysql_fetch_row ( $q );
file_put_contents( $filename, $content[ 0 ] );

?>

</body></html>

Basically, I need it to create a fanreviews$fan_reviews_id.inc.php file. I just can't seem to get this right. I am hoping that once I have corrected this issue, there shouldn't be a problem. Can you advise?