I am trying to create a code that will generate a webpage. Here is what I have so far. I am looking to just take data that is queried from our server and display it on a page. Their is a form that is populating the ID on the query and all the information is pulling correctly.

It's just when it comes to creating the file and page contents it's getting lost.

<?php

$id1 = $_POST["id1"];

echo $id1;

echo "<br>";

$id2 = $_POST["id2"];

echo $id2;

echo "<br>";

$id3 = $_POST["id3"];

echo $id3;

echo "<br>";

$name = $_POST["name"];

echo $name;

echo "<br>";

$string = $name."-".date("Y-m-d").".html";

echo $string;

echo "<br>";

$pagename = str_replace(' ', '', $string);//remove spaces

echo $pagename;

echo "<br>";

$newyork = ',NY';

$pagetitle = $_POST["title"];

echo $pagetitle;

echo "<br>";

$con = mysql_connect('****************', '*************', '********');

if (!$con)    

  {

  die('Could not connect: ' . mysql_error());

  }

mysql_select_db("squarefeet1", $con);

//Query

if ($id1 != null){

//Query for data

$sql="SELECT * FROM `properties` WHERE `filename` =\"".$id1."\" LIMIT 1";

$result = mysql_query($sql);

if($result === FALSE) {

    die(mysql_error()); // TODO: better error handling

}

while($row = mysql_fetch_array($result)){   

//save data



$query1address = $row['addr1'];

$query1city = $row['city'];

$query1borough = $row['neighborhood'];

$query1plotsize = $row['plotsize'];

$query1zip = $row['zip'];

}

$address1 = $query1address."\n".$query1city." ".$newyork." ".$query1zip;

echo $address1;

echo "<br>";

} 

if ($id2 != null){

//Query for data

$sql="SELECT * FROM `properties` WHERE `filename` =\"".$id2."\" LIMIT 1";

$result = mysql_query($sql);

if($result === FALSE) {

    die(mysql_error()); // TODO: better error handling

}

while($row = mysql_fetch_array($result)){   

//save data



$query2address = $row['addr1'];

$query2city = $row['city'];

$query2borough = $row['neighborhood'];

$query2plotsize = $row['plotsize'];

$query2zip = $row['zip'];

}

$address2 = $query1address."\n".$query1city." ".$newyork." ".$query1zip;

echo $address1;

echo "<br>";

}

if ($id3 != null){

//Query for data

$sql="SELECT * FROM `properties` WHERE `filename` =\"".$id3."\" LIMIT 1";

$result = mysql_query($sql);

if($result === FALSE) {

    die(mysql_error()); // TODO: better error handling

}

while($row = mysql_fetch_array($result)){   

//save data



$query3address = $row['addr1'];

$query3city = $row['city'];

$query3borough = $row['neighborhood'];

$query3plotsize = $row['plotsize'];

$query3zip = $row['zip'];

}

$address3 = $query1address."\n".$query1city." ".$newyork." ".$query1zip;

echo $address1;

echo "<br>";

}

mysql_close($con);

$filename = $pagename;

$topcontent = '<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

<title>($pagetitle)</title>

<style type="text/css" media="screen, print, projection">

body,

html {

margin:0;

padding:0;

font: 12px "Helvetica Neue", Helvetica, Arial, Geneva, sans-serif;

color: #626466; background:#ffffff;

}

a{

color: #626466;

text-decoration: underline;

}

a:hover {

color: #0080ff;

}

#wrap {

width:1166px;

margin:0 auto;

background:#ffffff;

}

#header {

margin-top: 50px;

border-bottom: 1px dashed #CCC;

width: 1100px;

max-width: 1100px;

padding-bottom: 10px;

}

#header a {

text-decoration: none;

color: #CCC;

}

h1 {

margin:0;

font-size: 46px;

letter-spacing: 1px;

text-transform: uppercase;

color: #BBB;

width: 700px;

}

#main {

float:left;

width:966px;

padding:10px 0px 10px 10px;

background:#ffffff;

border-right:1px dashed #CCC;

}

h2 {

margin:0 0 1em;

font-size: 12px;

text-transform: uppercase;

padding-bottom: 5px;

border-bottom: 1px dashed #CCC;

text-align: center;

width: 160px;

margin-top: 10px;

font-weight: normal;

letter-spacing: 1px;

}

h3 {

font-weight: normal;

font-size: 16px;

}

#sidebar {

float:right;

width:160px;

padding:10px;

color: #626466;

background:#ffffff;

}

#sidebar ul {

margin: 10px 0px 0px 0px; padding: 0px;

list-style: none;

text-transform: uppercase;

}

#sidebar li {

padding-top: 5px;

margin: 0px;

}

#sidebar a {

color: #6699ff;

text-decoration: none;

}

#sidebar a:hover {

text-decoration: underline;

}

#footer {

clear:both;

padding:5px 10px;

background:#ffffff;

}

#footer a {

color: #CCC;

text-decoration: none;

}

#footer a:hover {

color: #0080ff;

}

#footer p {

margin:0;
  }
  * html #footer {
  height:1px;
  }
 </style>
  </head>
 <body>
 <div id="wrap">
  <div id="header">
  <h1>($pagetitle)</h1>
    <script>
    $("h1").contents().stretch();
    </script> </div>
    <!--End of Header-->';
    $middlecontent1 = '<table border="0">
    <tr>
    <td>Picture will be here</td>
    <td>($address1)</td>
    <td>Google Map will be here</td>
    </tr>
    ';
    $middlecontent2 = '<table border="0">
    <tr>
    <td>Picture will be here</td>
    <td>($address2)</td>
    <td>Google Map will be here</td>
    </tr>
    ';
   $middlecontent3 = '<table border="0">
<tr>
<td>Picture will be here</td>
    <td>($address3)</td>
    <td>Google Map will be here</td>
    </tr>
    ';
    $pagecontent += $topcontent;
    if($id1 != null){
    $pagecontent += $middlecontent1;
    }
    if($id2 != null){
    $pagecontent += $middlecontent2;
    }
    if($id3 != null){
    $pagecontent += $middlecontent3;
    }
    echo $pagecontent;
    echo "<br>";
    // Let's make sure the file exists and is writable first.
    if ($pagecontent != null) {
        // create new page
        file_put_contents($_SERVER['DOCUMENT_ROOT']."/pages/".$filename,$pagecontent);
    echo "($pagecontent)";
    } else {
        echo "The file $filename is not writable";
    }

 exit; 

?>

It's just when it comes to creating the file and page contents it's getting lost.

Did you set the pages folder to be writable?

Did you set the pages folder to be writable?

Yes.

chmod the pages folder to 777 and try it again.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.