HTML page linking from mysql

cyronuts

Still going at it trying to get this code to work...I am trying to pull an html code/page from the dbase based on a link selected, where have I gone offroad?

<html>

require_once("sc_fns.php");

// links to the different info to display

echo"<a href=\"?page=splash\">splash</a> 
<a href=\"?page=page_one\">Page One</a> 
<a href=\"?page=page_two\">Page Two</a>";

      // list of possible pages comes from database
      $cat_array=get_html_pages();

// you need to query the database for where $HTTP_GET_VARS['page'] = the row

db_connct();

mysql_select_db("book_sc");
$query = ("SELECT * FROM html_pages WHERE html_page_name = $HTTP_GET_VARS['page']");
$result = mysql_query($query);
$num_results = mysql_num_rows($result);

echo " Number of html pages found:".$num_results."";

for ($i=0; $i <$num_results; $i++)
{
$row = mysql_fetch_array($result);
echo " HTML Code: ";
echo ( stripslashes($row["html_page_code"]));
echo " ";

}

if(!empty($GET)) { extract($GET); }
else { extract($HTTP_GET_VARS); }

if ($HTTP_GET_VARS['page']=="html_page_name")
{
echo ( stripslashes($row["html_page_code"]));
}

</body>

Mega

im going to assume db_connct() is correct 🙂

<? 
require_once("sc_fns.php"); 


echo '<html>\n<body bgcolor="#FFFFFF" text="#000000">';

// links to the different info to display 

echo <<<EOF
<p><a href="?page=splash">splash</a><BR> 
<a href="?page=page_one">Page One</a><BR> 
<a href="?page=page_two">Page Two</a></p>
EOF;

// list of possible pages comes from database 
$cat_array=get_html_pages(); 

// you need to query the database for where $HTTP_GET_VARS['page'] = the row 
db_connct(); 
mysql_select_db("book_sc");


$query = "SELECT * FROM html_pages WHERE html_page_name = {$HTTP_GET_VARS['page']}"; 
$result = mysql_query($query); 
$num_results = mysql_num_rows($result);

echo '<BR>Number of html pages found:'.$num_results; 


while( $row = mysql_fetch_array($result) ){
	echo '<BR><BR>HTML Code:'
 . stripslashes($row["html_page_code"])
 . '<BR><BR>';

} 

if( !empty($_GET) ){
	extract($_GET);
} 

else{
	extract($HTTP_GET_VARS);
} 

if( $HTTP_GET_VARS['page'] == "html_page_name"){
	echo stripslashes($row["html_page_code"]); 
}

echo '</body>';
?>

cyronuts

Still not there quite yet, error message is:

Warning: Supplied argument is not a valid MySQL result resource in c:\apache\htdocs\phphsk\html_test_two.php on line 25

Number of html pages found:
Warning: Supplied argument is not a valid MySQL result resource in c:\apache\htdocs\phphsk\html_test_two.php on line 30

It's like the db is not returning anything? I do have all the db names right though.

Yep, db_connct() works, I use it for other scripts it is just:

function db_connct()
{
@ $db = mysql_pconnect("localhost", "root", "root");

if (!$db)
{
echo "Error: Could not connect to database. Please try again later.";
exit;
}

}

mrmufin

Try adding some result ID testing after the mysql_query() function:

$result = mysql_query($query);
if(!$result) {
	echo "Query $query failed " . mysql_error();
} else {
	// rest of result set processing code goes in here...
}

Have fun...

cyronuts

GOT IT! THANKS TO EVERYONE:

<?
require_once("sc_fns.php");

echo '<html>\n<body bgcolor="#FFFFFF" text="#000000">';

// links to the different info to display

echo <<<EOF
<a href="?page=splash">splash</a> 
<a href="?page=page_one">Page One</a> 
<a href="?page=page_two">Page Two</a>
EOF;

// you need to query the database for where $HTTP_GET_VARS['page'] = the row

db_connct();

mysql_select_db("book_sc");
$query = ("SELECT * FROM html_pages WHERE html_page_name = '$page'");
$result = mysql_query($query);
$num_results = mysql_num_rows($result);

//echo " Number of html pages found:".$num_results." ";

for ($i=0; $i <$num_results; $i++)
{
$row = mysql_fetch_array($result);
echo " HTML Page name: ";
echo htmlspecialchars( stripslashes($row["html_page_name"]));
echo " HTML Code: ";
echo ( stripslashes($row["html_page_code"]));
echo " ";

}

if( !empty($GET) ){
extract($GET);
}

else{
extract($HTTP_GET_VARS);
}

if( $HTTP_GET_VARS['page'] == "html_page_name"){
echo stripslashes($row["html_page_code"]);
}

echo '</body>';