الحمد لله الذ مكنني من تصحيحه وهو شغال 100%
المقابل : أدع لي الله يوفقني ويحفظني القرآن ويغفر لوالدي ويدخلهما الجنه ويرزقني الزوجه الصالحة
كود PHP:
<html>
<head>
<title>A PHP-DBX URL Organizer</title>
<style type=text/css>
p, ul, td, h1, h2, h3 {font-family: verdana, helvetica, sans-serf;}
</style>
</head>
<body>
<?
/*****
TABLE DEFINITION FOR THIS EXAMPLE:
create table URLS (
url VARCHAR(128) not null,
description TEXT,
primary key (url));
*****/
//define $MODULE as DBX_MYSQL, OR ANOTHER DATABASE SUPPORT
$MODULE = DBX_MYSQL;
$server = "localhost" ;
$user = "" ; //ÇÓã ÇáãÓÊÎÏã áÞÇÚÏÉ ÇáÈíÇäÇÊ
$password = "" ; //ÇáÈÇÓææÑÏ
$database = "" ; //ÇÓã ÞÇÚÏÉ ÇáÈíÇäÇÊ
/*FUNCTION*/
function get_urls($dbconn, $sql) {
$result = @dbx_query($dbconn, $sql) ;
if ( $result == 0 ) {
echo dbx_error($dbconn) ;
} else {
return $result;
}
}
function url($action, $dbconn, $url, $description) {
if($action == "add") {
$sql = "insert into URLS values('$url', '$description') " ;
}elseif($action == "delete") {
$url = urldecode($url) ;
$sql = "delete from URLS where URL = '$url'" ; // ÊÇßÏ ãä åÐÇ ÇáÓØÑ
}
$result = @dbx_query($dbconn, $sql) ;
if ( $result == 0 ) {
echo "<p>ERROR ADDING URL: " . dbx_error($dbconn) ;
} else {
print("<p>$action : $url succeeded!<p>") ;
}
}
$dbconn ='dbx_connect($MODULE, $server, $database, $user, $password) or die("CANNOT CONNECT TO DATABASE")';
?>
<h1>PHP DBX URL Organizer</h1>
<from action=dbx_urls.php method=post>
<p><b>Add a URL:</b>
<br>Url: <input type="text" name="url" maxlength="128" value="http://"> Description: <input type="text" name="description"> <input type="submit" name="addurl" value="Add URL!">
</from>
<?
if(isset($addurl)) {
url("add", $dbconn, $url, $description);
}
if(isset($delete)) {
url("delete", $dbconn, $delete, "");
}
$sql = "select * from URLS";
$result = get_urls($dbconn, $sql);
if(sizeof($result->data) == 0) {
?>
<h3>Sorry, there are no URLs in the database. you should add some.
<?
} else {
?>
<p>
<table border=1 cellpadding=5 cellspacing=0 width=600>
<tr><td><b>URL</b></td><td><b>Description</b></td><td> </td></tr>
<?
for($i = 0; $i <sizeof($result->data); $i++) {
?>
<a href=<?=$result->data[$i]['url']?>><?=$result->data[$i]['url']?></a> //ÚáÇãÉ ÇáÊäÕíÕ ÇáÃÎÑì ÈÚÏ url
<td><?=$result->data[$i]['description']?>></td>
<td width=1><a href=dbx_urls.php?delete=<?=urlencode($result->data[$i]['url'])?>>delete</a></tr>
<?
}
?></table><?
}
?>
</body>
</html>
