0

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; 

?>
3
Contributors
3
Replies
18
Views
4 Years
Discussion Span
Last Post by pixelsoul
0

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?

0

Did you set the pages folder to be writable?

Yes.

Edited by My_Specs_1

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.