listing help

Posted on 16th Feb 2014 07:03 pm by admin

Hi,

at first, great new design!!! I like it,

i got a problem,

I want to list some tekst, but there is a users, users can list they own texts, and all teksts, and find words in all texts and in own texts

somethings is weong in my php code because ist dont work

At first here is the form file:

Code: <div>
<form name="TextSearchForm" action="<?php print "list_txt_search.php";?>" method="post" target="main">

<div><select name="sn_text_year" style="text-align: center;">
<option selected="selected"> Year </option>
<option value="2009">2009</option>
<option value="2010">2010</option>
<option value="2011">2011</option>
</select>
</div>

<div><select name="sn_text_author" style="text-align: center;">
<option selected="selected"> choose </option>
<option value=""> all txt </option>
<option value="<?php print $UsrNrID;?>"> my txt </option>
</select>
</div>

<div><input type="text" name="TextSearch" size="30" /></div>
<div><input type="submit" name="SubmitTxtSerch" value="LIST" class="Button" /></div>

</form>
</div>

3 selection is there:
"sn_text_year" (which year is text wroten)
"sn_text_author" (who is the author of the text - this is a cookie whith name of the user)
"TextSearch" (if the user want to find some word in database)


Code: <?php
$TextSearch = $_POST['TextSearch'];
?>



<?php
// UsrIdentify
$query_user = mysql_query("SELECT * FROM `sn_users` WHERE `sn_users_username` = '".$_COOKIE['loggedin']."'");

if(!$query_user){
print mysql_error();
exit;
}

$RequestUsrID = mysql_fetch_array($query_user);


$UsrID = $RequestUsrID['sn_users_id']; // HERE I CAN TAKE THE USERS ID
?>



<?php

if ( $TextSearch == '' && $UsrID ) {
$QeryUsr = "SELECT * FROM `sn_text` WHERE `sn_text_godina` = '" . $_POST['sn_text_year'] . "' AND `sn_text_author` = '" . $UsrID . "' ORDER BY `sn_text_id` DESC";
}

if ( $TextSearch == '' && $UsrID == '' ) {
$QeryUsr = "SELECT * FROM `sn_text` WHERE `sn_text_year` = '".$_POST['sn_text_year']."' ORDER BY `sn_text_id` DESC";
}

if ( $TextSearch && $UsrID == '' ) {
$QeryUsr = "SELECT * FROM `sn_text` WHERE ucase(`area1`) LIKE '%".$TextSearch."%' OR lcase(`area1`) LIKE '%".$TextSearch."%' AND `sn_text_year` = '".$_POST['sn_text_year']."' ORDER BY `sn_text_id` DESC";
}

if ( $TextSearch && $UsrID ) {
$QeryUsr = "SELECT * FROM `sn_text` WHERE ucase(`area1`) LIKE '%".$TextSearch."%' OR lcase(`area1`) LIKE '%".$TextSearch."%' AND `sn_text_year` = '".$_POST['sn_text_year']."' AND `sn_text_author` = '" . $UsrID . "' ORDER BY `sn_text_id` DESC";




// Admin capacityes
$query_user = mysql_query( $QeryUsr );

if(!$query_user){
print mysql_error();
exit;
}

while($request = mysql_fetch_array($query_user)) {

// list
}
?>


As You see You can choose:

1. Only year of text wroten
2. No text search, but identify User
3. No text search, no User identification - mean ilst all text
4. Search text, and identify User (mean searching word only in Users texts)

So, something is wrong, because:
1. when I choose Year, and list all text - list only my texts
2 when I choose Year, and list my texts - list only my texts
3. when I choose Year, and list my texts, with searching text - list only my text without choose
4. when I choos Year, and list all text, with serching text - its work fine

I see its a complicated, I hope, that You can give mi a solution

thanx

Your Answer:

Login to answer

Other forums

Strange PHP/mySQL error ... am I just tired?
Code: <?

## CONNECT TO DB FUNCTION!
function ConnectTo($db2con)
{
$hostNam

Final year project, please point me in the right direction
hi there for my final year project I'm aiming to build a php script shell to use as an expert system

preg_replace question
Hello!!

I hope someone can help me with preg_replace.

I load two tables from an extern

why does my session end?
my connect.php starts the session just so you know
i can navigate arround my site fine except whe

Most basic form question ever?
Hello,

I want to use this snippet to make sure the fields in a form are ok before processing

DYNPRO_FIELD_CONVERSION
Hi gurus,

I got a dump when I run one of my program. the dump is described below:

Save file by click
Hello.
I'm not understand how to save file from page. I'd like make link to file with save abil

need help modifying script
Hi guys,

I'm fairly new to php and am having a bit of trouble modifying a script.

This

New Search Engine problem
Hey everyone,

I have a ZIP Code Radius search engine already functional. it displays all of t

Request.UrlReferrer
I need to make it so that a page can only be loaded when a button is clicked on a specific page. I d