PHP Script Help...

**DougD** · Mar 8, 2001, 15:56

Hi Guys...

I am new at this php stuff and can't figure this out. I know it is simple, but it's not for me.

The script below generates a list of domains in my database as well as it's price. I would like the domain name it generates to be an active link to the following address. It needs the domain name in the address... that is why I put the $domain there. Let me know if this make sense...

Thanks,

Doug

www.dotdealers.com/admin.php?dname=$domain&actedit=Edit

Here's the script so far...

<?
mysql_connect("localhost","xxxxxx","xxxxxxx");
mysql_select_db("xxxxxxxxx");

$query = "SELECT * FROM dd_domains";
$result = mysql_query($query);

echo "<html><body bgcolor=\"#FFFFFF\"><table border=\"0\" cellspacing=\"0\" cellpadding=\"4\"><tr><td><b>domain</b></td><td><b>price</b></td></tr>";
while($row = mysql_fetch_array($result))
{
$price = $row['priceb'];
$domain = $row['name'];

echo "<tr><td>$domain</td><td>$price</td></tr>";
}

echo "</table></body></html>";

?>

**atomicmunky** · Mar 8, 2001, 16:12

how about this :

echo "<tr><td>

< a href = "www.dotdealers.com/admin.php?dname=$domain&actedit=Edit">$domain</a>

</td><td>$price</td></tr>";

**freddydoesphp** · Mar 8, 2001, 16:15

Or slightly more efficient but the same result:

PHP Code:


<?

mysql_connect("localhost","xxxxxx","xxxxxxx"); 

mysql_select_db("xxxxxxxxx"); 



$query = "SELECT * FROM dd_domains"; 

$result = mysql_query($query); 

?>

<html>

<body bgcolor="#FFFFFF">

<table border="0" cellspacing="0" cellpadding="4">

<tr><td><b>domain</b></td><td><b>price</b></td></tr> 

<? while($row = mysql_fetch_array($result)) { ?>

<tr><td><a href="www.dotdealers.com/admin.php?dname=<?=$row['name']?>&actedit=Edit"><?=$row['name']?></a></td><td><?=$row['priceb']?></td></tr>

<? } ?>

</table>

</body>

</html>

**DougD** · Mar 8, 2001, 16:43

PERFECT GUYS! Thanks again... this script is a HUGE time saver!

**atomicmunky** · Mar 8, 2001, 16:56

hey freddy,

could you explain why your way would be more efficient? just curious.

it just seems to me that my way might be a little easier to grasp.
maybe it's just because of my level of experience so far.

thanks.

**freddydoesphp** · Mar 8, 2001, 17:01

Well I have come to the conclusion that since this is a scripting language that the more you can leave tyhe html outside the <? ?> tags the better so instead of using PHP to echo out a whole line why not just put the php where it needs to be insead of using PHP to do a bunch of stuff html can handle. This method contradicts my previous code but I am learning too, and I feel that by keeping the html outside the <? ?> whenever possible will speed things up considerably. Your way isn't wrong, I just feel that we can improve on things as we grow. right?

**atomicmunky** · Mar 8, 2001, 17:26

i hadn't looked at it from that angle, but it makes sense.
it probably makes things easier to manage in the long run too.

i've definitely seen my coding style improve over the past few weeks. a little more organized and efficient. growing and improving definitely, partly because of your help. i think that i've undoubtably learned more from examining code that you and others have written than by just copying and pasting. i usually try to explain things whenever i post any code, because obviously that's when the real learning happens and i appreciate it when other people do the same, rather than just saying : " here's the code, just use it "

anyway, the point is that i get what you're saying.
thanks again.

**shane** · Mar 8, 2001, 19:41

freddy,

Does the switching between PHP and HTML not slow down the processing? I'm just asking as being an ASP coder it's often said that switching between ASP and HTML causes the ASP processor to start and stop. Is this not the case with PHP?

Just a curious ASP coder.

**freddydoesphp** · Mar 8, 2001, 19:56

Interesting Question! I am pretty sure that the interpreter, at least while running with Apache, is a running process and doesn't need to be started and stopped each time it finds php tags

**HostRocket.com John** · Mar 11, 2001, 18:25

When php is set up as an Apache module, it knows when to turn based on the file extension (.php, .phtml, .php3, .php4, etc). So even when you're outside of the php tags php is still running... its just looking for the next <? tag.

**exbabylon** · Mar 11, 2001, 18:36

freddy!

I have used this method for a long time because I was lazy, and didn't want to take the time to escape all of the stuff. But I have found in my large scripts lately that it does run faster with the least amount of stuff inside the <? ?> tags.

Some people say that it is slower because the PHP engine has to start and stop, but it starts when the .php, .php3, .phtml extensions are brought up. If is just as fast as the if/else stuff... it's just a "control". So really, it's very fast, but it's just scanning OVER the html, not printing it.

The SitePoint Forums have moved.

User Tag List

Thread: PHP Script Help...

Thread Tools

Display

Bookmarks

Bookmarks

Posting Permissions