Pessoal tenho duas tabelas:
users:
id,nome,mail
Links:
id,url,nome,tag,descrição
Esta form vai me enviar os links para a tabela links, eu queria era ficar com uma ideia de como posso fazer para este codigo ir buscar também o id do user que está logado neste momento...
<?php
// This page is for editing a user record.
// This page is accessed through view_users.php.
$page_title = 'insert link';
require_once ('includes/config.inc.php');
include ('includes/header.html');
$usr = "xxxx";
$pwd = "xxxx";
$db = "xxxx";
$host = "localhost";
# connect to database
$cid = mysql_connect($host,$usr,$pwd);
if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); }
?>
<HTML>
<HEAD>
</HEAD>
<BODY BGCOLOR="#FFFFFF">
<h1>Insert Link</h1>
<?
# this is processed when the form is submitted
# back on to this page (POST METHOD)
if ($REQUEST_METHOD=="POST") {
# double-up apostrophes
$description = str_replace("'","''",$description);
$sitename = str_replace("'","''",$sitename);
# setup SQL statement
$SQL = " INSERT INTO links ";
$SQL = $SQL . " (category, sitename, siteurl, description) VALUES ";
$SQL = $SQL . " ('$category', '$sitename','$siteurl','$description') ";
#execute SQL statement
$result = mysql_db_query($db,"$SQL",$cid);
# check for error
if (!$result) { echo("ERROR: " . mysql_error() . "\n$SQL\n"); }
echo ("<P><B>New Link Added</B></P>\n");
}
?>
<FORM NAME="fa" ACTION="insert_link.php" METHOD="POST">
<TABLE>
<TR><TD><B>Tag: </B> </TD><TD><INPUT TYPE="text" NAME="category" SIZE=40></TD></TR>
<TR><TD><B>Site Name:</B> </TD><TD><INPUT TYPE="text" NAME="sitename" SIZE=40></TD></TR>
<TR><TD><B>Site URL: </B> </TD><TD><INPUT TYPE="text" NAME="siteurl" VALUE="http://" SIZE=40></TD></TR>
<TR><TD VALIGN=TOP><B>Description: </B> </TD><TD> <TEXTAREA NAME="description" ROWS=5 COLS=40></TEXTAREA></TD></TR>
<TR><TH COLSPAN=2><P><INPUT TYPE="submit" VALUE="Add Link"></P></TH></TR>
</TABLE>
</FORM>
<? mysql_close($cid); ?>
</BODY>
</HTML>
PS: Sou muito nood a fazer coisas de raiz, é o mal dos cms! :/