Totally Stupid Question!!

Bigjayce

I am very new to PHP and not exactly a programmer but I get by.

I have downloaded a template and I'm making a site for a friend of mine, I have created an admin area which writes the text into a db, I want to read that text into a page and as much as I try it won't do it!!

I have copied the same code out onto a blank html page and it works but won't work within the template so as far as I can see it must be something with the template that I am not seeing!

The string I am using is

	<?php

$result = mysql_query("SELECT * FROM edittext WHERE txtname = 'clienttxt'");
while($newrow = mysql_fetch_array($result))
{
echo $newrow[1];
}
?>

The 2 tests are at:

www.jaycom.co.uk/test.php
www.jaycom.co.uk/test2.html

Can someone tell me the obvious please as its driving me mad and its far too hot for it today lol

Jayce

CoderDan

well, it shouldn't work on a .html page, unless your apache/whatever is set up to parse html files as php scripts.
It also shouldn't work by itself on a blank page, as it requires a db connection.

Just checked your links real quick and, yes, it's your html extension. it's causing the php to be sent as html, not parsed. If you view source you can see it. you will either nee to tell your server to parse html as php, or rename the file to .php

djjjozsi

advise: delete these two examples , and change the server's mysql accounts password! :eek:

anyway, welcome in this forum 🙂

CoderDan

oh, yeah amd what he said 😛 :

djjjozsi;10916450 wrote:
advise: delete these two examples , and change the server's mysql accounts password! :eek:

anyway, welcome in this forum 🙂

Bigjayce

ok I changed the extension to .php and now nothing at all comes up !!!! totally blank screen

CoderDan

heh as you may have realized from my initial post, I really had just scanned the source real quickly, I saw there was php there, realized that was your problem (or at least the first problem) and closed it down, and I've got no recollection of what the code actually was, aside for that I thought the page started as html, and php didn't start till halfway through, so it should spit out at least something. Going to need the source code, and redact the private info 😛 (I hope you've changed it already)

Bigjayce

😃

What do you need to know and is there a PM on this board ?

CoderDan

the file that is not displaying. put it in a text editor, redact (x-out/delete/replace) any sensitive information (ie db host, un and pw), then whack it in a post here with some PHP tags around it.
Yes there is private messaging, but some of us never read it, and if you use a private message then only the person you send it to will be able to help you, and they may be wrong, or busy, or not explain well... and if your problem is solved and others have a similar problem, then looking at these forums might not help them find the answer if it's not in here 😛

Bigjayce

<php>


<?php require('../db.php');

?>

<!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=utf-8" />
<title>Simply PA</title>
<meta name="keywords" content="virtual secretary pa, office services, secretarial functions, office support, pa service" />
<meta name="description" content="" />
<link href="default_new.css" rel="stylesheet" type="text/css" />
<style type="text/css">

</style>
</head>
<body>
<div id="header">

<div id="menu">
	<ul>
		<li><a href="index.html" title="">Homepage</a></li>
		<li><a href="about.html" title="">About Me</a></li>
		<li><a href="services.html" title="">Services</a></li>
		<li class="active"><a href="clients.html" title="">Clients</a></li>
        <li><a href="terms.html" title="">Terms</a></li>
		<li><a href="contact.html" title="">Contact</a></li>
	</ul>
</div>
</div>
<div id="content">
	<div id="sidebar">
		<div id="login" class="boxed">
			<h2 class="title">Client Account</h2>
			<div class="content">
				<form id="form1" method="post" action="../mel/mydownloads/index.php">
					<fieldset>
					<legend>Sign-In</legend>
					<label for="inputtext1">Client ID:</label>
					<input id="inputtext1" type="text" name="inputtext1" value="" />
					<label for="inputtext2">Password:</label>
					<input id="inputtext2" type="password" name="inputtext2" value="" />
					<input id="inputsubmit1" type="submit" name="inputsubmit1" value="Sign In" />
					<p><a href="#">Forgot your password?</a></p>
					</fieldset>
				</form>
			</div>
		</div>
		<div id="updates" class="boxed">
			<h2 class="title">Benefits</h2>
			<div class="content">
			<ul>
					<li>A PA who is willing to work hours to suit you.</li>
					<br /><br />
					<li>Ad hoc and retainer packages available.</li>
					<br /><br />
					<li>No NIC, Tax, Holiday or Sickness for you to pay.</li>
					<br /><br />
					<li>No office space or equipment for you to find.</li>
			</ul>
			</div>
		</div>
	</div>
	<div id="main">
		<div id="welcome" class="post">
			<p><img src="images/img06.jpg" alt="" width="472" height="122" /></p>
			<h2 class="title">My Clients..</h2>
			<p>

	<?php

		$result = mysql_query("SELECT * FROM edittext WHERE txtname = 'clienttxt'");
		while($newrow = mysql_fetch_array($result))
{
			echo $newrow[1];
}
		?>
	echo
		</div>
		</div>
		<div id="example" class="post"><div class="story"></div>
		</div>
	</div>
</div>
<div id="footer">
	<p id="legal">Copyright &copy; 2008 Simply PA. All Rights Reserved. </p>
	<center><a href="terms.html">Terms and Conditions</a></center>
</div>
</body>
</html>

</php>

Like this ?

CoderDan

ok, use square brackets ([) on the php tags for the code on this site, or use the php code button on the message editor (the button isn't on quick reply, but typing the tags there still works, you can 'go advanced' to get teh button)

I'm guessing it has a provlem with your include of the db script - it's the best way to do it, using require('../db.php'); - but either the path is wrong, or the file has an error. I'm assuming it contains a 'die' in it, which is being activated. that's my best guess.