Ok this is my first attempt at php and mysql. (php for that matter)
Here is the code
[<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title></title>
<meta name="GENERATOR" content="Quanta Plus" />
<meta name="AUTHOR" content="" />
<meta http-equiv="Content-Type" content="text/html; charset=" />
<meta name="KEYWORDS" content="" />
<link rel="stylesheet" type="text/css" href="css/mtcss.css" title="mtcss" />
<STYLE type="text/css">
@import url(css/mtcss.css);
</STYLE>
</head>
<body>
<h1>Good Grief!</h1>
<form action="<?php echo $_SERVER['PHP_SELF'];?>" method="post">
<h2>Input Link Information</h2>
<table summary="LinkFormLayout" cellspacing="4" cellpadding="4">
<tbody>
<tr>
<td>Link Catagory:</td>
<td><input type="text" name="linkCatagory" size="24" maxlength="24" /></td>
</tr>
<tr>
<td>Link Title:</td>
<td><input type="text" name="linkTitle" size="32" maxlength="64"/></td>
</tr>
<tr>
<td>Link Text:</td>
<td><input type="text" name="linkText" size="32" maxlength="128"/></td>
</tr>
<tr>
<td>Link URL:</td>
<td><input type="text" name="url" size="72" maxlength="256" /></td>
</tr>
<tr>
<td>Link Comment:</td>
</tr>
<tr>
<td colspan="2">
<textarea name="linkComment" cols="72" rows="4" ></textarea>
</td>
</tr>
<tr>
<td colspan="2">
<input type="submit" name="submit" value="Submit!" />
</td>
</tr>
</tbody>
</table>
</form>
<?php
$user="root";
$password="pass";
$database="LinksDatabase";
mysql_pconnect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
if (isset($_POST['submit'])){
$query="CREATE TABLE IF NOT EXSISTS"+ $_POST['linkCatagory']+ "(
id int(6) NOT NULL auto_increment,
linkTitle varchar(64) NOT NULL,
linkText varchar(64) NOT NULL,
url varchar(256) NOT NULL UNIQUE,
linkComment MEDIUMTEXT,
PRIMARY KEY (id),
UNIQUE id (id),
KEY id_2 (id)
)";
}
mysql_query($query);
mysql_close();
?>
<?
if (isset($_POST['submit'])){
$linkCatagory=$_POST['linkCatagory'];
$linkTitle=$_POST['linkTitle'];
$linkText=$_POST['linkText'];
$url=$_POST['url'];
$linkComment=$_POST['linkComment'];
mysql_pconnect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = "INSERT INTO" + $linkCatagory + "VALUES ('','$linkTitle','$linkText','$url','$linkComment')";
mysql_query($query);
mysql_close();
}
?>
//This block causes form not to display what could be wrong?
<?php
mysql_pconnect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$catagoryTables = mysql_list_tables($database);
if ($catagoryTables){
while (list($catagory) = mysql_fetch_row($catagoryTables)){
$query="SELECT * FROM "+ $catagory;
$result=mysql_query($query);
$num=mysql_numrows($result);
echo "<dl><h3>$catagory</h3>";
i$=0;
while ($i < $num) {
$linkTitle=mysql_result($result,$i,"linkTitle");
echo "<dt>$linkTitle</dt>";
$linkText=mysql_result($result,$i,"linkText");
$url=mysql_result($result,$i,"url");
echo "<dd><a href=\"$url\">$linkText</a></dd>";
$linkComment=mysql_result($result,$i,"linkComment");
echo "<dd>$linkComment</dd>";
$i++;
}
echo '</dl>';
}
}
mysql_close();
?>
</body>
</html>
The block of code I commented on causes the page to not load, no form, css background nothing.
Help is appreciated!!
