[Eliminating array elements not containing string]

So I'm trying to unset array elements that don't contain "thumbnail" in the filename. Seems simple, but it's not working.

 

function generateImage3 ($category, $imageornot, $Imagepointer) {
    if($imageornot == 1){
    $var = get_cwd_uploads().'\\'.$Imagepointer; // get_cwd_uploads() is a custom function
    $scanned_directory = array_diff(scandir($var), array('..', '.'));
    foreach($scanned_directory as $elements){
    $pos = strpos($elements, 'thumbnail');
    if($pos === FALSE){
            unset($scanned_directory[key($elements)]);
        }
    }

// irrelevant code

 

Any help appreciated.

[Javascript bootstrap form validation]

I'm a major JS noob and this is driving me nuts. I'm trying to use this in a form:

 

http://reactiveraven.github.io/jqBootstrapValidation/

 

And using the examples, can't get anything to work. Only my browser's non-js HTML 5 form validation. Anybody have a simple that incorporates both HTML and JS? The examples only show the html.

[Using implode() in array to string conversions]

Thanks for everyone's responses.

[Using implode() in array to string conversions]

This is my code for displaying images from a folder:

 

 function generate_img ($imagepointer, $imageornot){
 if($imageornot == 1){
 $var = getcwd();
 $dirlocation = $var."\\imageuploads\\".$imagepointer;
 $files = array_diff(scandir($dirlocation), array('..', '.'));
 foreach ($files as $image){
 $data[] = array('label' => '<img src="/imageuploads/'.$imagepointer.'/'.$image.'" alt="thumbnail"> <br/>');
        };
    return $data;
    }
    else {
    return FALSE;
    }
 }

 

I'm using it with print_r:            

 

<p><?php print_r(generate_img($imagepointer, $imageornot)); ?></p>

 

 

Working ok, but obviously not good for a live site. Is implode() a good idea in this situation? And how would I use it?

Appreciated.

 

 

[Remaking & compressing images (works for jpeg, not png or gif)]

Thanks. Working great now.

[Remaking & compressing images (works for jpeg, not png or gif)]

function create_image($ext, $filepath, $newfilepath, $jpegquality){
switch ($ext){
case "jpg" OR "jpeg":
    $im = @imagecreatefromjpeg($filepath);
    if($im){
    imagejpeg($im, $newfilepath, $jpegquality);
}
break;
case "gif":
    $im = @imagecreatefromgif($filepath);
    if($im){
    imagegif($im, $newfilepath);
}
break;
case "png":
    $im = @imagecreatefrompng($filepath);
    if($im){
    imagepng($im, $newfilepath, 7);
}
break;
    }
if(!$im){
return FALSE;
    }
}

 

$ext is my file extention. The rest is pretty self explanitory. It's working for JPEG, but somehow not PNG or GIF. Not sure why, help appreciated. Thanks.

[Noob Q: Simple JS Alert POST callback to php script]

you can use AJAX 

How specifically?

[SQL query using prepared statements]

B/s for the beginners is much more descriptive and easier to understand what's going on behind the scene, but what about performance and memory consumption.

 

Here's my test with 500 000 records using a pdo driver and firebird for a testing database server. 

 

1.

while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
    
  $data[] = array($row[0],$row[1],$row[2]);
  
}

MemoryUsage: 414479kb
CountRows: 500000
ExecutionTime: 3.088 seconds

2.

$row = $stmt->fetchAll(PDO::FETCH_NUM);

MemoryUsage: 414490kb
CountRows: 500000
ExecutionTime: 2.011 seconds

It's true that the memory usage is a little bit more but the execution time is much, much better using the internal pdo fetchAll method. 

 

 

Fair enough. But how would I use $row = $stmt->fetchAll(); given my script? What would the while statement look like and could I use array notation for my column names?

 

Thanks for everyone's input.

[Noob Q: Simple JS Alert POST callback to php script]

 <td> <button onclick="alertdialog()"><span class="glyphicon glyphicon-trash"> </span></button></td>
<script>
function alertdialog(){
    window.confirm("Are you sure you want to delete this post?");
}
</script>

 

This is my code. I need to have a callback to a PHP script when a user decides to delete a post. I think html POST is the most unobtrustive way to do this. What's the easiest / most robust way to send data to a script when the user clicks OK?

 

Appreciated.

Mark

 

[SQL query using prepared statements]

Thanks alot! It worked perfectly.

[SQL query using prepared statements]

class getjson {
function query_db ($mysqli, $search_string){
    $query = "SELECT name, location, address FROM csv_table WHERE address LIKE CONCAT('%',?,'%')
    OR name LIKE CONCAT('%',?,'%')
    OR location LIKE CONCAT('%',?,'%') LIMIT 0,5";
    $stmt = $mysqli->prepare($query);
    $stmt->bind_param("sss", $search_string, $search_string, $search_string);
    $stmt->execute();
//    $stmt->bind_result($name, $location, $address); // not necessary for code to work
    $result = $stmt->get_result();
        while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)){
        foreach ($row as $value)
          {
                    $data[] = array(
                    'label' => $value .', '. $value.' '. $value ,
                    'value' => $value );
            }

        }
                return $data;
    }
}
$results = new getjson;
$results = $results->query_db($mysqli, $search_string);
print_r($results);
echo count($results);

 

 

I have the following code. It works, but I cannot get array notation working correctly. For instance, I would like to access $row['address'] to input into my array in the foreach statement. But I can't seem to get it to work after a couple hours. So any ideas appreciated.

 

Thanks, Mark
 

[AJAX dropdown to populate html form for GET request]

Hello forum,

 

So I've been developing an app mostly in PHP, but am rather afraid of JS. Hope to fix that.

 

I have an AJAX dropdown using JQuery to search locations. It works great. However, I want to make it similar to what is seen on this site:

 

http://placefinder.com/

 

As you can see, the dropdown, when clicked populates a box. Then the user submits the form and the data is used in the application.

 

I have no clue how to make the form populate with data from the DB (I'm using mySQL) when clicked. So far, I've only been able to make it clickable as a URL (not what I want, obvioiusly!)

 

Is there a way to do this on a really small, simple script for starters? I'm certain their is, but don't even know where to begin.

 

Any help appreciated