BrianM

April 25, 2008

I can't seem to find where it's at... here is the the warning output:

Parse error: parse error, expecting `','' or `';'' in C:\Program Files\Apache Group\Apache2\htdocs\mps\projects\project_08-12345-1.php on line 43

and here is line 43:

echo "<td><span id="" class="editText"><center><b>" . $row['PermitProcess'] . "</b></center></span></td>";

April 25, 2008

Better yet, does anyone know of a simple way to edit the contents of a table cell linked to a table in a database that's being displayed in a web page?

webmaster -> send mails to users · April 25, 2008

And then again... why would a 'master' be asking for help? >.> Only joking.

Reckon hes sat there in a big chair with a sign that says..."Webmaster" on his desk?

LOL @ the above statement.

webmaster -> send mails to users · April 25, 2008

Buy a newsletter script.

or code one yourself. Buying is easier... as a webmaster. :-)

Bah! lol

I believe it's fairly easy to write out a simple script which sends an email to all registered users, I believe that's what he's aiming for.

webmaster -> send mails to users · April 25, 2008

You can write your own PHP script to do this, if you know enough PHP.

Would you like an example?

April 25, 2008

Bump.

April 25, 2008

Lies IMO.

April 25, 2008

I got as far as finding an example online that shows how to set the entire table cell as a link and not just the contents that are contained inside. So my question is, using the onClick command(i guess it's some sort of javascript thing, never have looked into javascripting), can anyone show me an example of how to (and after clicking the cell, of course) turn the cell into a text box where you can edit the cell content and click a submit button under or around the table (wherever your preference to place it) and it will update the information in the database table for that column and rows input.

April 23, 2008

Actually one more thing, does the last statement have to be an else or can it also be elseif?

April 23, 2008

Alright, thank you very much! =]

April 23, 2008

Heh, can somebody confirm this, please?

April 23, 2008

Can this be done, multiple elseif statements. Something along these lines...

<?php

if ...

else ...

elseif ...

April 22, 2008

I'll give a bag of coin to whoever knows the answer like 100 pennies i meant! Sorry.

April 22, 2008

Hah! Was reading my old posts and saw this lol. Thanks for pointing that out, mwasif!

April 22, 2008

I also took out an apostrophe changing

$tmp[] = '<font face="Verdana">''

to

$tmp[] = '<font face="Verdana">'

and took out the quote in

$tmp[] = 'echo "<style type=\'text/css\'>';

changing it to

$tmp[] = 'echo <style type=\'text/css\'>';

which drastically changed the color of some entities and functions in Dreamweaver how they should normally be. But still no luck.

April 22, 2008

Still no luck... I just know it's a problem with those quotes and apostrophes. Here is what I have right now:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" type="text/css" href="http://www.game-zero.org/styles/mps.css" />"
<title>MPS - Send Client Data</title>
</head>

<?php

$mysql_hostname = "localhost";
$mysql_username = "brian";
$mysql_password = "*";
$mysql_database = "mps";

$mysql_connect = mysql_connect("$mysql_hostname", "$mysql_username", "$mysql_password") or die(mysql_error());

mysql_select_db("$mysql_database") or die(mysql_error());

$insert_one = "INSERT INTO mps_cdata (projectnumber, projectname, clientname, clientaddress, clientofficephone, clientfax, clientcell, clientemail)
VALUES
('$_POST[projectnumber]','$_POST[projectname]','$_POST[clientname]','$_POST[clientaddress]','$_POST[clientofficephone]','$_POST[clientfax]','$_POST[clientcell]','$_POST[clientemail]')";

if (!mysql_query($insert_one, $mysql_connect))

{

die(mysql_error());

}

mysql_select_db("$mysql_database") or die(mysql_error());

$insert_two = "CREATE TABLE `{$_POST['projectnumber']}`
(
PermitProcess varchar(40),
Req char(3),
SubmittalDate date,
CommentsReceivedDate1 date,
ResubmitDate1 date,
CommentsReceivedDate2 date,
ResubmitDate2 date,
CommentsReceivedDate3 date,
ResubmitDate3 date,
CommentsReceivedDate4 date,
ResubmitDate4 date,
ApprovalDate date,
PermitNumber varchar(10),
CoCReqDate date,
CoCSubmittalDate date
)";
mysql_query($insert_two, $mysql_connect);

mysql_select_db("$mysql_database") or die(mysql_error());

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('COUNTY PRE-APP MEETING')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('FDOT PRE-APP MEETING')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('ERP PRE-APP MEETING')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('COUNTY PRELIMINARY PLAT APPROVAL')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('REZONING APPROVAL (BY OTHERS)')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('COUNTY CONSTRUCTION PLAN APPROVAL')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('FDOT DRIVEWAY CONNECTION PERMIT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('FDOT DRAINAGE CONNECTION PERMIT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('FDOT UTILITY PERMIT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('NOTICE TO R/W USERS')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('FDEP/ECUA SANITARY SEWER PERMIT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('FDEP/ECUA POTABLE WATER PERMIT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('SEPERATE UTILITY APPROVAL')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('FDEP/ERP STORMWATER PERMIT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('FDEP DREDGE & FILL PERMIT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('COE DREDGE & FILL PERMIT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('NPDES PERMIT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('ADEM PERMIT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('FINAL PLAT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('FDEP/ERP CERTIFICATION OF COMPLETION')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('ERP REQUEST FOR CONVERSION TO OP. PERMIT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('NPDES NOTICE OF TERMINATION')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('ADEM NOTICE OF TERMINATION')");

?>

Your entry has been added to the database. Return <a href="http://www.game-zero.org/mps/home.php">home</a> or <a href="http://www.game-zero.org/mps/view_cdata.php">view client data</a>.

<?php

$file = fopen("projects/project_" . $_POST['projectnumber'] .".php", "w");
$tmp = array();
$tmp[] = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">';
$tmp[] = '<html xmlns="http://www.w3.org/1999/xhtml">';
$tmp[] = '<head>';
$tmp[] = '<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />';
$tmp[] = '<link rel="stylesheet" type="text/css" href="http://www.game-zero.org/styles/mps.css" />';
$tmp[] = '<title>MPS - Send Client Data</title>';
$tmp[] = '</head>';
$tmp[] = '<?php';

$tmp[] = '$mysql_hostname = "localhost";';
$tmp[] = '$mysql_username = "brian";';
$tmp[] = '$mysql_password = "*";';
$tmp[] = '$mysql_database = "mps";';

$tmp[] = '$mysql_connect = mysql_connect("$mysql_hostname", "$mysql_username", "$mysql_password") or die(mysql_error());';

$tmp[] = 'mysql_select_db("$mysql_database") or die(mysql_error());';

$tmp[] = 'mysql_select_db("$mysql_database");';

$tmp[] = '$result = mysql_query("SELECT * FROM 1");';

$tmp[] = 'echo "<style type=\'text/css\'>';
$tmp[] = 'table {font-size: 65%;}';
$tmp[] = '</style>';
$tmp[] = '<center>';
$tmp[] = '<font face="Verdana">''
$tmp[] = '<table border="1">';
$tmp[] = '<tr>';
$tmp[] = '<th> Permit Process </th>';
$tmp[] = '<th> Req </th>';
$tmp[] = '<th> Submittal Date </th>';
$tmp[] = '<th> Comments Received Date </th>';
$tmp[] = '<th> Resubmit Date </th>';
$tmp[] = '<th> Comments Received Date </th>';
$tmp[] = '<th> Resubmit Date </th>';
$tmp[] = '<th> Comments Received Date </th>';
$tmp[] = '<th> Resubmit Date </th>';
$tmp[] = '<th> Comments Received Date </th>';
$tmp[] = '<th> Resubmit Date </th>';
$tmp[] = '<th> Approval Date </th>';
$tmp[] = '<th> Permit Number </th>';
$tmp[] = '<th> CoC Req Date </th>';
$tmp[] = '<th> CoC Submittal Date </th>';
$tmp[] = '</tr>";';
$tmp[] = 'while($row = mysql_fetch_array($result))';
$tmp[] = '{';
$tmp[] = 'echo "<tr>";';
$tmp[] = 'echo "<td><center><b>" . $row['PermitProcess'] . "</b></center></td>";';
$tmp[] = 'echo "<td><center><b>" . $row['Req'] . "</b></center></td>";';
$tmp[] = 'echo "<td><center><b>" . $row['SubmittalDate'] . "</b></center></td>";';
$tmp[] = 'echo "<td><center><b>" . $row['CommentsReceivedDate1'] . "</b></center></td>";';
$tmp[] = 'echo "<td><center><b>" . $row['ResubmitDate1'] . "</b></center></td>";';
$tmp[] = 'echo "<td><center><b>" . $row['CommentsReceivedDate2'] . "</b></center></td>";';
$tmp[] = 'echo "<td><center><b>" . $row['ResubmitDate2'] . "</b></center></td>";';
$tmp[] = 'echo "<td><center><b>" . $row['CommentsReceivedDate3'] . "</b></center></td>";';
$tmp[] = 'echo "<td><center><b>" . $row['ResubmitDate3'] . "</b></center></td>";';
$tmp[] = 'echo "<td><center><b>" . $row['CommentsReceivedDate4'] . "</b></center></td>";';
$tmp[] = 'echo "<td><center><b>" . $row['ResubmitDate4'] . "</b></center></td>";';
$tmp[] = 'echo "<td><center><b>" . $row['ApprovalDate'] . "</b></center></td>";';
$tmp[] = 'echo "<td><center><b>" . $row['PermitNumber'] . "</b></center></td>";';
$tmp[] = 'echo "<td><center><b>" . $row['CoCReqDate'] . "</b></center></td>";';
$tmp[] = 'echo "<td><center><b>" . $row['CoCSubmittalDate'] . "</b></center></td>";';
$tmp[] = 'echo "</tr>";';
$tmp[] = '}';
$tmp[] = 'echo "</table>';
$tmp[] = '</font>';
$tmp[] = '</center>";';
$tmp[] = 'mysql_close($mysql_connect);';
$tmp[] = '?>';
$tmp[] = '<body>';
$tmp[] = '</body>;'
$tmp[] = '</html>';
echo fwrite($file, implode("\n",$tmp)."\n");

fclose($file);

mysql_close($mysql_connect)

?>

<body>



</body>
</html>

Maybe I positioned the code incorrectly?

Well... another thing. Now I'm looking at

$tmp[] = '?>';

and everything that's PHP which comes after that doesn't show up colored as it should... :/

April 22, 2008

Wow, I'm about to copy that in... looks technical, but may work. I'll report back.

Oh, and sorry for the impatient bump.

April 22, 2008

Er, no go. But! I did notice this:

$file = fopen("projects/project_" . $_POST['projectnumber'] .".php", "w");
echo fwrite($file, "<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" type="text/css" href="http://www.game-zero.org/styles/mps.css" />
<title>MPS - Send Client Data</title>
</head>

The " (quote) right before the -//W3C... etc is by itself because everything else after it is commented out and shouldn't be... could this be a problem, and maybe it's throwing off the other quotes in the script. I mean I've basically narrowed it down to a problem with quotes and what not, just not sure what to do with this.

April 22, 2008

Arg, everyone else gets help but me. >.>

April 22, 2008

That's to easy.

April 22, 2008

Well for some reason when I use apostrophes around what's to be executed in the fwrite function it displays all the text in red, and if I use quotes, it seems like it's displaying all the functions and html entities - so forth - with colors like it should depending on the type. Note * the colors are because I'm using Dreamweaver. And also when I use quotes, it tries to set what's behind the // in the DTD header as a comment... please, somebody help me! :[ This is really frustrating.

April 22, 2008

Erg. Can somebody please assist me? :[

April 22, 2008

I'm hoping that praying that somebody on here can if not give me the solution, at least point me in the right direction. I've been at this for nearly 3 days now, spending hours each day trying different methods and placing quotes and apostrophes in different locations with no luck. I suppose I'll start by sharing my code:

Entire page I'm having the problem occur on.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" type="text/css" href="http://www.game-zero.org/styles/mps.css" />"
<title>MPS - Send Client Data</title>
</head>

<?php

$mysql_hostname = "localhost";
$mysql_username = "brian";
$mysql_password = "*";
$mysql_database = "mps";

$mysql_connect = mysql_connect("$mysql_hostname", "$mysql_username", "$mysql_password") or die(mysql_error());

mysql_select_db("$mysql_database") or die(mysql_error());

$insert_one = "INSERT INTO mps_cdata (projectnumber, projectname, clientname, clientaddress, clientofficephone, clientfax, clientcell, clientemail)
VALUES
('$_POST[projectnumber]','$_POST[projectname]','$_POST[clientname]','$_POST[clientaddress]','$_POST[clientofficephone]','$_POST[clientfax]','$_POST[clientcell]','$_POST[clientemail]')";

if (!mysql_query($insert_one, $mysql_connect))

{

die(mysql_error());

}

mysql_select_db("$mysql_database") or die(mysql_error());

$insert_two = "CREATE TABLE `{$_POST['projectnumber']}`
(
PermitProcess varchar(40),
Req char(3),
SubmittalDate date,
CommentsReceivedDate1 date,
ResubmitDate1 date,
CommentsReceivedDate2 date,
ResubmitDate2 date,
CommentsReceivedDate3 date,
ResubmitDate3 date,
CommentsReceivedDate4 date,
ResubmitDate4 date,
ApprovalDate date,
PermitNumber varchar(10),
CoCReqDate date,
CoCSubmittalDate date
)";
mysql_query($insert_two, $mysql_connect);

mysql_select_db("$mysql_database") or die(mysql_error());

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('COUNTY PRE-APP MEETING')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('FDOT PRE-APP MEETING')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('ERP PRE-APP MEETING')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('COUNTY PRELIMINARY PLAT APPROVAL')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('REZONING APPROVAL (BY OTHERS)')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('COUNTY CONSTRUCTION PLAN APPROVAL')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('FDOT DRIVEWAY CONNECTION PERMIT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('FDOT DRAINAGE CONNECTION PERMIT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('FDOT UTILITY PERMIT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('NOTICE TO R/W USERS')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('FDEP/ECUA SANITARY SEWER PERMIT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('FDEP/ECUA POTABLE WATER PERMIT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('SEPERATE UTILITY APPROVAL')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('FDEP/ERP STORMWATER PERMIT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('FDEP DREDGE & FILL PERMIT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('COE DREDGE & FILL PERMIT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('NPDES PERMIT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('ADEM PERMIT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('FINAL PLAT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('FDEP/ERP CERTIFICATION OF COMPLETION')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('ERP REQUEST FOR CONVERSION TO OP. PERMIT')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('NPDES NOTICE OF TERMINATION')");

mysql_query("INSERT INTO `{$_POST['projectnumber']}` (PermitProcess)
VALUES ('ADEM NOTICE OF TERMINATION')");

?>

Your entry has been added to the database. Return <a href="http://www.game-zero.org/mps/home.php">home</a> or <a href="http://www.game-zero.org/mps/view_cdata.php">view client data</a>.

<?php

$file = fopen("projects/project_" . $_POST['projectnumber'] .".php", "w");
echo fwrite($file, '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" type="text/css" href="http://www.game-zero.org/styles/mps.css" />
<title>MPS - Send Client Data</title>
</head>

<?php

$mysql_hostname = "localhost";
$mysql_username = "brian";
$mysql_password = "*";
$mysql_database = "mps";

$mysql_connect = mysql_connect("$mysql_hostname", "$mysql_username", "$mysql_password") or die(mysql_error());

mysql_select_db("$mysql_database") or die(mysql_error());

mysql_select_db("$mysql_database");

$result = mysql_query("SELECT * FROM 1");

echo "<style type='text/css'>
table {font-size: 65%;}
</style>
<center>
<font face='Verdana'>
<table border='1'>
<tr>
<th> Permit Process </th>
<th> Req </th>
<th> Submittal Date </th>
<th> Comments Received Date </th>
<th> Resubmit Date </th>
<th> Comments Received Date </th>
<th> Resubmit Date </th>
<th> Comments Received Date </th>
<th> Resubmit Date </th>
<th> Comments Received Date </th>
<th> Resubmit Date </th>
<th> Approval Date </th>
<th> Permit Number </th>
<th> CoC Req Date </th>
<th> CoC Submittal Date </th>
</tr>";

while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td><center><b>" . $row['PermitProcess'] . "</b></center></td>";
echo "<td><center><b>" . $row['Req'] . "</b></center></td>";
echo "<td><center><b>" . $row['SubmittalDate'] . "</b></center></td>";
echo "<td><center><b>" . $row['CommentsReceivedDate1'] . "</b></center></td>";
echo "<td><center><b>" . $row['ResubmitDate1'] . "</b></center></td>";
echo "<td><center><b>" . $row['CommentsReceivedDate2'] . "</b></center></td>";
echo "<td><center><b>" . $row['ResubmitDate2'] . "</b></center></td>";
echo "<td><center><b>" . $row['CommentsReceivedDate3'] . "</b></center></td>";
echo "<td><center><b>" . $row['ResubmitDate3'] . "</b></center></td>";
echo "<td><center><b>" . $row['CommentsReceivedDate4'] . "</b></center></td>";
echo "<td><center><b>" . $row['ResubmitDate4'] . "</b></center></td>";
echo "<td><center><b>" . $row['ApprovalDate'] . "</b></center></td>";
echo "<td><center><b>" . $row['PermitNumber'] . "</b></center></td>";
echo "<td><center><b>" . $row['CoCReqDate'] . "</b></center></td>";
echo "<td><center><b>" . $row['CoCSubmittalDate'] . "</b></center></td>";
echo "</tr>";
}
echo "</table>
</font>
</center>";

mysql_close($mysql_connect);

?>

<body>



</body>
</html>');

fclose($file);

mysql_close($mysql_connect)

?>

<body>



</body>
</html>

And here is the area (to narrow things down) that I'm having issues with.

$file = fopen("projects/project_" . $_POST['projectnumber'] .".php", "w");
echo fwrite($file, '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" type="text/css" href="http://www.game-zero.org/styles/mps.css" />
<title>MPS - Send Client Data</title>
</head>

<?php

$mysql_hostname = "localhost";
$mysql_username = "brian";
$mysql_password = "*";
$mysql_database = "mps";

$mysql_connect = mysql_connect("$mysql_hostname", "$mysql_username", "$mysql_password") or die(mysql_error());

mysql_select_db("$mysql_database") or die(mysql_error());

mysql_select_db("$mysql_database");

$result = mysql_query("SELECT * FROM 1");

echo "<style type='text/css'>
table {font-size: 65%;}
</style>
<center>
<font face='Verdana'>
<table border='1'>
<tr>
<th> Permit Process </th>
<th> Req </th>
<th> Submittal Date </th>
<th> Comments Received Date </th>
<th> Resubmit Date </th>
<th> Comments Received Date </th>
<th> Resubmit Date </th>
<th> Comments Received Date </th>
<th> Resubmit Date </th>
<th> Comments Received Date </th>
<th> Resubmit Date </th>
<th> Approval Date </th>
<th> Permit Number </th>
<th> CoC Req Date </th>
<th> CoC Submittal Date </th>
</tr>";

while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td><center><b>" . $row['PermitProcess'] . "</b></center></td>";
echo "<td><center><b>" . $row['Req'] . "</b></center></td>";
echo "<td><center><b>" . $row['SubmittalDate'] . "</b></center></td>";
echo "<td><center><b>" . $row['CommentsReceivedDate1'] . "</b></center></td>";
echo "<td><center><b>" . $row['ResubmitDate1'] . "</b></center></td>";
echo "<td><center><b>" . $row['CommentsReceivedDate2'] . "</b></center></td>";
echo "<td><center><b>" . $row['ResubmitDate2'] . "</b></center></td>";
echo "<td><center><b>" . $row['CommentsReceivedDate3'] . "</b></center></td>";
echo "<td><center><b>" . $row['ResubmitDate3'] . "</b></center></td>";
echo "<td><center><b>" . $row['CommentsReceivedDate4'] . "</b></center></td>";
echo "<td><center><b>" . $row['ResubmitDate4'] . "</b></center></td>";
echo "<td><center><b>" . $row['ApprovalDate'] . "</b></center></td>";
echo "<td><center><b>" . $row['PermitNumber'] . "</b></center></td>";
echo "<td><center><b>" . $row['CoCReqDate'] . "</b></center></td>";
echo "<td><center><b>" . $row['CoCSubmittalDate'] . "</b></center></td>";
echo "</tr>";
}
echo "</table>
</font>
</center>";

Does anyone see anything at all that may/will lead me to a solution to this horrific problem?

Here is the problem, don't think I've clearly stated it yet. I know the problem is in the area of fwrite because the source code I pasted in this topic wont execute, though if I take all of what is in the fwrite function out and just place in a simple echo statement or something simple, period, it will work just fine. So I believe this may be an issue of figuring out where to place quotes and apostrophes correctly =/

April 19, 2008

I'm doing something like this:

<title>MPS - Project <?php $_POST['projectnumber'] ?></title>

and when I do, i get a blank white page as I always do when there is a syntax issue. Anyone know the proper syntax/formatting to make this work?

April 19, 2008

Ah, haku, thank you very much! It works, but like I said, I have to replace the '' with `` since I am using numbers instead of letters.

And stuffradio, thank you for the suggestion, but this will only be on a LAN at my fathers work office. I'm using HTML, PHP and a MySQL database to create a project tracking system for his engineering company so that there is no need to use a filing cabinet and folders with thousands of unorganized papers any longer. No need to worry about security in this case. ) Thanks for the suggestion though.

Again, thanks you two!!!

Sign In

BrianM

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by BrianM

[SOLVED] Yet another syntax error

Linking & updating a table cell

webmaster -> send mails to users

webmaster -> send mails to users

webmaster -> send mails to users

Linking & updating a table cell

[SOLVED] My site.

Linking & updating a table cell

Multiple elseif statements

Multiple elseif statements

Multiple elseif statements

Multiple elseif statements

Problem with... fwrite I'm assuming at this point (may be wrong)

my.ini

Problem with... fwrite I'm assuming at this point (may be wrong)

Problem with... fwrite I'm assuming at this point (may be wrong)

Problem with... fwrite I'm assuming at this point (may be wrong)

Problem with... fwrite I'm assuming at this point (may be wrong)

Problem with... fwrite I'm assuming at this point (may be wrong)

[SOLVED] Making a button look like a hyper link, is it possible?

Problem with... fwrite I'm assuming at this point (may be wrong)

Problem with... fwrite I'm assuming at this point (may be wrong)

Problem with... fwrite I'm assuming at this point (may be wrong)

<title></title> with POST data

CREATE TABLE with POST value

Browse

Activity

Important Information