Jump to content

mallen

Members
 View Profile  See their activity

  • Posts

    316

  • Joined

  • Last visited

 Content Type 

Posts posted by mallen

    Customizing a ecommerce query

    in PHP Coding Help

    Posted

    I am getting closer.

    
<?php echo $Product->ivalue;?>

    I get this value and all I need is the value of s27 How can I do that:

    O:8:"stdClass":10:{s:4:"mime";s:10:"image/jpeg";s:4:"size";s:5:"14737";s:7:"storage";s:9:"FSStorage";s:3:"uri";s:27:"cache_276_260__100_A130.jpg";s:8:"filename";s:27:"cache_276_260_100_A130.jpg";s:5:"width";s:3:"258";s:6:"height";s:3:"260";s:3:"alt";s:0:"";s:5:"title";s:0:"";s:8:"settings";a:6:{s:5:"width";i:276;s:6:"height";i:260;s:5:"scale";i:0;s:7:"sharpen";i:100;s:7:"quality";b:0;s:4:"fill";b:0;}

    Customizing a ecommerce query

    in PHP Coding Help

    Posted · Edited by mallen

    When I run this

    <?php echo var_dump($Product); ?>

    I get the following. Not sure how it includes the categories in the array. I was trying to copy that to get it to include the image.

    object(stdClass)#561 (12) { ["id"]=> string(2) "51" ["name"]=> string(22) "Nice Shiny Car" ["slug"]=> string(22) "Nice-Shiny-Car" ["featured"]=> string(3) "off" ["variations"]=> string(3) "off" ["categories"]=> string(6) "Luxury" ["mainprice"]=> string( "1.000000" ["maxprice"]=> string( "1.000000" ["minprice"]=> string( "1.000000" ["inventory"]=> string(2) "on" ["stock"]=> string(3) "900" ["catids"]=> string(2) "23" }

    Customizing a ecommerce query

    in PHP Coding Help

    Posted

    I am using this ecommerce theme with Wordpress and now the company is no longer I can't get support. There is a admin page that displays Name, Category, Price, Inventory and ID. I am trying to diplay the product image. If I make any changes to the query I get no reults. If I use Meta::$table I get an error that that Meta does not exits. Is there anywhere else I could check? Maybe the $wpd->wp_mycart_meta line is correct but the query is not. The query pulls data from mycart_price and mycart_catalog but I don't know how it finds those tables. I need to search the mycart_meta

    $pd = DatabaseObject::tablename(Product::$table);
$pt = DatabaseObject::tablename(Price::$table);
$catt = DatabaseObject::tablename(Category::$table);
$clog = DatabaseObject::tablename(Catalog::$table);
$imgg = DatabaseObject::tablename(Meta::$table); // this I added
 $imgg = $wpd->wp_mycart_meta // I alo tried this







$query = "SELECT $columns $matchcol FROM $pt AS pt LEFT JOIN $pd AS pd ON pd.id=pt.product LEFT JOIN $clog AS clog ON pd.id=clog.product LEFT JOIN $catt AS cat ON cat.id=clog.parent AND clog.type='category' WHERE $where GROUP BY pt.id $having ORDER BY pd.id,pt.sortorder LIMIT $start,$per_page";


$Products = $db->query($query,AS_ARRAY);
$productcount = $db->query("SELECT FOUND_ROWS() as total");

} else {
$columns = "SQL_CALC_FOUND_ROWS pd.id,pd.name,pd.slug,pd.featured,pd.variations,GROUP_CONCAT(DISTINCT cat.name ORDER BY cat.name SEPARATOR ', ') AS categories,
IF(pt.options=0,IF(pt.tax='off',pt.price,pt.price+(pt.price*$taxrate)),-1) AS mainprice,
IF(MAX(pt.tax)='off',MAX(pt.price),MAX(pt.price+(pt.price*$taxrate))) AS maxprice,
IF(MAX(pt.tax)='off',MIN(pt.price),MIN(pt.price+(pt.price*$taxrate))) AS minprice,
IF(pt.inventory='on','on','off') AS inventory,
ROUND(SUM(pt.stock)/IF(clog.id IS NULL,1,count(DISTINCT clog.id)),0) AS stock";
if ($workflow) $columns = "pd.id";


$query = "SELECT $columns $matchcol FROM $pd AS pd LEFT JOIN $pt AS pt ON pd.id=pt.product AND pt.type != 'N/A' AND pt.context != 'addon' LEFT JOIN $clog AS clog ON pd.id=clog.product LEFT JOIN $catt AS cat ON cat.id=clog.parent AND clog.type='category' WHERE $where GROUP BY pd.id $having ORDER BY pd.name LIMIT $start,$per_page";

    Sharing A Variable Between Functions

    in PHP Coding Help

    Posted

    How can I do a preg_match() to look for images only with "LARGE" in the file name?

    $prod = isset($_GET['prod']) ? trim($_GET['prod']) : '';
if($prod != ''){
 $LARGE = 'LARGE';
  preg_match("/$LARGE/", $image);
    $images = glob("$root/$cat/$prod/*.{.jpg,JPG}", GLOB_BRACE);
    if(empty($images)){
		    echo "No large images found.";
    } else {
		    foreach($images as $image){

			    //echo basename($image) . '<br/>';
 echo 'Large image is'. '<img src="'. $root . '/'. basename($cat) . '/' .basename($prod).'/' .basename($image). '"  /><br/>';
		  }
    }
 //var_dump($image);
}

    Sharing A Variable Between Functions

    in PHP Coding Help

    Posted

    Thanks that worked and it was easy to follow. I was able to modify it so it would spread out over individual pages. Now I am try to adapt this to display the images for each product. This is what I have tried but getting NULL for value of images.

    // if a product is selected, list the images
$prod = isset($_GET['prod']) ? trim($_GET['prod']) : '';
if($prod != ''){

    $images = glob("$root/$cat/$prod/*.jpg",GLOB_ONLYDIR);
    if(empty($images)){
		    echo "No images found.";
    } else {
		    foreach($images as $image){
 $image = basename($image);
			    echo basename($image) . '<br/>';

		    }
    }
 var_dump($image);
}

    Sharing A Variable Between Functions

    in PHP Coding Help

    Posted · Edited by mallen

    After I get the proper list of folders to display I will work on the display details such as the PDF files and images.

    On the index page it lists all the categories as links.

    Category 1

    Category 2

    Category 3

     

    Then if you click on one it takes you to products_list.php:

    It lists:

    Product 1

    Product 2

     

    This is the way I want it but its hard coded for category1. I need it to know what category I clicked. This is where I was trying to assigned $curf (current folder)

    Sharing A Variable Between Functions

    in PHP Coding Help

    Posted · Edited by mallen

    This is what Ihave so far. I am listing folders and files. Yes I know a database is a better way. My folder structure is products/category1/product1/product2/category2/product1/product2 and so on...

    On the first page it lists the categories.

    Then click on them and takes you to a second page to list all products for that category. But all I can do is hard code it for a category. I can't get it to assign a value to $curf

    //list of functions
global $fld;
function get_folders ($fld) { //display the main cat folders
if ($handle = opendir($fld)) { //open products
$blacklist = array('.','..','products', 'index.php');
while (false !== ($file = readdir($handle))) {
 if (!in_array($file, $blacklist)) {
echo '<a href=/products_list.php?folder=' . $file . '&'. 'pdf=' . '/>'. strtoupper($file) . '</a>'. '<br/>';

 }
}

closedir($handle);

}
}

function get_cur_sub () {
global $curf;
if (!empty ($_GET['folder'])) {

$curf = $_GET['folder'];

} else {
 $curf = 'somevalue';

}
}

function get_sub_folders ($curf) {

if ($handle2 = opendir('products/category1' . $curf)) { //need to change hard coded category1 to a variable
$blacklist2 = array('.','..','products','index.php');
while (false !== ($sub = readdir($handle2))) {
 if (!in_array($sub, $blacklist2)) {
echo '<a href=/detail_page.php?folder=' . $sub . '&'. 'pdf=' . '/>'. basename(strtoupper($sub)) . '</a>'. '<br/>';
var_dump($sub);
 }
}

closedir($handle2);

}
}
//pages:
On home page:
get_folders ('products'); //get category folder

On the products_list.php page:
echo get_sub_folders($curf);

On the detail_page.php:
get_sub_folders ($curf);

    Sharing A Variable Between Functions

    in PHP Coding Help

    Posted · Edited by mallen

    Is there a way I can use a variable from a function and use it in aother function?

     

    function get_folders () {
if ($handle = opendir('products')) {
$blacklist = array('.','..','products', 'index.php');
while (false !== ($file = readdir($handle))) {
 if (!in_array($file, $blacklist)) {
echo '<a href=/products_list.php?folder=' . $file . '&'. 'pdf=' . '/>'. strtoupper($file) . '</a>'. '<br/>';

 }
}
closedir($handle);
}
}
function get_products() {
//if ($handle = opendir('products/category1/product1')) { <<Remove this
if ($handle = opendir($file)) {  <<try this
$blacklist = array('.','..','index.php');
while (false !== ($product = readdir($handle))) {
 if (!in_array($product, $blacklist)) {
echo '<a href=/products_list2.php?folder=' . $product . '&'. 'pdf=' . '/>'. strtoupper($product) . '</a>'. '<br/>';

 }
}
closedir($handle);
}
}

    Display List Of Folders And Link To Individual Pages

    in PHP Coding Help

    Posted

    Ok got it to work. :happy-04: (somewhat) I left off that slash/ on line 6. It now displays the image according to the link I click. Now I need to work on passing the variable for the pdf file. Because all it checks is value of 'folder'

    function list_directories () {
if (!empty ($_GET['folder'])) {
    $dir = 'products/' . $_GET['folder'];

} else {
    $dir = 'somevalue';

}
$images = glob($dir . "/*.jpg");

foreach($images as $image)
{
echo basename($image);
}
}

    Display List Of Folders And Link To Individual Pages

    in PHP Coding Help

    Posted · Edited by mallen

    I tried this function and it outputs it if I do a var_dump($dir) but can't get it to echo the values.

    function list_directories () {
if (!empty ($_GET['folder'])) {
 $dir = 'products/' . $_GET['folder'];

} else {
 $dir = 'somevalue';

}
$images= glob($dir . "*.jpg");

foreach($images as $image)
{
echo $image;
}
var_dump($dir);
}

    Display List Of Folders And Link To Individual Pages

    in PHP Coding Help

    Posted · Edited by mallen

    Can anyone else help? I have been struggling with this for 3 days. The more I look at it not sure (how is currently written) how it knows I want only pdf files to be listed in the second function.

     

    My folder struccture is products/category1/product1/product2....category2/product1/product2 and so on. I already can get it to list the category folders as links.

    Display List Of Folders And Link To Individual Pages

    in PHP Coding Help

    Posted · Edited by mallen

    Here are my functions. See I am trying to switch out the$cat variable and also the 'folder' I used the var_dump() and it is showing a value.

    function get_folders () { //list category folders as list of links
if ($handle = opendir('products')) {
$blacklist = array('.','..','products', 'index.php');
while (false !== ($file = readdir($handle))) {
 if (!in_array($file, $blacklist)) {
echo '<a href=/products_list.php?folder=' . $file .'>'. strtoupper($file) . '</a>'. '<br/>';

 }
}
closedir($handle);
}
}

function display_files_jpg () { //display list of jpg images
$cat = $_GET["folder"];
foreach(glob('products/*/$cat/*.jpg') as $image)
{
 echo basename($image) . "<br />";
}
var_dump($cat);
}

function display_files_pdf () { //display list of pdf files
$_GET['folder'] = 'some_value';
$dirs = $_GET["folder"];
foreach(glob($dirs, GLOB_ONLYDIR) as $pdf)

{
 echo basename($pdf) . "<br />";
}
var_dump($dirs);
}

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.