PHP - Comparing Files Against Database Fields

Hi all,
I'm brand new to php / mysql and I'm trying to modify this script which currently runs a search on two fields "product_number" and "product_name". I also want the search to consider a third field "product_type". When I remove either product_name or product number from the following part of the code, it removes that field from being considered in the search: Code: [Select]
$search_map = array($orderby, 'product_number','product_name',);
So shouldn't I be able to just add the third field's name to this array and have it be considered too? I'm a complete beginner so I'm hoping this is a simple fix and I just dont get it.

Here's the rest of what I think is the relevant code:
Code: [Select]
function load_all_products()
{
    global $AppUI;
    global $sorted_item_list;
    global $additional_pfilter;
    load_type_list();
    $orderby = 'product_id';
    $search_map = array($orderby, 'product_number','product_name',);
    $where = $AppUI->getState( 'QuoteIdxWhere' ) ? $AppUI->getState( 'QuoteIdxWhere' ) : '*';
    $not =" ";
    $op =  " OR";
    $check = substr(trim($where),0,4);
    if(stristr($check,"NOT")){
        $op ="AND";
        $not = " NOT ";
        $where = substr(trim($where),4);
        $where = trim($where);
    }

    // assemble the sql statement
    $q = new DBQuery;
    $q->addTable('products');
    $q->addJoin('companies', 'com', 'products.product_company_id = com.company_id');
    $q->addJoin('users', 'u', 'products.product_owner = u.user_id');
    $q->addQuery('products.*, com.company_name, u.user_username');
    $where_filter = " ";
    foreach($search_map as $search_name)
        $where_filter .=" $op $search_name $not REGEXP '$where'";
    $where_filter = substr($where_filter, 5);
 //   echo $where_filter;
    if($where != "*")
       $q->addWhere("($where_filter)");
    $q->addOrder('product_id');

    $sql = $q->prepare();
    $q->clear();
    $sql_list = db_exec( $sql );
    if ($sql_list)
  $rn = db_num_rows( $sql_list );
    else {
   echo db_error();
   $rn = 0;
    }

$product_list = array();
    foreach ($sql_list as $item)
{

$product_list[ $item[ 'product_id' ] ] = $item;

}

// sort the list

global $sort_state;
if ( !isset( $sort_state ) ) $sort_state = getProductSortState();

if ( isset( $sort_state[ 'sort_item1' ] ) )
{
if ( isset( $sort_state[ 'sort_item2' ] ) )
{
$sorted_item_list = array_csort2( $product_list, $sort_state['sort_item1'], intval( $sort_state['sort_order1'] )
, $sort_state[ 'sort_item2' ], intval( $sort_state['sort_order2'] ) );
}
else
{
$sorted_item_list = array_csort2( $product_list, $sort_state['sort_item1'], intval($sort_state['sort_order1']) );
}
}
else $sorted_item_list = array_csort2( $product_list, 'product_id' );

}
Thanks!

Hi friends,
a quick print_r() shows the following array while connecting to my database. How to get them as individual items and display on the website ?
Array
(
    [0] => Array
        (
            [id] => 52
            [document_name] => xyz
            [document_ext] => gif
            [download_file_name] => ktm_impact.gif
            [upload_dt] => 2010-08-11
        )

)

I have a relational table call sales with prodcut_id and custmer_id tables. I also have a product and customer tables. products table with product_id as an auto increment and customer with custumer_id I want to join through the sales tables all t he fields of row 1 from tables customer and products and pull it at once.


This is a member login script and I want to display the products by members.

So far I have this query to display the products once the member is login in. $userid is the id of the customer coming from the $userid= $_SESSION['customer_id'];


$mysqlSales="SELECT products.* FROM products JOIN sales ON (products.product_id = procuct_id ) WHERE sales.customer_id = '$userid'";


so far that statement is not working where should I have some type of incoherance with the english statement above expressing what I want the query to do.

hi every body. i want a loop that takes and shows more than one record from database. and then i want to show these to user by ajax.   indeed i made an html page that when user arrives at end it must do this.   first i made loop that took one record from database and it worked fine.   but for taking several records it went wrong.   this is my html file that has interact by user  webgoo-ajax.html   4.36KB   2 downloads   and this is my php file that interacts by database  ajax-get.php   1012bytes   3 downloads   when user arrives at end of page naturally ajax must be run and show several records to user.but it does'nt. first it stays idle for 3 minutes and then loads my first record extremely.   and a point: if these pages does'nt work on IE it will work on Firefox because it did'nt worked in IE for me too.   i just want a for loop that work correctly for my need.   thank you for everything                                       

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=352528.0

I can not get the values from the javascript add row to go dynamically as a row into MySql only the form values show up as the form below as one row. I made it as an array, but no such luck, I have tried this code around a multitude of ways. I don't know what I am doing wrong, kindly write out the correct way.      <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR...ransitional.dtd">
 <html xmlns="http://www.w3.org/1999/xhtml">
 <head>
 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
 <title>Dynamic Fields js/php to MySql need to submit dynamically to the database</title>
 <?php
 require ('database.php');
 ?>
  <script type="text/javascript">
  var counter     =     1;
  var collector     =     "";
 
  function addfields(indx)
  {
   var tbl = document.getElementById('table_id');
   var newtr = document.createElement('tr');
   counter = counter + indx;
 
   newtr.setAttribute('id','tr'+counter);
 
   newtr.innerHTML = '<td><input type="checkbox" name="checkb'+counter+'" id="checkb'+counter+'" value="'+counter+'" onclick="checkme('+counter+')"></td><td><input type="text" name="text1[]"></td><td><textarea name="textarea1[]"></textarea></td>';
 
   tbl.appendChild(newtr);
  }
 
  function checkme(dx)
 {
    collector += dx+",";
 }
 
  function deletetherow(indx)
  {
   var col = collector.split(",");
 
   for (var i = 0; i < col.length; i++)
   {
    var remvelem = document.getElementById('tr'+col[i]);
    var chckbx = document.getElementById("checkb"+col[i]);
    if(remvelem && chckbx.checked)
    {
     var tbl = document.getElementById('table_id');
    tbl.removeChild(remvelem);
   }
   }
  }
 </script>
 </head>
 <body>
 <form enctype="multipart/form-data" id="1" style="background-color:#ffffff;" action="<?php echo $_SERVER['PHP_SELF']; ?>"></form>
 <table id="table_id" >
   <tr id="tr1" class="trmain">
   <td>
   </td>
    <td>
    <input type="text" name="text1[]">
  </td>
    <td>
   <textarea name="textarea1[]"></textarea>
     </td> 
   </tr>
  </table>
 <input type="button" value="Add" onClick="addfields(1);" />&nbsp;
 <input type="button" value="Delete" onClick="deletetherow()" />
 <input type="submit" value="Send" id="submit"  name="submit"/>
 
 <?php
 if(isset($_POST['submit'])) {
 for ($i=0; $i < count($_POST['text1']); $i++ )
 {
 $ced = stripslashes($_POST['text1'][$i]);
 $erg = stripslashes($_POST['textarea1'][$i]);
 }
 
 
 $bnt = mysql_query("INSERT INTO tablename (first, second) VALUES ('$ced', '$erg')")or die('Error: '. mysql_error() );
 $result = mysql_query($bnt);
 }
 
 ?>
 
 </body>
 </html>

I'm using PHP and MySQL. I have an application where I'd like to keep certain database (character) fields encrypted when added to the database and stored, but when I need to display them at the appropriate time, I can call a function and quickly decrypt them for display.

Does anyone know of a simple way to do this?

Thanks!

This is my first post so please correct me if somethings wrong

Basically im creating a shopping cart with the help of a guide but there is no database written in the guide so i'm not sure how to proceed. My database wont work...
Guide:
https://jameshamilto...g-cart-tutorial

Error message
http://gyazo.com/a20...b096b7727410dfd

Index:

  <?php session_start(); ?>
   <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
   <html xmlns="http://www.w3.org/1999/xhtml">
   <head>
   <meta name="description" content="PHP Shopping Cart Using Sessions" /> 
   <meta name="keywords" content="shopping cart tutorial, shopping cart, php, sessions" />
   <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
   <link rel="stylesheet" media="all" href="/style/style.css" type="text/css" />
   <title>Cart</title>
  
  
  <?php
  	//connect to your database here
  	
  
  $sql = 'SELECT * FROM books ORDER BY id';
  $output[] = '<ul>';
  $output[] = '<li>"'.$row['title'].'" by '.$row['author'].': &pound;'.$row['price'].'<br /><a href="cart.php?action=add&id='.$row['id'].'">Add to cart</a></li>';
  
  
  //connect mysql
  
  mysql_connect($server, $user, $pass) or die ("Sorry, can't conect to mysql.");
  
  //select db
  
  mysql_select_db($db) or die ("Sorry cant select the db.");
  
  
  ?>
  
  
  
  </head>
  <body>
  
  
  <?php
  
  	$product_id = $_GET[id];	 //the product id from the URL 
  	$action 	= $_GET[action]; //the action from the URL 
  
  	//if there is an product_id and that product_id doesn't exist display an error message
  	if($product_id && !productExists($product_id)) {
  		die("Error. Product Doesn't Exist");
  	}
  
  	switch($action) {	//decide what to do	
  	
  		case "add":
  			$_SESSION['cart'][$product_id]++; //add one to the quantity of the product with id $product_id 
  		break;
  		
  		case "remove":
  			$_SESSION['cart'][$product_id]--; //remove one from the quantity of the product with id $product_id 
  			if($_SESSION['cart'][$product_id] == 0) unset($_SESSION['cart'][$product_id]); //if the quantity is zero, remove it completely (using the 'unset' function) - otherwise is will show zero, then -1, -2 etc when the user keeps removing items. 
  		break;
  		
  		case "empty":
  			unset($_SESSION['cart']); //unset the whole cart, i.e. empty the cart. 
  		break;
  	
  	}
  	
  ?>
  
  
  <?php	
  
  	if($_SESSION['cart']) {	//if the cart isn't empty
  		//show the cart
  		
  		echo "<table border=\"1\" padding=\"3\" width=\"40%\">";	//format the cart using a HTML table
  		
  			//iterate through the cart, the $product_id is the key and $quantity is the value
  			foreach($_SESSION['cart'] as $product_id => $quantity) {	
  				
  				//get the name, description and price from the database - this will depend on your database implementation.
  				//use sprintf to make sure that $product_id is inserted into the query as a number - to prevent SQL injection
  				$sql = sprintf("SELECT name, description, price FROM php_shop_products WHERE id = %d;",
  								$product_id); 
  					
  				$result = mysql_query($sql);
  					
  				//Only display the row if there is a product (though there should always be as we have already checked)
  				if(mysql_num_rows($result) > 0) {
  				
  					list($name, $description, $price) = mysql_fetch_row($result);
  				
  					$line_cost = $price * $quantity;		//work out the line cost
  					$total = $total + $line_cost;			//add to the total cost
  				
  					echo "<tr>";
  						//show this information in table cells
  						echo "<td align=\"center\">$name</td>";
  						//along with a 'remove' link next to the quantity - which links to this page, but with an action of remove, and the id of the current product
  						echo "<td align=\"center\">$quantity <a href=\"$_SERVER[PHP_SELF]?action=remove&id=$product_id\">X</a></td>";
  						echo "<td align=\"center\">$line_cost</td>";
  					
 					echo "</tr>";
 					
 				}
 			
 			}
 			
 			//show the total
 			echo "<tr>";
 				echo "<td colspan=\"2\" align=\"right\">Total</td>";
 				echo "<td align=\"right\">$total</td>";
 			echo "</tr>";
 			
 			//show the empty cart link - which links to this page, but with an action of empty. A simple bit of javascript in the onlick event of the link asks the user for confirmation
 			echo "<tr>";
 				echo "<td colspan=\"3\" align=\"right\"><a href=\"$_SERVER[PHP_SELF]?action=empty\" onclick=\"return confirm('Are you sure?');\">Empty Cart</a></td>";
 			echo "</tr>";		
 		echo "</table>";
 		
 		
 	
 	}else{
 		//otherwise tell the user they have no items in their cart
 		echo "You have no items in your shopping cart.";
 		
 	}
 	
 	//function to check if a product exists
 	function productExists($product_id) {
 			//use sprintf to make sure that $product_id is inserted into the query as a number - to prevent SQL injection
 			$sql = sprintf("SELECT * FROM php_shop_products WHERE id = %d;",
 							$product_id); 
 				
 			return mysql_num_rows(mysql_query($sql)) > 0;
 	}
 ?>
 
 <a href="products.php">Continue Shopping</a>
 
 
 <?php
 
 /*
 
 products table:
 	CREATE TABLE `products` (
 		`id` INT NOT NULL AUTO_INCREMENT ,
 		`name` VARCHAR( 255 ) NOT NULL ,
 		`description` TEXT,
 		`price` DOUBLE DEFAULT '0.00' NOT NULL ,
 		PRIMARY KEY ( `id` )
 	);
 
 */
 
 ?>
 
 
 
 </body>
 </html>

products.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  <html xmlns="http://www.w3.org/1999/xhtml">
  <head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <meta name="description" content="PHP Shopping Cart Using Sessions" /> 
  <meta name="keywords" content="shopping cart tutorial, shopping cart, php, sessions" />
  <link rel="stylesheet" media="all" href="/style/style.css" type="text/css" />
  <title>Products</title>
  
 <?php
 	//connect to your database here
 		//connect to your database here
 	
 
 $sql = 'SELECT * FROM books ORDER BY id';
 $output[] = '<ul>';
 $output[] = '<li>"'.$row['title'].'" by '.$row['author'].': &pound;'.$row['price'].'<br /><a href="cart.php?action=add&id='.$row['id'].'">Add to cart</a></li>';
 
 
 //connect mysql
 
 mysql_connect($server, $user, $pass) or die ("Sorry, can't conect to mysql.");
 
 //select db
 
 mysql_select_db($db) or die ("Sorry cant select the db.");
 ?>
 
 </head>
 
 <body>
 
 
 <table border="1">
 
 	<?php
 		
 		$sql = "SELECT id, name, description, price FROM php_shop_products;";
 		
 		$result = mysql_query($sql);
 		
 		while(list($id, $name, $description, $price) = mysql_fetch_row($result)) {
 		
 			echo "<tr>";
 			
 				echo "<td>$name</td>";
 				echo "<td>$description</td>";
 				echo "<td>$price</td>";
 				echo "<td><a href=\"cart.php?action=add&id=$id\">Add To Cart</a></td>";
 			
 			echo "</tr>";
 		}
 		
 	?>
 </table>
 
 
 <a href="cart.php">View Cart</a>
 
 </body>
 </html>

Is it better to store uploaded images as 'content' in the database? (like he http://www.techsupportforum.com/forums/f49/tutorial-upload-files-to-database-176804.html).. Or just as a regular file which is referenced in the database..?

i am trying to delete files for a user, and then update the database with the new bandwhitch/free space.  here is my code:

http://pastebin.com/J2XE9Fip

i just can't figure out where i'm going wrong... 

thanks in advance

I have a Joomla website having one folder for audio files in it and their links are saved in database.

Now I want to show two calendars to the user at front end, so that they can choose that from when to from he want to download the audio files?

for e.g he can select june-2-2014 in one calendar and august-2-2014 in second calendar, now on clicking download button the files residing between the two specific dates must get archived into one zip file and then start downloading...
  i have a reference link for creating a zip and downloading the zip :http://coursesweb.ne...-archive-php_cs   now i am stuck that how to get the selection of user from calendar , save it into the array , and from the array get the files from the folder matching the array indexes and then zip , download them.   please tell me how to achieve this task ?

Maybe some of the great coders here can help this noob out.
So here is what I have so far:

Code: [Select]
//set age criteria for deletion
$age = 60;

//get current date
$datenow  = date("Y-m-d");

//set the range we want to delete
$delete_range = $datenow - $age;

//get old user_id from users table
$oldusers_users = mysql_query ("SELECT user_id FROM users WHERE lastvisit < $delete_range ");

//get user_id from images table that correspond to users table
$oldusers_images = mysql_query ("SELECT user_id FROM images WHERE $oldusers_users=user_id.images ");

//find folders that correspond to the usernames and delete
$oldusers_files = mysql_query ("SELECT username FROM users WHERE lastvisit < $delete_range ");
//print out username
//$result = mysql_($oldusers_files);
$foldername = mysql_result($oldusers_files, 0);

$sigspath = "sigs/";
unlink($sigspath . $foldername . ".gif/index.php");
rmdir($sigspath . $foldername . ".gif");
//now delete user_id's from database
mysql_query("DELETE * FROM users WHERE user_id=$oldusers_users");
mysql_query("DELETE * FROM images WHERE user_id=$oldusers_images");
unset($oldusers_users, $oldusers_images, $oldusers_files, $foldername, $sigspath );
mysql_close($link);
Right now it is only returning the first entry, not the entire list that meets the criteria.  It does delete that one file though but does not remover the rows from the database.

I am sure the database stuff is jacked up I am really new to that part.  What am I doing wrong here or is there a better way to do this perhaps

I am currently creating a form and I want to populate a drop down selection menu with data from two fields in a form. For example, I want it to pull the first and last name fields from a database to populate names in a drop down menu in a form. I want the form to submit to the email address of the person selected in the drop down. Is this possible to do? The email is already a field in the record of the person in the database.

Can anyone give me some pointers or advice on how I should go about setting up the "Select" box drop down? I am not sure how to code it to do what I am wanting. Any links to relevant help would be appreciated too.

Thanks in advance!

Hey guys,   Thank you in advance... here is my situation, I have a form with three (3) fields in it, the 'student name' is unlimited textfield with an "add more" button to it and I have two select fields ('number of shirts' and 'trophies') that depend on the number of entries for 'student name'...   I want to create the select fields based on this math, for as many 'student name' entries:   1- i want to have the select form for 'number of shirts' to be 0 up to that number... so if there are 6 'student name' entries, the select options will be 0,1,3,4,5,6,7 2- I want to have the select form for 'trophies' to be 5 'student name' entries to 1 'trophies', for example if there are 6 'student name' entries, the select options will be 0,1... if there are 13 entries, options will be 0,1,2... So if there are less than 5 'student name' entries, the select field will not show (hidden)   of course if there are no 'student name' entries, these two fields won't show up (hidden)   let me know if that make sense and ANY help or directions will be GREATLY APPRECIATED.   Thanks guys!  

Hi,
The main idea is that I have a client running on certain desktops.

Each 5th minute the client sends and update to the web-server, increasing "tick" by one.
Tick start out as 0, so after 5 minutes ticket should be greater than 5.
If tick is not greater than 0 then do <code omitted>

I Guess I would need some kind of cronjob to complete this, but i'd love to avoid sessions & cookies at all costs, as the same server is checking the same tick but for different accounts..

Any suggestions are highly appreciated ^.^