Pagina 1 din 1
adauga in formular dupa numele din session
Scris: Dum Noi 20, 2011
de evident
am si eu un formular ce imi adauga in baza de date anunturi...as vrea ca la nume sa nu mai scrie cel care baga anuntul si sa fie preluat numele din session.scriptul de register si login functioneaza foarte bine la fel si cel care salveaza sesion la logare.
cum fac in acest formular unde am scriptul de adaugare asa:
Cod: Selectaţi tot
$data = date("Y-m-d H:i:s");
$zile = $_POST['zile'];
if(isset($_POST['titluanunt']) && isset($_POST['nume']) && isset($_POST['categorie']) && isset($_POST['sunteti']) && isset($_POST['textanunt']) && isset($_POST['pret']) && isset($_POST['moneda']) && isset($_POST['email']) && isset($_POST['nrtel']) && isset($_POST['judet']) && isset($_POST['localitate'])) {
$sql="INSERT INTO anunturi (titluanunt, nume, categorie, sunteti, textanunt, pret, moneda, email, nrtel, judet, localitate, data_adaugari, expira)
VALUES
('".$_POST['titluanunt']."','".$_POST['nume']."','".$_POST['categorie']."','".$_POST['sunteti']."','".$_POST['textanunt']."','".$_POST['pret']."','".$_POST['moneda']."','".$_POST['email']."','".$_POST['nrtel']."','".$_POST['judet']."','".$_POST['localitate']."',NOW(), DATE_ADD(NOW(), INTERVAL $zile DAY))";
Multumesc
adauga in formular dupa numele din session
Scris: Dum Noi 20, 2011
de claUdiu
Ai ceva de genul: $_SESSION['nume_sesiune_pt_user']; care afiseaza numele userului cu care s-a logat? Daca da, atunci fa o variabila si dupa aceea adauga in acel INSERT
adauga in formular dupa numele din session
Scris: Dum Noi 20, 2011
de evident
am facut asa...am facut o variabila care era egala cu sesiunea username. dar nu stiu cum sa o inserez acolo...cum am facut eu nu merge
Am pus doar
inainte de primul if...atat
adauga in formular dupa numele din session
Scris: Lun Noi 21, 2011
de claUdiu
Sterge isset($_POST['nume']), pune dupa $zile acea variabila iar dupa aceea sterge ".$_POST['nume']." din insert si pune $nume .
adauga in formular dupa numele din session
Scris: Lun Noi 21, 2011
de evident
ceva de genu
Cod: Selectaţi tot
VALUES
('".$_POST['titluanunt']."','".$nume."','".$_POST['categorie']."','".$_POST['sunteti']."','".$_POST['textanunt']."','".$_POST['pret']."','".$_POST['moneda']."','".$_POST['email']."','".$_POST['nrtel']."','".$_POST['judet']."','".$_POST['localitate']."',NOW(), DATE_ADD(NOW(), INTERVAL $zile DAY))";
imi zice Error: No database selected.
adauga in formular dupa numele din session
Scris: Lun Noi 21, 2011
de claUdiu
Ai chestia asta:
Cod: Selectaţi tot
mysql_connect("localhost", "user", "parola");
mysql_select_db(nume_db);
la inceputul scriptului?
adauga in formular dupa numele din session
Scris: Lun Noi 21, 2011
de evident
da.am asa:
Cod: Selectaţi tot
$con = mysql_connect("localhost","root","");
if (!$con) die('Could not connect: ' . mysql_error());
mysql_select_db("anunturi", $con);
e de la wamp...cand uploadez pe net merge...
Multumesc mult.
adauga in formular dupa numele din session
Scris: Lun Noi 21, 2011
de evident
acum am facuut o pagina unde daca esti logat sa iti apara anunturile tale.
cum as putea sa fac sa apara butoane cu delete in dreptul fiecarui anunt.
Pagina care afiseaza anunturile userului logat este:
Cod: Selectaţi tot
<?php
include "connect_to_mysql.php";
$user = $_SESSION['username'];
$sql = mysql_query("SELECT id, titluanunt, textanunt, pret, moneda, categorie FROM anunturi WHERE nume='" .$user. "' ORDER BY id DESC");
$nr = mysql_num_rows($sql);
if (isset($_GET['pn'])) {
$pn = preg_replace('#[^0-9]#i', '', $_GET['pn']);
} else {
$pn = 1;
}
$itemsPerPage = 10;
$lastPage = ceil($nr / $itemsPerPage);
if ($pn < 1) {
$pn = 1;
} else if ($pn > $lastPage) {
$pn = $lastPage;
}
$centerPages = "";
$sub1 = $pn - 1;
$sub2 = $pn - 2;
$add1 = $pn + 1;
$add2 = $pn + 2;
if ($pn == 1) {
$centerPages .= ' <span class="pagNumActive">' . $pn . '</span> ';
$centerPages .= ' <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add1 . '&id='.$user.'">' . $add1 . '</a> ';
} else if ($pn == $lastPage) {
$centerPages .= ' <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub1 . '&id='.$user.'">' . $sub1 . '</a> ';
$centerPages .= ' <span class="pagNumActive">' . $pn . '</span> ';
} else if ($pn > 2 && $pn < ($lastPage - 1)) {
$centerPages .= ' <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub2 . '&id='.$user.'">' . $sub2 . '</a> ';
$centerPages .= ' <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub1 . '&id='.$user.'">' . $sub1 . '</a> ';
$centerPages .= ' <span class="pagNumActive">' . $pn . '</span> ';
$centerPages .= ' <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add1 . '&id='.$user.'">' . $add1 . '</a> ';
$centerPages .= ' <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add2 . '&id='.$user.'">' . $add2 . '</a> ';
} else if ($pn > 1 && $pn < $lastPage) {
$centerPages .= ' <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub1 . '&id='.$user.'">' . $sub1 . '</a> ';
$centerPages .= ' <span class="pagNumActive">' . $pn . '</span> ';
$centerPages .= ' <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add1 . '&id='.$user.'">' . $add1 . '</a> ';
}
$limit = 'LIMIT ' .($pn - 1) * $itemsPerPage .',' .$itemsPerPage;
$sql2 = mysql_query("SELECT id, titluanunt, textanunt, pret, moneda, categorie, data_adaugari, expira FROM anunturi WHERE nume='" .$user. "' ORDER BY id DESC $limit");
$paginationDisplay = "";
if ($lastPage != "1"){
$paginationDisplay .= 'Page <strong>' . $pn . '</strong> of ' . $lastPage. ' ';
if ($pn != 1) {
$previous = $pn - 1;
$paginationDisplay .= ' <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $previous . '&id='.$cat.'"> Back</a> ';
}
$paginationDisplay .= '<span class="paginationNumbers">' . $centerPages . '</span>';
if ($pn != $lastPage) {
$nextPage = $pn + 1;
$paginationDisplay .= ' <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $nextPage . '&id='.$cat.'"> Next</a> ';
}
}
$outputList = '';
while($row = mysql_fetch_array($sql2)) {
$id = $row["id"];
$textanunt = $row["textanunt"];
$categorie = $row["categorie"];
$titluanunt = $row["titluanunt"];
$data_adaugari = $row["data_adaugari"];
$expira = $row["expira"];
$check_pic = "anunt/$id/poza.jpg";
$default_pic = "anunt/0/poza.jpg";
if (file_exists($check_pic)) {
$user_pic = "<img src=\"$check_pic\" width=\"100px\" height=\"60\" border=\"0\" />";
} else {
$user_pic = "<img src=\"$default_pic\" width=\"100px\" height=\"60\" border=\"0\" />";
}
$textanunt=''.$row['textanunt'].'';
$text = ucfirst($textanunt);
$textanuntCut = substr($text, 0, 150);
$titluanunt=''.$row['titluanunt'].'';
$titlu = ucfirst($titluanunt);
$titluanuntCut = substr($titlu, 0, 87);
$pret = $row["pret"];
$moneda = $row["moneda"];
$outputList .= '<table width="100%" height="1%" border="0">
<tr>
<td valign="top"><table width="100%" border="0" bordercolor="#CC0000" bgcolor="#CC0000">
<tr>
<td width="74%" bordercolor="#CC0000" bgcolor="#CC0000"><span class="style3"><a href="anunt.php?id=' . $id . '" target="_blank"><font color="white"><b>' . $titluanuntCut . '</b></font></a></span></td>
<td width="14%" bgcolor="#CC0000"><span class="style1"><a><span class="style3"><font color="white">' . $pret . ' ' . $moneda . '</font></span></a></span></td>
</tr>
</table>
<table width="100%" border="1" cellspacing="0" bordercolor="#CC0000">
<tr>
<td width="20%" rowspan="2"><div style="width="100" height="60" overflow:hidden;"><a href="anunt.php?id=' . $id . '" target="_blank">' . $user_pic . '</a> </td>
<td colspan="2" valign="top">' . $textanuntCut . ' </td>
</tr>
<tr>
<td width="40%" height="20" valign="top"><span class="style3">Data adaugari: ' . $data_adaugari . ' </span></td>
<td width="40%" valign="top"><span class="style3">Expira la: ' . $expira . ' </span></td>
</tr>
</table></td>
</tr>
</table>';
$outputList .= '';
}
-----------
Am reusit. Daca vrea cineva scriptul pm.
Multumesc