например так
view.php:
<?php
include "../../config.php";
$arr = get_gi_list();
if (count($arr) > 0)
{
$out .= "<table width=100%>";
for($i = 0; $i<count($arr); $i++)
{
list($gi_title, $gi_gm, $gi_url) = $arr[$i];
$out .= "<tr>
<td>$gi_title</td>
<td>$gi_gm</td>
<td><a href=\"http://$gi_url\" target=_blank>Перейти</a></td>
</tr>";
}
$out .= "</table>";
}
else
$out = "not found";
print $out;
//---------------------------------------------------------------------
function get_gi_list()
{
$q = "SELECT title, gm, url from uo_gi where active = 1";
$r = mysql_query($q) or die (mysql_error());
$back = Array();
if (mysql_num_rows($r) > 0)
{
while ($i = mysql_fetch_row($r))
array_push($back, $i);
}
return $back;
}
?>
add.php:
<?php
include "../../config.php";
$action = trim(htmlspecialchars($_GET['mode']));
switch ($action)
{
case "submit":
$gi_title = trim(htmlspecialchars($_POST['gi_title']));
$gi_email = trim(htmlspecialchars($_POST['gi_email']));
$gi_gm = trim(htmlspecialchars($_POST['gi_gm']));
$gi_url = trim(htmlspecialchars($_POST['gi_url']));
$gi_url = preg_replace("/^http:\/\//","",$gi_url);
//$gi_url = preg_replace("/^www./","",$gi_url); //некотрые говнари не прописывают алиас для www и может не работать
$gi_url = preg_replace("/\/$/","",$gi_url);
if ($gi_title != "" && $gi_email != preg_match("/^[a-z0-9._-]+@[a-z0-9._-]+.[a-z]{2,4}$/",$gi_email) && $gi_gm != "" && $gi_url != "")
{
if (add_gi ($gi_title, $gi_url, $gi_gm, $gi_email))
print "добавлено успешно.. возвращаемся к сайту...<META HTTP-EQUIV=Refresh CONTENT=\"2; URL=http://free.uoo.ru\">";
else
print "some shit happened";
}
else
print "фигвам. вернитесь в зад и заполните все поля.";
break;
default :
simple_form();
break;
}
//------------------------------------------------------
function add_gi($title, $url, $gm, $mail)
{
$q = "INSERT INTO uo_gi (title, url, gm, email) VALUES ('$title', '$url','$gm','$email')";
$r = mysql_query ($q) or die (mysql_error());
return mysql_insert_id();
}
function simple_form()
{
print "<form action=?mode=submit method=post>
<div>GI Name: <input name=gi_title></div>
<div>GI URL: <input name=gi_url></div>
<div>GI MasterName: <input name=gi_gm></div>
<div>REG Mail: <input name=gi_email></div>
<div><input type=submit></div>
</form>";
}
?>
таблица:
CREATE TABLE `uo_gi` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(64) NOT NULL,
`gm` varchar(64) NOT NULL,
`url` varchar(65) NOT NULL,
`email` varchar(32) NOT NULL,
`active` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251