PHP - Dropdownlist Which Queries Database And Searches Images From Folder.

As we know the total number of hits to database is proportional to the number of page views if page views * queries per page is more than the capacity of your database, then mysql queries may show  problem.  is there any way to calculate the database capacity ? I googled someone says 128Mb cache is there for mysql.

I am just new to relational algebra probably a pre-step before learning SQL queries. Can you help me make the expressions of relational algebra expression for each of the following queries. This is the table contained inside a bus driver database.

driver ( driver_id, driver_name, age, rating );
bus ( bus_id, bus_name, color);
reserves ( driver_id, bus_id, date);

a. Find the names of drivers who have reserved at least three busses. 
b. Find the names of drivers who have reserved all busses. 
c. Find the names of drivers who have reserved all busses called Shuttle. 
d. Find the IDs of drivers whose rating is better than some driver called Paul.   I would be grateful if somebody can help me here. 

Hi, I want to be able to click on the photo and go to the next one in a folder. I have this code already, I just am not quite sure how to finish it.

-George
Code: [Select]
<?php
$count = $_GET['count'];
$dir = "images";
$names = array();
$handle = opendir($dir);
while ($name = readdir($handle)){
if(is_dir("$dir/$name")) {
if($name != '.' && $name != '..') {
echo "directory: $name\n";
}
} elseif ($name != '.DS_Store' ) {

$names[] = $name;
}

}
closedir($handle);
$numberofitems =  count($names);
$numberofitems--;


if ($count <= $numberofitems){


echo "<p>";
echo "<img src='images/".$names[$count]."'>";

} else {echo "end";}



?>

Hi im new to php and I need help making webpage that queries a mysql database based on a 3 check boxes and displays results on the same page or on another page. The table being queried has 4 columns, name, gps, wifi, bluetooth. So for example a row in the table would be like, samsung galaxy s2, yes, yes, yes. The idea is for it to be a website that will display phones according to their features.

So the idea is depending on if the boxes were ticked the samsung galaxy would be displayed as a result. So i need some help understanding how to make this.

Some1 gave me the code below in attempt to help me (im not sure it works or not) but im not sure how fully use it, ie what pages i need to make and how i create the connection to the mysql database, and how to use the query that they wrote to display the results

thanks

code:
Code: [Select]
<form action="?do=filter" method="post">
<table cellspacing="0" cellpadding="3" border="1">
<tr>
<td>GPS<input type="checkbox" name="gps" value="checked"></td>
<td>Wifi<input type="checkbox" name="wifi" value="checked"></td>
<td>Bluetooth<input type="checkbox" name="bluetooth" value="checked"></td>
</tr>
<tr><td><input type='submit' name='filter' value='Filter'></td></tr>
</table>
</form>
</html>
<?php
function filterMe($filter){
if(isset($_POST[$filter])){
return "Yes";
}else{
return "No";
}
}

if(isset($_POST['filter'])){
echo "Gps - " . filterMe('gps');
echo "
Wifi - " . filterMe('wifi');
echo "
Bluetooth - " . filterMe('bluetooth');
}
?>


All you need to do is use a query something like
SELECT name,gps,wifi,bluetooth FROM `product` WHERE `gps`='".filterMe('gps')."' AND `wifi`='".filterMe('wifi')."' AND `bluetooth`='".filterMe('bluetooth')."'

I made an upload image system, the images are stored in a folder, while the image name is stored in database. When I try to execute the image name, it works successfully, but when I try to disply the image from the folder by using the image name in the database, I fail each time.

The folder where the images are being stored is named: saveimage

Here is the query:

Code: [Select]
<?php
mysql_connect('localhost', 'root', '') or die ('Connection Failed');
mysql_select_db('imagedatabase');
$images = mysql_query("SELECT * FROM img WHERE email='$lemail'");
while($row = mysql_fetch_array($images))
{
echo "<img src='saveimage/'".$row['img_description'];
 }
?>

The problem:

I'm trying to create a page which outputs images from a folder which I have been
able to do, but the problem I'm having is not being able to get the page to display
the most recent image according to file modification date at the top.

The first set of code below outputs the image timestamps in descending order, from newest to oldest which is
what I want, but as soon as I change/add a couple lines of code (Shown in the second lot of code) to get the image
file name along with the timestamp, the echoed list (timestamp and file names) gets muddled up in a random order.

In short;
As soon as the file names are retrieved with the timestamp, the list
goes from being organised descendingly, to not.

Show timestamp only code (1st lot of code):

<?php

//Open images directory
$ignore = array("..",".");

$dir = opendir("images1");

$images = array();

$sortedimages = array();

//List files in images directory
while (($file = readdir($dir)) !== false) 

if (!in_array($file, $ignore))

$images[] = $file;

foreach ($images as $image)

{

$filetime = filemtime("images1/$image");

$sortedimages[] = $filetime;

}

rsort($sortedimages);

foreach ($sortedimages as $sorted)

{

//foreach ($sorted as $key => $value)

//{

echo "$sorted<br/>";

}

//}

closedir($dir);

?>

The show timestamp and file name code (2nd lot of code):

<?php

//Open images directory
$ignore = array("..",".");

$dir = opendir("images1");

$images = array();

$sortedimages = array();

//List files in images directory
while (($file = readdir($dir)) !== false) 

if (!in_array($file, $ignore))

$images[] = $file;

foreach ($images as $image)

{

$filetime = filemtime("images1/$image");

$sortedimages[] = array($filetime => $image);

}

rsort($sortedimages);

foreach ($sortedimages as $sorted)

{

foreach ($sorted as $key => $value)

{

echo "$key and $value<br/>";

}

}

closedir($dir);

?>

The changes made in the 2nd script from the 1st:

//Changed:
$sortedimages[] = $filetime; ---> $sortedimages[] = array($filetime => $image);

//Included the previously commented out:
foreach ($sorted as $key => $value)
{

}

//Changed:
echo "$sorted<br/>"; ---> echo "$key and $value<br/>";

Thanks for any help!

Can someone tell me how I can remove or delete an image from a folder on a server using PHP? I tried this:


Code: [Select]
unlink("http://midwestcreativeconsulting.com/jhrevell/wp-content/themes/twentyten_3/upload/" . $location);


before my delete MySQL statement, but I keep getting this error:


Warning: unlink() [function.unlink]: http does not allow unlinking in /home/midwestc/public_html/jhrevell/wp-content/themes/twentyten_3/removejewelry.php on line 22

Can anyone help and tell me how I can make it work?

I'm trying to write code that will let me pull 10 out of 15 images out of a folder and display them on my site. The images are all different, and I don't want dupes to show. So far, I have the following code figured out:

---------------

$s = array ("image.jpg", "image2.jpg"); // as many images as you want
$n = rand(1,len($s)); // randomly pick a number between 1 and the
length of the array
echo "<img src='". $s[$n] .'">"; // create an image tag for the randomly selected imagine (value of the randomly defined key)
array_pop($s, $n); // This piece isn't right, it needs to EXTRACT and delete the $n array element.

// Next random image
$n = rand(1,len($s));
echo "<img src='". $s[$n] .'">";

---------------
Any ideas what array_pop should be to work properly?

Thank you for the help!

I have searched around and found this code that suggests that I should be able to read an image file and echo it directly in to the page without hyperlinking to the file that is outside the public folder, but i get the error message that it is not there even though the file is.


Warning: getimagesize() [function.getimagesize]: Unable to access "/home/****/upload/AAABBBCCC.JPG" in /home/****/public_html/client.php on line 40


Code: [Select]
$image = "AAABBBCCC.JPG";
$path= "/home/****/upload/";
$details = getimagesize($path . $image);
header ('Content-Type: ' . $details['mime']);
echo  file_get_contents($path . $image);

Im using this code to call all the images in a folder:

Code: [Select]
$handle = opendir(dirname(realpath(__FILE__)).'/images/');
while($file = readdir($handle)){
if($file !== '.' && $file !== '..'){
echo '<img src="admin/img/uploads/'.$file.'" border="0" />';
}
}
My html says the images are present but they aren't visable on screen:

Code: [Select]
<div id="contentbody">
<img src="admin/img/uploads/send-button-sprite copy.png" border="0" />
<img src="admin/img/uploads/test" border="0" />
<img src="admin/img/uploads/counter.jpg" border="0" />
<img src="admin/img/uploads/send-button-sprite.png" border="0" />
</div>
Any help is much appreciated!

Hi    I echo out images from a folder. The problem is that I have a html file in the same folder but I don't want to echo that out. How can I write my code to get rid of the html in the output?   Here my code:

<?php 
$filetype = '*.html';
$dirname = substr('$filetype');
$i=0;
if (isset($_POST['submit2']))
{
  //get the dir from POST
  $selected_dir = $_POST['myDirs'];
  //now get the files from within the selected dir and echo them to the screen
  foreach(glob($selected_dir . DIRECTORY_SEPARATOR . '*') as $dirname)
  {
    echo substr($dirname, 0, -4);
    echo '<img src="'.$dirname.'" />';
    echo "<label><div class=\"radiobt\"><input type='radio' name='radio1' value='$i'/></div></label>";
  }
}
?>

P.S. when I echo out : substr($dirname, 0, -4); I want to get ride of the html filename there too. How can I do so something like this?

I have a PHP CRUD application and when i delete a row i need it to delete from the MySQL and the image from the uploads folder as well. I have researched and tried dozens of ways with the unlink option but nothing works. If i take out the unlink from my code it will delete fine from the DB. I am new to coding and PHP so any help would be awesome.

The file_path is correct. The uploads is the name of the folder where the image is stored and the $_POST["image"] is the column name in MySQL where the image name is stored.

delete.php

<?php

	//start PHP session
	session_start();

if (!isset($_SESSION['success']))
{
    header("Location: login_page.php");
    die();
}

// check if value was posted
if($_POST){
 
    // include database and object file
    include_once 'config/database.php';

    $file_path = 'uploads/' . $_POST["image"];
    if(unlink($file_path))
 {
	// delete query
	$query = "DELETE FROM myDBname WHERE id = ?";
	$stmt = $con->prepare($query);
	$stmt->bindParam(1, $_POST['object_id']);
 }
	if($stmt->execute()){
		// redirect to read records page and 
		// tell the user record was deleted
		echo "Record was deleted.";
	}else{
		echo "Unable to delete record.";
    }
}

?>

this is the delete button code

					echo "<a delete-id='{$id}' class='btn btn-danger delete-object'>";
					echo "<span class='glyphicon glyphicon-remove'></span> Delete";
					echo "</a>";

This is the javascript for the delete button as well.

	// delete record
	$(document).on('click', '.delete-object', function(){

		var id = $(this).attr('delete-id');

		bootbox.confirm({
		    message: "<h4>Are you sure?</h4>",
		    buttons: {
		        confirm: {
		            label: '<span class="glyphicon glyphicon-ok"></span> Yes',
		            className: 'btn-danger'
		        },
		        cancel: {
		            label: '<span class="glyphicon glyphicon-remove"></span> No',
		            className: 'btn-primary'
		        }
		    },
		    callback: function (result) {

		        if(result==true){
					$.post('delete.php', {
						object_id: id
					}, function(data){
						location.reload();
					}).fail(function() {
						alert('Unable to delete.');
					});
		    	}
			}
		});

		return false;
	});

 

If you need any other info that would help you help me just let me know and i will get that in here ASAP. Thanks again for any help on this.

Hi..

I've seen code for back up database but when I run the code the database was backup outside the folder. I want to put the back up database inside the folder

here is the code:
Code: [Select]
<?php
include 'config.php';
  backup_tables('localhost','root','','payroll');


/* backup the db OR just a table */
function backup_tables($host,$user,$pass,$name,$tables = '*')
{
    
    $link = mysql_connect($host,$user,$pass);
    mysql_select_db($name,$link);
    
    //get all of the tables
    if($tables == '*')
    {
        $tables = array();
        $result = mysql_query('SHOW TABLES');
        while($row = mysql_fetch_row($result))
        {
            $tables[] = $row[0];
        }
    }
    else
    {
        $tables = is_array($tables) ? $tables : explode(',',$tables);
    }
    
    //cycle through
    foreach($tables as $table)
    {
        $result = mysql_query('SELECT * FROM '.$table);
        $num_fields = mysql_num_fields($result);
        
        $return.= 'DROP TABLE '.$table.';';
        $row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table));
        $return.= "\n\n".$row2[1].";\n\n";
        
        for ($i = 0; $i < $num_fields; $i++) 
        {
            while($row = mysql_fetch_row($result))
            {
                $return.= 'INSERT INTO '.$table.' VALUES(';
                for($j=0; $j<$num_fields; $j++) 
                {
                    $row[$j] = addslashes($row[$j]);
                    $row[$j] = ereg_replace("\n","\\n",$row[$j]);
                    if (isset($row[$j])) { $return.= '"'.$row[$j].'"' ; } else { $return.= '""'; }
                    if ($j<($num_fields-1)) { $return.= ','; }
                }
                $return.= ");\n";
            }
        }
        $return.="\n\n\n";
    }
    
    //save file
    $myfoldername = "backup_DBPayroll";//your folders name 
    $handle = fopen(getcwd().$myfoldername.'db-backup-'.time().'-'.(md5(implode(',',$tables))).'.sql','w+');
    
   // $handle = fopen('db-backup-'.date('m-d-Y').'-'.(md5(implode(',',$tables))).'.sql','w+');
    fwrite($handle,$return);
    fclose($handle);
}


$smarty->display('header_cat.tpl');
$smarty->display('backup.tpl');
$smarty->display('footer.tpl');
?>

Thank you in advance