Jump to content

Archived

This topic is now archived and is closed to further replies.

opel

closing a DB

Recommended Posts

I am learning how to use PHP by hand coding everything.

my code below works to pull out a list of web links from the database and display them in a table. My question is should I have a DB close tag somewhere to close the DB for security reasons?

Here is my code:

[code]<?php
include ('connections/config.php');
include ('connections/dbconn.php');


$query  = "SELECT link_id, link_title, link_desc, category_id, link_display FROM tbl_links WHERE link_display='Yes'";
$result = mysql_query($query) or die("error querying database");
$i = 0;
while($result_ar = mysql_fetch_assoc($result)){
?>
<tr <?php if($i%2 == 1){ echo "class='tablerow2'"; }else{echo "class='tablerow1'";}?>>
<td>
<?php echo $result_ar['link_title']; ?></td>
<td>
<?php echo $result_ar['category_id']; ?>
</td>
<td class="button">
<a href="edit_link_detail.php?ID=<?php echo $result_ar['website']; ?>" title="Edit This Link">Edit</a>
</td>
<td class="button">
<a href="delete_link.php?ID=<?php echo $result_ar['website']; ?>" title="Delete This Link">Delete</a>
</td>
</tr>
<?php
$i+=1;

                   
}?>
</table>[/code]

Share this post


Link to post
Share on other sites
Nah, the script runs and connects to the database before the user can access it, just make sure anytime you take input you addslashes() and your fine.

Share this post


Link to post
Share on other sites
I'm quite sure you don't need to close it or anything, and i'm not sure it's possible either. All your php is server side, so nobody can get your passwords unless they have access to your server.

(Someone please correct me if i'm wrong)

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.