echo $_GET[‘7’]; global $current_user; get_currentuserinfo(); $user=$current_user->user_login;
if($_GET[‘cuvant’]){
$sqlAlf = ‘SELECT * FROM wp_alfabet’; $dosqlAlf = mysql_query($sqlAlf); echo(‘
‘); while($rowAlf = mysql_fetch_assoc($dosqlAlf)){ echo (‘ ‘.$rowAlf[‘litera’].’ ‘); } echo(‘
‘);
$query = ‘SELECT * FROM wp_dictionar WHERE cuvant=”‘.$_GET[‘cuvant’].'” ‘; $doQuery = mysql_query($query); $result = mysql_fetch_assoc($doQuery); if($user == ‘admin’){ echo (‘
‘.$result[‘cuvant’].’ =’.$result[‘descriere’].’
‘); } else { echo (‘
‘.$result[‘cuvant’].’=’.$result[‘descriere’].’
‘); } $query1 = ‘SELECT * FROM wp_posts WHERE post_title LIKE “‘.$_GET[‘cuvant’].’%” AND post_type=”‘.post.'” AND post_status=”‘.publish.'” ‘; $doQuery1 = mysql_query($query1); while($result1 = mysql_fetch_assoc($doQuery1)){ $content = $result1[‘post_content’]; echo ‘
Articole despre cuvantul afisat: ‘.substr($content,0,600).’…Citeste mai departe… ‘;
} }
if($_GET[‘1’]){
$sqlAlf = ‘SELECT * FROM wp_alfabet’; $dosqlAlf = mysql_query($sqlAlf); echo (‘Click pe cuvantul de interes pentru a citi informatii suplimentare: ‘); while($rowAlf = mysql_fetch_assoc($dosqlAlf)){ if($rowAlf[‘litera’] == $_GET[‘1’]){ echo (‘
‘.$rowAlf[‘litera’].’ ‘); } else { echo (‘
‘.$rowAlf[‘litera’].’ ‘); } } echo(‘
‘);
$query = ‘SELECT * FROM wp_dictionar WHERE cuvant LIKE “‘.$_GET[‘1′].’%” ORDER BY cuvant ASC’; $doQuery = mysql_query($query); if($user == ‘admin’){ while($row = mysql_fetch_assoc($doQuery)){ echo (‘
‘.$row[‘cuvant’] .’ =’. $row[‘descriere’].’ ‘); } } else { while($row = mysql_fetch_assoc($doQuery)){ echo (‘
‘.$row[‘cuvant’] .’ =’. $row[‘descriere’].’ ‘); } } } else {
$sqlAlf = ‘SELECT * FROM wp_alfabet’; $dosqlAlf = mysql_query($sqlAlf); echo (‘ Click pe cuvantul de interes pentru a citi informatii suplimentare:
‘); while($rowAlf = mysql_fetch_assoc($dosqlAlf)){ echo (‘ ‘.$rowAlf[‘litera’].’ ‘); } echo(‘
‘); }
if($_GET[‘com’]){ $sqlEdit = ‘SELECT * FROM wp_dictionar WHERE id=”‘.$_GET[‘id’].'” ‘; $dosqlEdit = mysql_query($sqlEdit); $rowEdit = mysql_fetch_assoc($dosqlEdit);
echo(‘
‘); } else if($_POST[‘update’]){ $sqlUpd= ‘UPDATE wp_dictionar SET cuvant=”‘.$_POST[‘cuvant’].'” , descriere=”‘.$_POST[‘descriere’].'” WHERE id=”‘.$_POST[‘id’].'” ‘; $dosqlUpd = mysql_query($sqlUpd); if($dosqlUpd){ echo(‘Cuvantul a fost modificat!’); } }
if($_POST[‘ccuvant’]){ $sqlCauta = ‘SELECT * FROM wp_dictionar WHERE cuvant=”‘.$_POST[‘cauta’].'” ‘; $dosqlCauta = mysql_query($sqlCauta); $rowsqlCauta = mysql_num_rows($dosqlCauta); if($rowsqlCauta){ $query = ‘SELECT * FROM wp_dictionar WHERE cuvant=”‘.$_POST[‘cauta’].'” ‘; $doQuery = mysql_query($query); $result = mysql_fetch_assoc($doQuery); if($user == ‘admin’){ echo (‘
‘.$result[‘cuvant’].’ =’.$result[‘descriere’].’
‘); } else { echo (‘
‘.$result[‘cuvant’].’=’.$result[‘descriere’].’
‘); } $query1 = ‘SELECT * FROM wp_posts WHERE post_title LIKE “‘.$_POST[‘cauta’].’%” AND post_type=”‘.post.'” AND post_status=”‘.publish.'” ‘; $doQuery1 = mysql_query($query1); while($result1 = mysql_fetch_assoc($doQuery1)){ $content = $result1[‘post_content’]; echo ‘
Articole despre cuvantul afisat: ‘.substr($content,0,600).’…Citeste mai departe… ‘; } } else {
echo(‘
Cuvantul cautat nu a fost gasit! Il poti propune pentru dictionar completand campurile de mai jos: ‘);
} }
if($_POST[‘mail’]){ $headers = ‘MIME-Version: 1.0’ . “rn”; $headers .= ‘Content-type: text/html; charset=iso-8859-1’ . “rn”; $headers .= “From: Apolloniadent.ro”;
$mesaj = ‘Cuvant propus: E-mail: Nume: Prenume: Telefon: ‘; mail(“office@markinstinct.ro”,”Cuvant propus”,$mesaj,$headers); echo(‘Multumim!’); }