oracle765

February 25, 2014

?

February 25, 2014

excellent that worked thanks a alot

February 24, 2014

Hi professionals

I am stuck with some css as I don't really know anything about it, basically on our loans page compareandchoose.com.au/loans the writing and text boxes are all over the place and I cannot figure out what to do.

I have found that in the style.css file that it is something to do with the dollor class but I have tried a few thing and it keeps messing up.

I will attached an image too for clarity sake

style.css

loans.php

February 23, 2014

ok mongosselin there are actually two pages they are compareandchoose.com.au/shopping and compareandchoose.com.au/insurance that I am having problems with

thanks in advance

February 22, 2014

Hi Css expert

My website has been written by someone else and I am stuck with some css issues. As I do not know css at all hence why I am asking here, I do not know even which of the css files to show as to where the problem could be so I will send the page code with the css files that are in my website along with the attached image and hopefully I can be pointed in the right direction.

What I am looking for in the submenu is for the submenu options to be in an ordered list EG left to right top to bottom but they seem to be all over the submenu, can anyone assist

Please find attached the code for that page in question

thanks

good.php

February 22, 2014

Hi again

Still baffled with this array

how do I actually drill down to the min price and number of stores in the array so I can show in format like this

item, description, number of stores, prices from, CompareButton(which goes to the stores)

thanks in advance

February 21, 2014

ah ok I see, no worries thanks

February 21, 2014

 [2] => Array
                                                (
                                                    [name] => Store
                                                    [attributeURL] => http://www.au.shopping.com/washing-machines/washing-machine/products~all-store~MS-1?oq=washing_machine&linkin_id=8084586
                                                    [attributeValues] => Array
                                                        (
                                                            [attributeValue] => Array
                                                                (
                                                                    [0] => Array
                                                                        (
                                                                            [name] => Appliances Online
                                                                            [attributeValueURL] => http://www.au.shopping.com/washing-machines/washing-machine+store-appliances-online-4114784/products~linkin_id-8084586
                                                                            [id] => store_appliances_online_4114784
                                                                            [matchingItemsCount] => 76
                                                                        )

                                                                    [1] => Array
                                                                        (
                                                                            [name] => Masters Home Improvement
                                                                            [attributeValueURL] => http://www.au.shopping.com/washing-machines/washing-machine+store-masters-home-improvement-9689/products~linkin_id-8084586
                                                                            [id] => store_masters_home_improvement_9689
                                                                            [matchingItemsCount] => 19
                                                                        )

                                                                    [2] => Array
                                                                        (
                                                                            [name] => The Good Guys
                                                                            [attributeValueURL] => http://www.au.shopping.com/washing-machines/washing-machine+store-the-good-guys/products~linkin_id-8084586
                                                                            [id] => store_the_good_guys
                                                                            [matchingItemsCount] => 3
                                                                        )

                                                                    [3] => Array
                                                                        (
                                                                            [name] => Mr Appliance
                                                                            [attributeValueURL] => http://www.au.shopping.com/washing-machines/washing-machine+store-mr-appliance-9689/products~linkin_id-8084586
                                                                            [id] => store_mr_appliance_9689
                                                                            [matchingItemsCount] => 3
                                                                        )

                                                                )

                                                            [matchedValueCount] => 4
                                                            [returnedValueCount] => 4

Hi Ch0cu3r

I aint touch any of the code since you last mailed me but I have noticed that in the array its trying to out put the store name but I only seem to get on store even though there are 4 stores in there as shown

Any ideas why its only showing appliances online and not the rest?

again for clarity sake I have attached the page code, but to be fair I have never changed anything

Thanks

Alan

shopping.php

February 19, 2014

That seems to have done it and extracted the images, thanks again, although I have no idea what is happening lol these multidimensional arrays are frying my brain

I just have to figure out how to get the minimum price in the array and why some of the Buy froms and Manufacturers are blank after all I am aiming along the lines of 3 products found, prices from $$$ then click compare which shows the different stores prices if you know what I mean

February 19, 2014

oh and I replaced the whole of the foreach loop with that code is that correct

February 19, 2014

Hi there thanks for that, it does not show any image at all now, I gather you were pointing to the [1] within that array? also do you know which array set the min price is in for that store

February 18, 2014

hey thanks seems to be getting somewhere it just seems to be showing a load of images though for some reason you can see the on compareandchoose.com.au/shopping.php

I have attached the full page code for clairity sake

once again I personally thank you

shopping.php

February 18, 2014

//THIS ONE WORKS OK

foreach($json_arr ['categories']['category'] as $arr){

    // $arr will be an array of each url data
	echo "<b> Link </b><a href=" .$arr['categoryURL'].">Apple</a>"?><br /><br /><?php 

}

foreach($json_arr ['categories'] as $categories) 
{		
    foreach($categories ['category'] as $category) 
    {
        echo "<b> Link </b>" .$category['categoryURL'] ,"<br/>";
		/*
        foreach($category['item'] as $item)
        {
             // get the sub array key
             $key = key($item);

             echo "<p><b> Name </b> " .implode(',', $item[$key]['name']), " <br> manufacturer </b>",$item[$key]['manufacturer'] ,"<p>";

             // get item description, 
             // for offer use description key
             // for product use fullDescription key
             echo "<p><b>Description</b> " . (($key == 'offer') ? $item[$key]['description'] : $item[$key]['fullDescription']) . "</p>";

            // display product images 
			
            echo "<p><b>Images: </b>";
            foreach($item[$key]['imageList']['image'] as $image)
            {
                echo "<img src='" .$image['sourceUrl']. "' />   ";
            }
            echo "</p>";
			
            // the store logo and name
            echo "<p><b>Store: </b> <img src='" .$item[key]['store']['logo']['sourceURL']. "' /> " .$item[key]['store']['name']. "</p>";
            echo "<hr />";
       } */
   }
}

Hi ive commented out the inner foreach loops to try and figure out whats going on but it seems not to work still

im a bit confused as the second attachment loop works

February 17, 2014

foreach ($json_arr['categories'] as $categories) 
{		
    foreach($categories['category'] as $category) 
    {
        echo "<b> Link </b>" .$category['categoryURL'] ,"<br/>";
		 
        foreach($category['item'] as $item)
        {
             // get the sub array key
             $key = key($item);

             echo "<p><b> Name </b> " .implode(',', $item[$key]['name']), " <br> manufacturer </b>",$item[$key]['manufacturer'] ,"<p>";

             // get item description, 
             // for offer use description key
             // for product use fullDescription key
             echo "<p><b>Description</b> " . (($key == 'offer') ? $item[$key]['description'] : $item[$key]['fullDescription']) . '</p>';

            // display product images
            echo '<p><b>Images: </b>';
            foreach($item[$key]['imageList']['image'] as $image)
            {
                echo '<img src="'.$image['SourceUrl'].'" />   ';
            }
            echo '</p>';

            // the store logo and name
           // echo '<p><b>Store: </b> <img src="' $item[key]['store']['logo']['sourceURL']'" /> ' .$item[key]['store']['name'] '</p>';
            echo '<hr />';
       }
   }
}

Hi again

ive tried this today but nothing seems to be coming back again

my dreamweaver was showing an error on the second last line of echo code that I commented out because I could not figure it out and I did notice a semi colon missing from an echo statement above which I fixed but its still showing nothing

here is what I have so far, I think it might be just a formatting error with the " ' etc but not sure

February 17, 2014

print_r($json_arr);

		foreach ($json_arr ['categories'] as $categories) 
		{		
			foreach($categories['category'] as $category) 
			{
				echo "<b> Link </b>" .$category['categoryURL'] ,"<br/>";
				 
				foreach($category['item'] as $Option) 
				{
              	echo "<b> Name </b> " .implode(',', $Option['name']), " <br> manufacturer </b>",$Option['manufacturer'] ,"<br />";
				}
        	}
		}

PS ive tried this but its returning nothing

February 17, 2014

Hey Ch0cu3r hope your keeping ok

Im really stuck again with these arrays lol how do I drill down in this array,this might be simple to you but its very complex for me

I have attached the data its extracted so far

what I am looking to pull out is the

description, manufacturer, the store name who sells it EG appliances online, image of the item and logo of the store etc, your intelligent enough so you will know what I mean.

thanks in advance

alan

February 15, 2014

hey david thanks for this you are a legend

I have limited knowledge of MySQL, how do you create an index on the brand and model_number when brand has multiple brands under iphone do they not have to be unique or am I misunderstanding indexes

February 14, 2014

Hi David

I am not so sure as someone else has been writing this for me but they can seem to get it right, if you type in iphone we get an iphone 3g 8GB but it does not take care of the space you mentioned. But sometimes when you type in C7 for a Nokia C7 it returns things like 02 which is baffling. I think they are only searching on model_number. its a bit complex for me.......

What I have done for clarity sake is included the two php files its using. you can see what I mean on compareandchoose.com.au

recyclers.php

product_detail.php

February 14, 2014


Insurer, age min, age max, duration min, duration max, duration unit, single r1,duo r1,family r1,single r2,duo r2,family r2


insurer1, 0,59, 1,5,days,$16.24,$32.48,$50.00,$17.60,$35.20,$57.00
insurer2, 0,49, 1,2,months,$206.24,$302.48,$500.00,$170.60,$350.20,$570.00
insurer1, 60,79, 22,29,days,$160.24,$320.48,$500.00,$170.60,$350.20,$563.00
insurer2, 50,65, 1,5,days,$16.24,$32.48,$50.00,$17.60,$35.20,$57.00


so something like

select * from the database where the text boxes that the user has filled in match this criteria

EG (worldiwide)WW=R1,(Pacific)PC=R2

Single= single price
Duo= duo price x 2 people
Family, not sure if it is used

days between for some insurers as they only use days
but some insurers use days and months for instance between 2 and 3 months calculate the month field 05 for may 03 for march 05 - 03 = 2 months

SO as you can see this can get quite complicated and I am only new to sql and php


If anyone has experience or feels they can do this then let me know


admin@compareandchoose.com.au

Hi we are a comparison site and we are trying to calculate a formula to present to our users various prices for travel insurance, at that stage they will be able to click through to their chosen insurer.

I have managed to code a bit of it but to be honest I am just lost.

The format of some of the spreadsheets are something like the attached

thanks

you can see an example on compareandchoose.com.au

February 13, 2014

product_name model_number  image_url  brand  price  
 


Apple  iphone 3G 8GB iphone 3G 8GB http://fonehub.co.uk/Pictures/Product/1/Large/Imag... 

Apple 12.0 


Apple iPhone 3G 8GB iPhone 3G 8GB http://moneyforyourphone.com/productimage/mobile-p... 

Apple 14.0

Hi David

Data as requested

February 13, 2014

<?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 http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>compare</title>
<link href="css/style.css" rel="stylesheet" type="text/css" />
<link href="css/hotelsGadget2013.css" rel="stylesheet" type="text/css" />
<link href="css/product.css" rel="stylesheet" type="text/css" />
</head>
<body>
<section>

<div class="ac_results" style="width: 680px !important;">

<ul style="max-height: 405px; overflow: auto;">

<?php
include('config.php');
if($_POST)
{

$q=$_POST['searchword'];

/***************************************************************************************************************/
/* image url = link to image...brand=Apple,model_number = iphone 3g 8gb but could be Iphone%%3gb 8GB, price=only show the highest price in ajax dropdown
/* is this query correct as i know there are definately two rows in the database with values of
/* http://fonebank.com/blablabla.jpg, Apple, Iphone%3G%8gb, $14.00
/* http://mfyp.com/blablabla.jpg, Apple, iphone%%3G%8GB, $12.00
/***************************************************************************************************************/

$sql_res=mysql_query("select distinct image_url,brand,model_number,max(price) 
from fonehub 
where concat (brand, ' ',model_number) = upper(rtrim(ltrim('$q'))) 
order by concat(brand,' ',model_number)"); 


while($row=mysql_fetch_array($sql_res))
{
$info=$row['model_number'];
$price=$row['price'];
$img=$row['image_url'];


$re_info='<b>'.$q.'</b>';


$final_info = str_ireplace($q, $re_info, $info);

?>


<li class="ac_even">
<div class="hoverd">
<span class="ref" style="display: none;">http://www.sellmymobile.com/phone/apple-iphone-5s-32gb/</span><a href="product_detail.php?product_name=<?php echo $info;?>" rel="nofollow"><img src="<?php echo $price;?>" height="50" width="53" class="phone"></a><div class="details"><h5>
<a href="product_detail.php?product_name=
<?php //$_SESSION['as']= $row['uid'];
echo $info;?>" rel="nofollow">
<?php echo $final_info; ?></a></h5></div><h5 class="price"><a href="" rel="nofollow"><span style="color: black;">Get up to</span> <?php echo "$" .$price; ?>0</a></h5></div></li>

<?php
}

}
else
{

}

?>
</ul></div>
</section>	
</body>
</html>

Hi All

I am trying to get a list of values from the database that are obviously unique when the user searches for a mobile phone. I have two companies in there so I know that when a user types for instance for an Apple iphone the query should find this.

The database was extracting some values initially but was running very very slow and would take about ten minutes too update, but now I am getting no results since I have had a play around with it

the brand is Apple within the database

the model_number could have 1 or two spaces at the end, beginning and could also be a mixture of upper and lower case letters hence the upper rtrim ltrim commands

EG %iphone%%3g%8gb or iphone%3G%8GB

Because someone initially wrote the code, please find this attached for clarify sake

Thanks in advance all

February 12, 2014



/* Pass in the region from the webform */

/* EG Region R1 so select query would be R1 */

SELECT `Insurer` , `PolicyName`, `SingleR1`
CASE {$numberofadults}
  WHEN 1 THEN "Single{R1}"
  WHEN 2 THEN "Single{R1}"
  WHEN 3 THEN "(Single{R1} x 3 x 0.95)"
  WHEN 4 THEN "(Single{R1} x 4 x 0.95)"
  WHEN 5 THEN "(Single{R1} x 5 x 0.95)"
  WHEN 6 THEN "(Single{R1} x 6 x 0.95)"
  WHEN 7 THEN "(Single{R1} x 7 x 0.95)"
  WHEN 8 THEN "(Single{R1} x 8 x 0.95)"
  WHEN 9 THEN "(Single{R1} x 9 x 0.95)"
  WHEN 10 THEN "(Single{R1} x 10 x 0.95)"
END AS 'Price'
FROM `travelinsurance`
WHERE 43    /* Here we need to pass the ages from the form, Testing on only 1 traveller at age 43, what if 5 travellers and one is age 70 */
BETWEEN `AgeMin`
AND `AgeMax`
AND `DurationUnit` = 'Days'
AND 2 BETWEEN `DurationDaysMin` AND `DurationDaysMax` 
ORDER BY `Insurer`

Hi Professionals I have an update I still cannot figure out the formula or if it is even possible, apparently I do not need the DuoR1 column it will only query the SingleR1 column or SingleR2 and so on so this is what I have back from the insurance people

So lets say that a 40 year old traveler is $60 and a 70 year old traveller is $70 as once the age is over 59 the policy price goes up

if there are more than 2 travelers then it is automatically a 5% discount

So if there were 3 x 40 year olds and 2 x 70 year olds it would be

(3 x $60 + 2 x $70) x 0.95 for the 5% discount

what would be the best possible approach to this

Im not sure if this mathematical formula is possible but if it is then thanks in advance

February 10, 2014

"SELECT `Insurer` , `Policy Name`, `SingleR1` AS 'Price'
from table"

or

"SELECT `Insurer` , `Policy Name`, `DuoR1` + `SingleR1` AS 'Price'
from table"

this needs to change and add two columns together the DuoR1 and SingleR1 because it is now a 3 person policy.

"SELECT `Insurer` , `Policy Name`, `DuoR1` + `SingleR1` AS 'Price'
from table"

the policy is (DuoR1 + SingleR1)

Hi physco

That gets them echoed out fine, but rather than the table initially querying 1 column it now needs to query two columns in the db and add them together. EG 3 person policy so now needs to add two columns, I hope I am making sense

February 10, 2014



switch ($destinationCode) 

			{

   		case 'WW':

			$region = 'R1';

			break;

		case 'EU':

			$region = 'R2';	

			break;

		case 'AS':

			$region = 'R3';

			break;

		case 'PC':

			$region = 'R4';

			break;

		case 'AU':

			$region = 'R5';

   			break;

}


switch ($numberofadults) 

			{

   		case 1:

			$policyandregion = 'Single' .$region;

			break;		

   		case 2:

			$policyandregion = 'Duo' .$region;

			break;

		case 3:

			$policyandregion = 'Duo' .$region + 'Single' .$region;

			break;

			}


$rew=mysql_query("SELECT `Insurer` , `omedassistance`,`excess`,`Policy Name`, `$policyandregion` AS 'Price'

FROM `travelinsurance`

WHERE 43 

BETWEEN `Age Min` 

AND `Age Max`

AND `Duration Unit` = 'Days' 

AND $num_of_days BETWEEN `DurationDaysMin` AND `DurationDaysMax`

ORDER BY `Insurer`")





MYSQL QUERY NEEDS TO BE


SELECT `Insurer` , `omedassistance` , `excess` , `Policy Name` , `SingleR1` + `DuoR1` AS 'Price'

FROM `travelinsurance` 

WHERE 43 

BETWEEN `Age Min` 

AND `Age Max` 

AND `Duration Unit` = 'Days'

AND 2 

BETWEEN `DurationDaysMin`

February 10, 2014

Hi all

I have some code that I cannot figure out

Basically I have a variable that adds a regionid to a policytype

what happens is

if it is Region1(R1) I add this to a policytype eg single or duo so it would be SingleR1 or DuoR1 or SingleR2 etc which works fine

the problem is when it is more than 2 people...So if it is 3 people it would be DuoR1 + SingleR1 so I am trying to merge the columns in sql but cannot figure out how to do this or if it is even possible

so my query would be select 'DuoR1' + 'SingleR1' from table. this policy type would go up to a maximum of ten people

so I would get 'DuoR1' + 'DuoR1' for 4 people, 'DuoR1' + 'DuoR1' + 'SingleR1' for 5 people and so on.

I have attached my code to make this clearer

and thanks in advance

policyandregion.txt

Sign In

oracle765

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by oracle765

stuck with aligning textboxes and writing

stuck with aligning textboxes and writing

stuck with aligning textboxes and writing

Stuck with some css

Stuck with some css

Display results not working

Display results not working

Display results not working

Display results not working

Display results not working

Display results not working

Display results not working

Display results not working

Display results not working

Display results not working

Display results not working

PHP AJAX Query not working correctly

PHP AJAX Query not working correctly

1 Page insurance formula using mysql and php

PHP AJAX Query not working correctly

PHP AJAX Query not working correctly

Merge columns to ad together

Merge columns to ad together

Merge columns to ad together

Merge columns to ad together

Browse

Activity

Important Information