PHP - Unnecessary Coding In Mysql Page Editing?

Hello

Im quite confused at what filtering I should use on my data when pulling it from a MySQL database.  I don't sanitize my data on input because I am using prepared statements with PHP's PDO Driver which means I don't need to use mysql_real_escape_string() at all.

When I pull the data to be displayed i.e. in a HTML Table I use the below function to make it safe for HTML output.


public static function htmlSafe($data)
{ return nl2br(htmlentities($data, ENT_QUOTES)); }


However the rules change when Im using a HTML Form to edit the data, and I am unsure what I need to strip out. I.e. What would I need to do to make all data safe to insert into the following form input.


<input id = "someInput" type = "text" value = "<?php echo $someVarThatNeedsFiltering ?>" />


Also, one more question, in my html attributes (Valid ones like class, name, id, style, _target) I use a mixture of double quotes(") and single quotes ('), for quoting my values. Which one should I use or which one is more valid, doubles, or singles?

Hey Guys,

Here is my issue. I have a MySQL database with a table of products. I use this table to generate a mutliselect form element that is used int a larger form. The larger form contains other information relevant to an issue that we are having with that product (such as an outage). Anyway, the form works fine and the form validation works fine and I write it to the database fine. The issue I'm having is how to save the mutliselect options most efficiently.

This is my current process:

1. User creates a new entry from the form and clicks save
2. The form is validated
3. All entries are written to the database in a table called "incidents" (content inclues, timestamps, description of the problem, the impact, who to contact, etc)
4. Because the products list can vary from 1 product to all (~30) products I broke it out into a separate table called "impacted_products". I then loop through each of the selected products and write one row for each product using the id from the row in the "incidents" table to define the tables relationship.

Example of DB results:

"incidents"

+-----------------+------+----------+---------------------+---------+---------+
| notification_id | what | impact   | time_start          | summary | contact |
+-----------------+------+----------+---------------------+---------+---------+
| 235235          | Test | None.... | 2011-02-08 13:41:00 | Test    |       3 |
+-----------------+------+----------+---------------------+---------+---------+

"impacted_products"

+-----+-----------------+------------+---------------------+---------+
| id  | notification_id | product_id | timestamp           | deleted |
+-----+-----------------+------------+---------------------+---------+
| 202 | 235235          |          7 | 2011-02-10 14:30:42 |       0 |
| 203 | 235235          |         37 | 2011-02-10 14:30:42 |       0 |
| 204 | 235235          |         23 | 2011-02-10 14:30:42 |       0 |
+-----+-----------------+------------+---------------------+---------+

5. Now the users wants to go back and make some updates.
6. They click the edit button from the menu on screen and the form is brought back up and all options/fields are filled out from that which is stored in the database.
7. They make their edits and save again.
8. Now this time it simple updates the "incidents" table but for the products table I do a:

"UPDATE impacted_products SET deleted=1 WHERE notification_id='$ID'"

and "delete" all the old impacted_products for this particular incident and then loop through all the products that the user still had selected and write them to the database again.
9. And repeat

So as you can see this could end up with a lot of "useless" entries in the database since my scripts only pay attention to those "impacted_products" whose deleted value is set to 0.

Example:

+-----+-----------------+------------+---------------------+---------+
| id  | notification_id | product_id | timestamp           | deleted |
+-----+-----------------+------------+---------------------+---------+
| 176 | 235235          |         37 | 2011-02-08 15:26:25 |       1 |
| 177 | 235235          |         43 | 2011-02-08 15:26:25 |       1 |
| 178 | 235235          |         37 | 2011-02-08 15:37:58 |       1 |
| 179 | 235235          |         43 | 2011-02-08 15:37:58 |       1 |
| 180 | 235235          |          1 | 2011-02-08 15:39:49 |       1 |
| 181 | 235235          |          7 | 2011-02-08 15:39:49 |       1 |
| 182 | 235235          |         37 | 2011-02-08 15:39:49 |       1 |
| 183 | 235235          |         43 | 2011-02-08 15:39:49 |       1 |
| 184 | 235235          |          1 | 2011-02-08 15:40:53 |       1 |
| 185 | 235235          |          7 | 2011-02-08 15:40:53 |       1 |
| 186 | 235235          |         37 | 2011-02-08 15:40:53 |       1 |
| 187 | 235235          |         43 | 2011-02-08 15:40:53 |       1 |
| 188 | 235235          |         37 | 2011-02-10 10:00:47 |       1 |
| 189 | 235235          |          1 | 2011-02-10 12:17:05 |       1 |
| 190 | 235235          |          7 | 2011-02-10 12:17:05 |       1 |
| 191 | 235235          |         13 | 2011-02-10 12:17:05 |       1 |
| 192 | 235235          |         37 | 2011-02-10 12:17:05 |       1 |
| 193 | 235235          |         23 | 2011-02-10 12:17:05 |       1 |
| 194 | 235235          |          1 | 2011-02-10 12:21:52 |       1 |
| 195 | 235235          |          7 | 2011-02-10 12:21:52 |       1 |
| 196 | 235235          |         13 | 2011-02-10 12:21:52 |       1 |
| 197 | 235235          |         37 | 2011-02-10 12:21:52 |       1 |
| 198 | 235235          |         23 | 2011-02-10 12:21:52 |       1 |
| 199 | 235235          |          7 | 2011-02-10 12:22:26 |       1 |
| 200 | 235235          |         37 | 2011-02-10 12:22:26 |       1 |
| 201 | 235235          |         23 | 2011-02-10 12:22:26 |       1 |
| 202 | 235235          |          7 | 2011-02-10 14:30:42 |       0 |
| 203 | 235235          |         37 | 2011-02-10 14:30:42 |       0 |
| 204 | 235235          |         23 | 2011-02-10 14:30:42 |       0 |
+-----+-----------------+------------+---------------------+---------+

I did it this way beacuase it seems the easiest and fastest way. Otherwise I would have to lookup all the impacted_products from the table that match that notification_id and check

1) Was there a new product selected? If so, add it.
2) Was a product that was selected no longer selected? If so, delete it.
3) Was a product that was selected before still selected now? If so, leave it alone.

This seemed like a lot of extra looping and a lot of extra DB queries to essentially end up at the same place.

However, I feel that there has still got to be a more efficient way of doing this where I won't have all the extra entries in the impacted_products table. 

Any ideas?

Thanks in advance!

So I have a page that displays a table from my database and now I have to create a link that edits the information and saves it back to the database from a page. I have 2 pages: student_man.php which displays the table info and provides the edit link, and then editstudent.php which displays the form etc where you edit the info and submit it. I think my first page is fine, or rather doesn't display any errors. I'm struggling with my second page however, receiving errors and my data that is already in the fields aren't displaying rather the fields are just empty. First time I attempt this just want to know if I am on the right path and what I might doing wrong.

Here is my code

First page:<?php Code: [Select]
<html>

<head>

<head>

<title>Courses</title>
<style type="text/css">


#apDiv2 {
position:absolute;
left:0px;
top:0px;
width:1024px;
height:180px;
z-index:2;
}


</style>
</head>

<body bgcolor="white">
<?php

?>
<div id="apDiv1">
<div id="apDiv2"><img src="Images/Banner.gif"
width="1024" height="180" /></div>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<center><p><a href="student_reg.php"> Register a student</a> -- 
<a href="course_man.php">  Manage courses </a> -- <a href="student_man.php"> 
 Manage student  </a> --<a href="list.php">   view registrations </a> </p></center>
</div>
<br>
<br>
<p><a href="selectdelstudent.php"> Delete </a>
<a href="student_reg.php"> Add </a> 
</p>



<!-- Table for course -->
<div id="apdiv3">
<table border=1px noshade="no">
<tr>

<td><b> Course Name</b></td>
<td><b> Surname</b></td>
<td><b> Initials</b></td>
<td><b> Full First Name</b></td>
<td><b> Title</b></td>
<td><b> Maiden or previous surname</b></td>
<td><b> Date of birth</b></td>
<td><b> Gender</b></td>
<td><b> Language of correspondence</b></td>
<td><b> Identity number</b></td>
<td><b> Cell Phone Number</b></td>
<td><b> Fax Code + Number</b></td>
<td><b> E-mail Address</b></td>
<td><b> Postal address of student</b></td>

</tr>
</table>
</div>

<!-- Start of php code for retrieving student information -->

<?php


include 'includes/config.php';



//connect to database
$link=mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);



//error check
if (!$link)
{
die('could not connect: ' . mysql_error());
}

$db_selected=mysql_select_db(DB_NAME, $link);



// error check
if (!$db_selected)
{
die('can\t use ' . DB_NAME . ': ' . mysql_error());
}

//query database
$query=mysql_query("SELECT * FROM student ");


//fetch results and convert to table

while ($rows = mysql_fetch_array($query)):
echo "<a href=\"editstudent.php?id=" . $rows['sno'] ."\" > edit </a>";
$cname=$rows['cname'];
$sname=$rows['sname'];
$init=$rows['init'];
$fname=$rows['fname'];
$title=$rows['title'];
$msname=$rows['msname'];
$dob=$rows['dob'];
$sex=$rows['sex'];
$lang=$rows['lang'];
$idno=$rows['idno'];
$telh=$rows['telh'];
$telw=$rows['telw'];
$cell=$rows['cel'];
$fax=$rows['fax'];
$email=$rows['email'];
$address=$rows['address'];

echo 
" 
<table border=1px> 
<tr>
<td>$cname</td>
<td>$sname</td>
<td>$init</td>
<td>$fname</td>
<td>$title</td>
<td>$msname</td>
<td>$dob</td>
<td>$sex</td>
<td>$idno</td>
<td>$telh</td>
<td>$telw</td>
<td>$cell</td>
<td>$fax</td>
<td>$email</td>
<td>$address</td>
</tr>
</table>" ;

endwhile;
?>


</body>
</html>

?>

Here is my second page where you edit the info:
<?php Code: [Select]
<?php

include 'includes/config.php';

//connect to database
$link=mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

//error check
if (!$link)
{
die('could not connect: ' . mysql_error());
}

$db_selected=mysql_select_db(DB_NAME, $link);



// error check
if (!$db_selected)
{
die('can\t use ' . DB_NAME . ': ' . mysql_error());
}
// connected to database

if (!isset($_POST['submit'])) 
{
$q = "SELECT * FROM student WHERE ID = $_GET[sno]";
$result = mysql_query($q);
$person = mysql_fetch_array($result);
}

?>

<h1> You are editing a student </h1>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">




<p>Course name:</p>
<INPUT TYPE = "text"  name="input1"value="<?php echo $person['cname']; ?>" />
<br>

<p>Surname:</p>
<INPUT TYPE = "text"  name="input2"value="<?php echo $person['sname']; ?>" />
<br>
<p>Initials:</p>
<INPUT TYPE = "text"  name="input3"value="<?php echo $person['init']; ?>" />
<br>
<p>Full First Name:</p>
<INPUT TYPE = "text"  name="input4"value="<?php echo $person['fname']; ?>" />
<br>
<p>Title:</p>
<INPUT TYPE = "text"  name="input5"value="<?php echo $person['title']; ?>" />
<br>
<p>Maiden or previous surname:</p>
<INPUT TYPE = "text"  name="input6"value="<?php echo $person['msname']; ?>" />
<br>
<p>Date of Birth:</p>
<INPUT TYPE = "text"  name="input7"value="<?php echo $person['dob']; ?>" />
<br>
<p>Gender:</p>
<INPUT TYPE = "text"  name="input8"value="<?php echo $person['sex']; ?>" />
<br>
<p>Language for correspondence:</p>
<INPUT TYPE = "text"  name="input9"value="<?php echo $person['lang']; ?>" />
<br>
<p>Identity Number:</p>
<INPUT TYPE = "text"  name="input10"value="<?php echo $person['id']; ?>" />
<br>
<p>Home Telephone Code + Number:</p>
<INPUT TYPE = "text"  name="input11"value="<?php echo $person['telh']; ?>" />
<br>
<p>Work Telephone Code + Number:</p>
<INPUT TYPE = "text"  name="input12"value="<?php echo $person['telw']; ?>" />
<br>
<p>Cell Phone Number:</p>
<INPUT TYPE = "text"  name="input13"value="<?php echo $person['cel']; ?>" />
<br>
<p>Fax Code + Number:</p>
<INPUT TYPE = "text"  name="input14"value="<?php echo $person['fax']; ?>" />
<br>
<p>E-mail Address:</p>
<INPUT TYPE = "text"  name="input15"value="<?php echo $person['email']; ?>" />
<br>
<p>Postal Address of student:</p>
<INPUT TYPE = "text"  name="input16"value="<?php echo $person['address']; ?>" />
<br>
<INPUT TYPE = "Submit" name="submit" VALUE = "Submit"/>


<input type="hidden" name="sno" value="<?php echo $_GET['sno']; ?>" />
</form>

<?php

if(isset($_POST['submit']))

{

$u = "UPDATE student SET 
`cname` = '$_POST[input1]' 
`sname` = '$_POST[input2]' 
`init` = '$_POST[input3]' 
`fname` = '$_POST[input4]' 
`title` = '$_POST[input5]' 
`msname` = '$_POST[input6]' 
`dob` = '$_POST[input7]' 
`sex` = '$_POST[input8]' 
`lang` = '$_POST[input9]' 
`idno` ='$_POST[input10]' 
`telh` = '$_POST[input11]' 
`telw` = '$_POST[input12]' 
`cel` = '$_POST[input13]' 
`fax` = '$_POST[input14]' 
`email` = '$_POST[input15]' 
`address` = '$_POST[input16]' 

WHERE ID = $_POST(sno)";
mysql_query($u) or die(mysql_error());

echo "User has been modified!";
header("Location: index.php");

}
?>


?>

On my second page I am receiving the following errors after typing random letters as info into the fields and submitting it:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`sname` = 'sds' `init` = 'gfg' `fname` = 'rtr' `title` = '' `msname`' at line 3 

I need help trying to figure out why my form won't write the database it is supposed to - i checked the connection to the database and it works and the user seems to have permission to edit database - the error I get is "Error: User not added to database." from "register.php". Can someone please look over my code and see if the problem is coming from somewhere within?   I created a connection file (connect.php)

<?
session_start();
// Replace the variable values below
// with your specific database information.
$host = "localhost";
$user = "master";
$pass = "hidden";
$db   = "user";
// This part sets up the connection to the 
// database (so you don't need to reopen the connection
// again on the same page).
$ms = mysql_pconnect($host, $user, $pass);
if ( !$ms )
{
echo "Error connecting to database.\n";
}
// Then you need to make sure the database you want
// is selected.
mysql_select_db($db);
?>

Then there is the php script (register.php):

<?php
session_start();
// connect.php is a file that contains your
// database connection information. This
// tutorial assumes a connection is made from
// this existing file.
	require('connect.php');
    // If the values are posted, insert them into the database.
    if (isset($_POST['email']) && isset($_POST['password'])){
        $firstname = $_POST['firstname'];
        $lastname = $_POST['lastname'];
		$email = $_POST['email'];
        $password = $_POST['password'];
 
        $query = "INSERT INTO `member` (firstname, lastname, email, password) VALUES ('$firstname', '$lastname', '$email' '$password')";
        $result = mysql_query($query);
        if ( !mysql_insert_id() )
  {
  die("Error: User not added to database.");
  }
 else
  {
  // Redirect to thank you page.
  Header("Location: surveylanding_no-sidebar.html");
  }
    }
    ?>

Here is the HTML form:

<form name="htmlform" method="post" class="form" action="register.php"> 
   
    <p class="firstname"> 
        <input type="text" name="firstname" id="firstname" /> 
        <label for="firstname">First Name</label> 
    </p> 
     
    <p class="lastname"> 
        <input type="text" name="lastname" id="lastname" /> 
        <label for="lastname">Last Name</label> 
    </p> 
     
    <p class="email"> 
        <input type="email" name="email" id="email" /> 
        <label for="email">Email</label>
    </p> 
     <p class="Password"> 
        <input type="password" name="password" id="password" /> 
        <label for="password">Password</label> 
    </p> 
       
    <p class="submit"> 
        <input type="submit" value="Register"/> 
    </p> 
   
</form>

 I need to create a web page that stores airline surveys in a MYSQL database. Include fields for the data and time of the flight and other fields. Also include group of radio buttons that allow the user to rate the airline. It should include a view past survey result button on the main survey page that displays a list of past results. I have made two php pasges and a Survey html main page but they don't work. Can anyone please help me?? I need to know what's wrong with my coding!!! THANKS

So i have this CMS that is used by lots of users and generally they do have rights to edit each others article. So now i'm thinking how can i at least warn them that somebody else is already editing it. Just that.

maybe with sessions? but what happens when a user just closes the windows, will it destroy it. i taught about storing the value to mySQL but again what if the user closes the windows and so on.

i never did this and i could use a boost. thanks guys

Morning all,
and Evening everyone else.

Im using the following Query to display information from a table

Code: [Select]
<?
include "config.php";
$query1="Select *,DATE_FORMAT(date_posted,'%W,%d %b %Y') as thedate FROM article WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) ORDER BY date_posted DESC LIMIT 1 ";
$blogarticles = mysql_query($query1) or die(mysql_error());
$num = mysql_num_rows($blogarticles);
?>
What I am wanting to find out, is as the blog post itself could be pages long at times, is the anyway that further down the page where I actually call the data up onto the page itself I can limit how much of it is displayed?
Ive succesfully added a limit to how many records are shown with the "DES LIMIT 1", is there something I can add to my query, or further down in my displaying table (which I will code just below here) to limit the lines/characters on display until the full article is opened?

Display table:
Code: [Select]
     <table width="75%" border="0" cellspacing="1" align="left">
  <tr>
          <td>&nbsp;</td>
        </tr>
  <tr>
          <td>&nbsp;</td>
        </tr>
  <?
if($num > 0){
while($row_articles = mysql_fetch_assoc($blogarticles)){
?>
       
           <tr class="title">
          <td><?=$row_articles['title'];?> </td>
        </tr>
        <tr>
          <td>&nbsp;</td>
        </tr>
        <tr class="tbody">
          <td><?=$row_articles['comments'];?></td>
        </tr>
        <tr>
          <td>&nbsp;</td>
        </tr>

        <tr class="links">
          <td>Date posted: <?=$row_articles['date_posted'];?> | <a href="comments.php?aid=<?=$row_articles['artid'];?>&cid=<?=$row_articles['categoryID'];?>">Comments(<? //echo $row_articles['artid'];  

//$thenum=row_articles['artid'];
$getcomments = "SELECT * FROM article WHERE artchild='".$row_articles['artid']."'";
if(!$theResult=mysql_query($getcomments)){
echo mysql_error();
}else{
$num_comments=mysql_num_rows($theResult);
echo $num_comments;
}
?>) </a></td>
        </tr>
        <tr class="links">
          <td>&nbsp;</td>
        </tr>
        <tr class="links">
          <td>&nbsp;</td>
        </tr>
<?
}
}else{
?>
<tr><td><p>There are no articles available at present</p></td></tr>
<?
}
?>
<tr> </tr>
      </table>


Just to clarify 'comments' is the table field that holds the blog data, it also holds comments on the blog, but the child ID is what differentiates them from one another.



Thanks in advance for your help ladies & gents


Tom

Hi.

I have a database named 'Forums' with a table named 'forumlist'. The fields in the table are 'id', 'name', 'link', and 'keys'.

I am trying to search the database in either the 'name' or 'keys' field and display the matches.

I am getting this error:

Parse error: syntax error, unexpected T_STRING, expecting ']' in C:\xampp\htdocs\search3.php on line 51 (The define fields)



<html>
<head>
  <title>My Forum Search</title>
  <style type="text/css">
 
  table {
     background-color: #CCC
  }
 
  th {
     width: 150px;
     text-align: left;
  }
 
  </style>
</head>
<body>
<h1>Forum Search</h1>

<form method="post" action="search3.php">
<input type="hidden" name="submitted" value="true" />

<label>Search Category:

<select name="category">
   <option value="keys">Keyword</option>
    <option value="name">Name</option>
   
</select>
</label>
   





<label><input type="text" name="criteria" /></label>

<input type="submit" />


</form>

<?php

if (isset($_POST['submitted])) {




DEFINE ('DB_USER', 'root');
DEFINE ('DB_PSWD', '******');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'Forums');

$dbcon = mysqli_connect(DB_HOST, DB_USER, DB_PSWD, DB_NAME);



$category = $_POST['category'];
$criteria = $_POST['criteria'];
$query = "SELECT * FROM forumlist WHERE $category LIKE '$criteria'";
$result = mysqli_query($dbcon, $query) or die ('Error retrieving data')

echo "<table>";
echo "<tr> <th>Name</th><th>Link</th> </tr>";

while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {

   echo "<tr><td>";
    echo $row['name'];
    echo "</td><td>";
    echo $row['link'];
    echo "</td></tr>";
   

}

echo "</table>";

} // end of main if state






?>




</body>
</html>



Thanks in advance

hello everyone.
i'm having problem to create a search page.

i want to create a search page like this but i dont have the coding source to refer..
can anyone give me the coding for me to refer....

Help Please

Hello guys,

I am a beginner in PHP, so please be gentle.

I am building this website for a friend of mine. This website is made up by HTML/CSS. i.e., I have a page made with HTML & CSS.
there are a few menus on the page. say Home, About Us, Contact Us, etc.,

Now I want to separate the page elements (like header/footer) from the page so as its easy to work on.
the source is something like this


Code: [Select]
<HTML>
<HEAD>
<TITLE>
My Page
</TITLE>
<LINK REL="STYLESHEET" HREF="./mystyle.css" TYPE="text/css" />
</HEAD>

<BODY>
<DIV ID="wrapper">
<DIV ID="header">
<DIV ID="logo">
<UL ID="menu">
<LI>
<A HREF="./index.php"><SPAN>Home</SPAN></A>
</LI>
<LI>
<A HREF="./login.php"><SPAN>Login</SPAN></A>
</LI>
<LI>
<A HREF="./contactus.php"><SPAN>Contact Us</SPAN></A>
</LI>
</UL>
<DIV ID="date">
<?php echo Date("d M Y");?>
</DIV>
</DIV>
</DIV>
<DIV ID="bodywrapper">
<DIV ID="main">
<DIV ID="content">
THIS IS A TEST!
</DIV>
</DIV>
</DIV>
                <DIV ID ="clearfooter"></DIV>
</DIV>
<DIV ID="footer">
&copy; <?php echo date("Y");?>
</DIV>
</BODY>
</HTML>


now I will have my content in the DIV called 'content'.

now I have separated this one page into three different pages. like this:

header.php
Code: [Select]

<HTML>
<HEAD>
<TITLE>
My Page
</TITLE>
<LINK REL="STYLESHEET" HREF="./mystyle.css" TYPE="text/css" />
</HEAD>

<BODY>
<DIV ID="wrapper">
<DIV ID="header">
<DIV ID="logo">
<UL ID="menu">
<LI>
<A HREF="./index.php"><SPAN>Home</SPAN></A>
</LI>
<LI>
<A HREF="./login.php"><SPAN>Login</SPAN></A>
</LI>
<LI>
<A HREF="./contactus.php"><SPAN>Contact Us</SPAN></A>
</LI>
</UL>
<DIV ID="date">
<?php echo Date("d M Y");?>
</DIV>
</DIV>
</DIV>

footer.php
Code: [Select]
                <DIV ID ="clearfooter"></DIV>
</DIV>
<DIV ID="footer">
&copy; <?php echo date("Y");?>
</DIV>
</BODY>
</HTML>


and index.php
Code: [Select]
<?php include_once('header.php');?>
<DIV ID="bodywrapper">
<DIV ID="main">
<DIV ID="content">
THIS IS A TEST
</DIV>
</DIV>
</DIV>
<?php include_once('footer.php');?>


Is this the right way to code? I am worried because I have to keep in mind the safety of the website as I have to include a basic login module to this.

is there any other style to write this?
please do let me know..

thanks

I need to disable a query on the products page. The URL is www.myjabberbox.com
If you goto the products page, you'll see when you hover over one of the three products, you can
click it to take you to another page of that product. I want to disable that. I thought the code that
I'd need to modify would be under the products-page.php file but I can't seem to find the code.
Notice also when you hover over the products, a mouseover color of black happens around the image/text
frame, I'd like to keep that, just disable the linking...

Thanks

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=343748.0

Hi,

Is it possible to build a PHP Template page that selects and publishes a row of data from a MySQL Database when a linked is clicked?

I would design: Template.php
Text links (perhaps on homepage of navigation bar): ProductA, ProductB and ProductC

If you click link ProductA Template.php would display data for ProductA and likewise for ProductB and ProductC.

I would also like search engines for find ProductA, ProductB and ProductC PHP pages. (Not just my single Template.php)

Any ideas as to how this could be done without designing individual PHP pages for each product?

Kind regards,

Matthew.

Hey,

I'm having problems displaying data from a mysql database properly.

Problem page: here

It's a bit like a cms, a user fills out a form asking for a page title and the page content, thats then stored in the database and the finished result should be the page title added to the navigation and when clicked displaying the relevant page.

I don't know if its possible but I'd like it to be done all on the one page.

As you can see on the link I provided, when you click more than one link it displays it on the same page, rather than replacing itself. Can you help with this?

Code:
<html>
<head>
<script>

function show_content(id){
    document.getElementById(id).style.display='block';
}


</script>
</head>
<body>
<font face=verdana size=1>
<?php
include 'dbwire.php'; 

$query = mysql_query('SELECT * FROM content');

while($results = mysql_fetch_array($query,MYSQL_ASSOC)){
    $title = $results['title'];
    $id = $results['id'];
    $content = $results['content'];
    echo "| <a href=\"javascript:void(0);\" onclick=\"show_content($id)\">$title</a> ";
    echo "<div id=\"$id\" style=\"display:none\">$content</div>";
}


?>
<hr>

</body>
</html>

Also, any idea how I should do the navigation? As you can see the more pages added the longer the navigation will get...eventually extending beyond the page width and creating problems.

I understand I have problems explaining, if you need more just let me know!

Thanks,
Drew.