getting a link in a sql requst ?

xconspirisist

hey..

I want a page, to take information from a sql databsae, done that. It displays the info with a while statement... Im sure you know what im talking about ?, then it prints the records onto the page, and makes a link from the records. when one of them is clicked, it displays the content of the record, as aooposed to the title, that is shown in the following code :

<?php

$db = mysql_connect("localhost", "----", "----");

mysql_select_db("andromeda_articles",$db);

$result = mysql_query("SELECT id, title FROM articles",$db);

while ($row = mysql_fetch_array($result))
{
?>
<a href="par_viewtutorial.php?<?php echo $myrow"?>>tutorials</a>
 
<?php
}

what I need is to confirm that code is sorrect, and I'd like some sample code for the par_vewtutorial.php ?

hope thats no too much to ask 🙂 - thanks for any help in advance.

non_zero

replace $myrow, with $row[id] or $row[title].

also, a nifty shortcut in writing php within html it <?=$var?> instead of <?php echo $var;?>.

laserlight

I suspect that you are looking for something like:

<?php 
$db = mysql_connect("localhost", "----", "----");
mysql_select_db("andromeda_articles",$db)
	OR die("Error: could not select database!");

$result = mysql_query("SELECT id, title FROM articles", $db);
while ($row = mysql_fetch_array($result)) 
{
	echo '<b><a href="par_viewtutorial.php?id='
		. $row['id'] . '">' . $row['title'] . '</a></b><br>';
}
?>

As for the corresponding par_viewtutorial.php page, sample code would be:

<?php
if (isset($_GET['id']) && is_numeric($_GET['id'])) {
	$id = $_GET['id'];
	$db = mysql_connect("localhost", "----", "----");
	mysql_select_db("andromeda_articles",$db)
		OR die("Error: could not select database!");

$result = mysql_query("SELECT content FROM articles WHERE id='$id'");
if (mysql_num_rows($result) == 1) {
	$row = mysql_fetch_assoc($result);
	echo $row['content'];
}
else {
	die("No article with id '$id' found");
}
}
else {
	die("Error: article id is invalid!");
}
?>

xconspirisist

excelent, thank you very much, worked first time 🙂

could I trouble you from some code, that would get the content from the datbase, load it into a text area, then you could click a submit button on the form to update the database with the new data ?

laserlight

I'll advise you to write it yourself.

You can work with my sample code, just say change
echo $row['content']
to
echo htmlspecialchars($row['content']);
and write a textarea around it.

include form tags and the button, then provide functionality that attempts to use an UPDATE if the submit button has been pressed.

nabimomo

I was trying out the php code mentioned here by laserlight. I put the 1st part in my common.php file:

<?php

$db = mysql_connect("localhost", "", "_");
mysql_select_db("dbfile",$db)
OR die("Error: could not select database!");

$result = mysql_query("SELECT IDNum, page, url, description FROM dbtable", $db);
while ($row = mysql_fetch_array($result))

{
echo '<a href="home.php?page='
. $row['page'] . '">' . $row['description'] . '</a> ';
}
?>

home.php is:

<!===== Header =====>
<?php include('header.php'); ?>

<!====== Body ======>
<?php include(' . $row['url'] . '); ?>

<!===== Footer =====>
<?php include('footer.php'); ?>

I keep receiving the parse error message for the line below the Body section. What am I missing or doing wrong? Any help would be much appreciated.