PHP - Array Hierarchy And Filter

hi every1
im driveing crazy with this... i have a database with a field with descriptions of products named "DESCRIP" in the main page i have a text field where user write the words to search for i wanrt make an
       "SELECT * FROM models where descrip like xxx OR descrip like xxx... bla bla bla"

i wrote this code but send me an error... waht can be wrong???

$word='"SELECT * FROM models WHERE descrip LIKE ' ."'";
$srched=$_POST['words'];
$pieces = explode(" ", $srched);
$all=count($pieces)-1;

for($i=0;$i<=$all;$i ++) {
     $word = $pieces[$i] ."'";
    if($i!=$all) {
       $word .= $word . ' OR descrip like ' . "'";
    } else {
      $word .= $word .'"' . ";";
    }
}

$colname=$word;
mysql_select_db($database_zero1, $zero1);
$query_srch = $colname;
$buscar = mysql_query($query_srch, $zero1) or die(mysql_error());
$row_srch = mysql_fetch_assoc($srch);
$totalRows_srch = mysql_num_rows($srch);

tnx in advcd

I am creating a football predictor game and have a table in the database to hod all my users i have written a query to pull all out the users that have made a prediction that day with their predictions made i have put this into an array so my array will hold all the user details 1 being their userId I have set the order by on the query to userId so I get all the same users predictions in 1 block. I now want to extract all the predictions for each user and put these into their own array but I don't know which users the array will hold, how many users their will be, or how many predictions each user would have made so i'm not sure how to create this array i'm quite new to php can anyone help me with this

Hi, i'm new here and hope i've finally found a forum where i can find the perfect solution for my questions.   Well since a year now i started to work with PHP and still now and then there are some things where i seize on. My question is on of those situations.   I have the following code:

if (isset($_POST)){
    
    foreach ($_POST as $key => $value){

    if (!empty($value)){
    $update_rma_detail_stmt = $dbh->prepare("UPDATE rma_detail SET $key = ? WHERE rd_rma_nr = ?");
    $update_rma_detail_stmt->bindParam(1, $value);
    $update_rma_detail_stmt->bindParam(2, $getadmrmaid);
    $update_rma_detail_stmt->execute();

    }
  } 
}

All i want is when there is an empty (not filled in) input field because it is not mandatory the foreach still continuous to the end. When i use

if (!empty($value)){

It still outputs these error:   Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ' '   However, when i dont use i got an other error:    Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect date value: ''   It is however so that the datetime is the very first empty field it come across when looping. I think my if (!empty($value)){ is doing the right thing but still gives error's on integers. Can it be? I allready tried to use trim() or array_filter() but because i previously never used it i dont know if i am doing it the right way so any help is welkom!   Thanks!
Edited by Raz3rt, 20 May 2014 - 02:56 AM.

Say I have this array:

Code: [Select]
array(
0 => time
1 => time
2 => to
3 => to
4 => to
5 => fly
);
and 2 variables - $occMin and $occMax as number of occurrences.

If:

Code: [Select]
$occMin = 2;
$occMax = 3;

I want to produce sorted list with most occurrences at the top:

Code: [Select]
array(
0 => array('to', 3),
1 => array('time', 2)
);
My face just melted at the thought of even beginning to tackle this. Is this somewhat possible? would it require a monster function or am I missing some native php functions which could lend a hand?

having a problem importing a file having multiple hierarchy levels!! its a csv file the contents look something like this! just need a jump start! thanks
the file looks likes this

row 1     row2   row3
name1   subj1   abcd
                          efgh

            subje2   test1
                          test2

the file has to first import name1 then subj1 then abcd,then efgh then move back to subj2 and so on!

Thanks

Im new to PHP and have had success with much help from the community and am greatly thankful for all input.

I have a pretty good understanding of what needs to be done, but actually implementing and accomplishing is difficult for me.

Im trying to break down hierarchy from an existing HTML list.
First Id like to point out that I am working with an HTML file that I must use, and cannot change, as the source.

I am rewriting onto another file, removing HTML, and so forth.  I have already accomplished this.  But what I would really like to keep the hierarchy structure by breaking it down first, so I can also use that later.

Example HTML list
Code: [Select]
<ul><li>modem, UP</li>
<ul><li>wifiRouter, UP</li>
<ul><li>PC1, DOWN</li>
<ul></ul> <!-- Open-close of UL identifies end -->
</ul> <!-- Up one level -->
<ul><li>wiredRouter, UP</li>
<ul><li>server, UP</li>
<ul><li>dnsServer, UP</li>
<ul></ul> <!-- Open-close of UL identifies end -->
<ul><li>webServer, UP</li>
<ul></ul> <!-- Open-close of UL identifies end -->
</ul> <!-- Up one level -->
<ul><li>PC2, UP</li>
<ul></ul> <!-- Open-close of UL identifies end -->
</ul> <!-- Up one level -->
</ul> <!-- Up one level -->
<ul><li>modemBackup, DOWN</li>
<ul></ul> <!-- Open-close of UL identifies end -->
</ul>

Desired Output:
Code: [Select]
1, 0, 0, 0, modem, UP
1, 1, 0, 0, wifiRouter, UP
1, 1, 1, 0, PC1, DOWN
1, 2, 0, 0, wiredModem, UP
1, 2, 1, 0, server, UP
1, 2, 1, 1, dnsServer, UP
1, 2, 1, 2, webServer, UP
1, 2, 2, 0, PC2, UP
2, 0, 0, 0, modemBackup, DOWN

If im logically looking at this right
(1) Count <ul> entry and continue counting for each group
(2) Stop group count at end argument <ul></ul>
(3) The immediate next end argument </ul>, following (2), says to continue counting the previous group +1
(4) Repeat steps 1-3 until end

Any advise?

I'm using a CRUD system which won't automatically update the lft and rght values of my hierarchical tables when I enter a new row. I don't know what the best way to solve this is, all I can think of is adding a stored procedure to the table so that whenever a new row gets added, the procedure will make sure the lft and rght values get shifted. Is this even possible with stored procedures?

Hello,

I'm not able to figure how to fix these warnings / errors I'm getting. The file that I'm creating comes out correctly so it's as if I need some type of conditional to end the function calls or something? I'm really stumped with this one...

Code: [Select]
Undefined index:  1
Invalid argument supplied for foreach()
Undefined index:  4
Invalid argument supplied for foreach()
Undefined index:  7
Invalid argument supplied for foreach()
Undefined index:  21
Invalid argument supplied for foreach()
Undefined index:  2
Invalid argument supplied for foreach()
Undefined index:  11
Invalid argument supplied for foreach()
Undefined index:  6
Invalid argument supplied for foreach()
Undefined index:  22
Invalid argument supplied for foreach()
Undefined index:  24
Invalid argument supplied for foreach()

Here is a var_dump of $menu

Code: [Select]
array(2) { ["items"]=> array(12) { [1]=> object(stdClass)#17 (10) { ["id"]=> string(1) "1" ["name"]=> string(4) "HOME" ["parent"]=> string(1) "0" ["type"]=> string(9) "slideshow" ["order"]=> string(1) "1" ["visible"]=> string(4) "true" ["image"]=> NULL ["color"]=> NULL ["link"]=> NULL ["target"]=> NULL } [5]=> object(stdClass)#18 (10) { ["id"]=> string(1) "5" ["name"]=> string(4) "INFO" ["parent"]=> string(1) "0" ["type"]=> string(6) "parent" ["order"]=> string(1) "2" ["visible"]=> string(4) "true" ["image"]=> NULL ["color"]=> NULL ["link"]=> NULL ["target"]=> NULL } [3]=> object(stdClass)#19 (10) { ["id"]=> string(1) "3" ["name"]=> string(9) "GALLERIES" ["parent"]=> string(1) "0" ["type"]=> string(6) "parent" ["order"]=> string(1) "3" ["visible"]=> string(4) "true" ["image"]=> NULL ["color"]=> NULL ["link"]=> NULL ["target"]=> NULL } [18]=> object(stdClass)#20 (10) { ["id"]=> string(2) "18" ["name"]=> string(16) "GALLERY SECTIONS" ["parent"]=> string(1) "0" ["type"]=> string(14) "gallery_portal" ["order"]=> string(1) "4" ["visible"]=> string(4) "true" ["image"]=> string(11) "DSC0250.jpg" ["color"]=> string(6) "848a5a" ["link"]=> NULL ["target"]=> NULL } [22]=> object(stdClass)#21 (10) { ["id"]=> string(2) "22" ["name"]=> string(7) "CONTACT" ["parent"]=> string(1) "0" ["type"]=> string(5) "forms" ["order"]=> string(1) "5" ["visible"]=> string(4) "true" ["image"]=> NULL ["color"]=> NULL ["link"]=> NULL ["target"]=> NULL } [24]=> object(stdClass)#22 (10) { ["id"]=> string(2) "24" ["name"]=> string(12) "MAILING LIST" ["parent"]=> string(1) "0" ["type"]=> string(5) "forms" ["order"]=> string(1) "6" ["visible"]=> string(5) "false" ["image"]=> NULL ["color"]=> NULL ["link"]=> NULL ["target"]=> NULL } [2]=> object(stdClass)#23 (10) { ["id"]=> string(1) "2" ["name"]=> string(7) "WEDDING" ["parent"]=> string(1) "3" ["type"]=> string(7) "gallery" ["order"]=> string(1) "1" ["visible"]=> string(4) "true" ["image"]=> NULL ["color"]=> NULL ["link"]=> NULL ["target"]=> NULL } [4]=> object(stdClass)#24 (10) { ["id"]=> string(1) "4" ["name"]=> string(8) "ABOUT US" ["parent"]=> string(1) "5" ["type"]=> string(9) "text_page" ["order"]=> string(1) "1" ["visible"]=> string(4) "true" ["image"]=> NULL ["color"]=> NULL ["link"]=> NULL ["target"]=> NULL } [7]=> object(stdClass)#25 (10) { ["id"]=> string(1) "7" ["name"]=> string(8) "CALENDAR" ["parent"]=> string(1) "5" ["type"]=> string(8) "calendar" ["order"]=> string(1) "2" ["visible"]=> string(4) "true" ["image"]=> NULL ["color"]=> NULL ["link"]=> NULL ["target"]=> NULL } [21]=> object(stdClass)#26 (10) { ["id"]=> string(2) "21" ["name"]=> string(14) "PORTFOLIOSITEZ" ["parent"]=> string(1) "5" ["type"]=> string(8) "external" ["order"]=> string(1) "3" ["visible"]=> string(4) "true" ["image"]=> NULL ["color"]=> NULL ["link"]=> string(25) "http://portfoliositez.com" ["target"]=> string(6) "_blank" } [11]=> object(stdClass)#27 (10) { ["id"]=> string(2) "11" ["name"]=> string(9) "LANDSCAPE" ["parent"]=> string(2) "18" ["type"]=> string(7) "gallery" ["order"]=> string(1) "1" ["visible"]=> string(4) "true" ["image"]=> NULL ["color"]=> NULL ["link"]=> NULL ["target"]=> NULL } [6]=> object(stdClass)#28 (10) { ["id"]=> string(1) "6" ["name"]=> string(9) "PORTRAITS" ["parent"]=> string(2) "18" ["type"]=> string(7) "gallery" ["order"]=> string(1) "2" ["visible"]=> string(4) "true" ["image"]=> NULL ["color"]=> NULL ["link"]=> NULL ["target"]=> NULL } } ["parents"]=> array(4) { [0]=> array(6) { [0]=> string(1) "1" [1]=> string(1) "5" [2]=> string(1) "3" [3]=> string(2) "18" [4]=> string(2) "22" [5]=> string(2) "24" } [3]=> array(1) { [0]=> string(1) "2" } [5]=> array(3) { [0]=> string(1) "4" [1]=> string(1) "7" [2]=> string(2) "21" } [18]=> array(2) { [0]=> string(2) "11" [1]=> string(1) "6" } } }

And here is the code

Code: [Select]
public function sitemap()
{
$query = $this->db->order_by('parent', 'asc')->order_by('order', 'asc')->get('menu');

foreach($query->result() as $row)
{
$menu['items'][$row->id] = $row;
$menu['parents'][$row->parent][] = $row->id;
}

function build_map($parent, $menu, &$data)
{
foreach($menu['parents'][$parent] as $itemId)
{
if(!isset($menu['parents'][$itemId]))
{
if(($menu['items'][$itemId]->parent == 0) && ($menu['items'][$itemId]->visible != 'false'))
{
$name = str_replace(' ','-', $menu['items'][$itemId]->name);
$data .= "\t<url><loc>" . base_url() . "#!/". $name ."</loc></url>\n";
}
elseif($menu['items'][$itemId]->visible != 'false' && $menu['items'][$itemId]->type !='external' && $menu['items'][$itemId]->type != 'parent')
{
$name   = str_replace(' ','-', $menu['items'][$itemId]->name);
$name2 = str_replace(' ','-', $menu['items'][$menu['items'][$itemId]->parent]->name);
$data .= "\t<url><loc>" . base_url() . "#!/". $name2 ."/" . $name ."</loc></url>\n";
}
}

if(isset($menu['parents'][$itemId]) && $menu['items'][$itemId]->visible != 'false' && $menu['items'][$itemId]->type != 'parent' && $menu['items'][$itemId]->type !='external')
{
$name = str_replace(' ','-', $menu['items'][$itemId]->name);
$data .= "\t<url><loc>" . base_url() . "#!/". $name ."</loc></url>\n";
}

build_map($itemId, $menu, $data);
}
}

$data = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<urlset xmlns=\"http://www.sitemaps.org/schemas/sitemap/0.9\">\n\t<url><loc>".base_url()."</loc></url>\n";

build_map(0, $menu, $data);

$data .= "</urlset>";

write_file('sitemap.xml', $data);
}

I have a MySql table full of records.

id
owner
car
location

on my page i have these results in a table i want to set a filter up so the table will only show cars from eg location England.
at the minute its just set to show cars that owner has but i want a location filter any help

Hi, I want to use an external rss in my site but the problem is that i only want to grab feeds that contain certain keywords in the title,   This is what i got so far to display the feed:

<?php

$html = "";
$url = "http://www.feedsite.com/conv-rss.asp";
$xml = simplexml_load_file($url);

for($i = 0; $i < 5; $i++){

	$title = $xml->channel->item[$i]->title;
	$link = $xml->channel->item[$i]->link;
	$description = $xml->channel->item[$i]->description;
	$pubDate = $xml->channel->item[$i]->pubDate;

	$html .= "<a href='$link'><h3>$title</h3></a>";
	$html .= "$description";
	$html .= "<br />$pubDate<hr />";

}
echo $html;
?>

The feed is a classified jobs but i only need the jobs listed for musicians, keywords could be: bassist, singer, drummer, musician, etc..    Thanks

I'm having some problems with a piece of software I use on a clients website. There is a "related items" function module available, with this module you can filter to show items from the same category OR in the same city. But now my client want's the module to show only items that are located in the same category AND the same city.   My PHP knowledge is just not good enough to solve this myself, that's why I ask for advice here. I already defined the lines of code that manage the filter, but I don't know how to make this from an "OR" filter to an "AND" filter. Can someone help me with this?

// Join over prop mid table if getting related by category
            if($search_cat)
            {
                $cats = ipropertyHTML::getAvailableCats($property->id);
                
                if($cats)
                {
                    $searchwhere[] = 'pm.cat_id IN ('.implode(',', $cats).')';
                }
            }        
            
            // Filter by city.
            if($property->city && $search_city)         $searchwhere[] = 'p.city = '.$db->Quote($property->city);            
            
            if( count($searchwhere)) $query->where('('.implode(' OR ', $searchwhere).')');

I have attached the complete file in case that gives a better insight in the filter function.   Best regards, Niels Attached Files  helper.php   4.79KB   1 downloads

Hi there,

I have one question about the function rand(),

What if i want to have an number between 0 and 360

Without 90 to 180

so 91,92,93,94.....180 can't be the number

how can i do that?

btw, I know its possible through if,while,for and so on. But is there an other way to do this?

HI all,

Yesterday i read quite alot about htmlentities() htmlspecialchars() mysql_real_escape_string
But today i stumbled upon filter()  (http://www.w3schools.com/php/php_filter.asp). Does anyone know if this is also a good way to sanitize and may even be an alternative for the other functions? OR is it something completly different? I am still a novice with this so please enlighten me : )

TY

Hey guys i am using a global filter on my $_POST

function filter($str){return htmlentities($str, ENT_QUOTES);}
$_POST = array_map('filter', $_POST);

It helps me encode the stuff into the database.
It works great on all my fields exept my arrays ...

Ex: fields like this <input type="text" name="name[]" size="20"> breaks

Any sugestions on gething this global filter working?

Hi.

I was hoping someone could tell me whether this is possible and if so how I could go about doing it preferably with a tutorial as im pretty new to programming.

I have a database that will contain 100's of records. I want users to be able to select filter parameters on this data by both text and checkboxes with it automatically updating the results (hopefully without page reload).

I managed this so far using this Jquery filter script: http://www.picnet.com.au/picnet-table-filter.html. As this will table will have so many rows however I think it would take ages to load so instead I would like to paginate the table but still allow filters applied to affect all records not just the ones displayed on the current page.

Any ideas on how i could do this? Thanks in advance for your help.