[How can API query be presented nicely on results page]

thanks, do you do api work, I posted in the freelancer section

[Display results not working]

Hi I am querying skyscanner api and the output does not seem to show, even though it works fine for expedias on the same page, any ideas what I could be missing, it says something about An HTTP header value of 'application/json' should be specified to return data in json format

 

 

here is my code

skyscanner.php

[Running a batch file]

Hi Professionals

 

I have a batch file that's runs fine.  So what I am trying to do is when a user clicks a link then that batch file runs problem is I cannot get this to work via html/php

 

 

It wont let me upload the file so here is the line of code

 

<td width="33%" align="left"> <a href="batchfiles/"<?php exec(CleanseChars.bat); ?>">Cleanse Characters"</a></td>

 

 

thanks in advance

[How can API query be presented nicely on results page]

Hi Professional

 

I have a webpage like called testrest.php attached which pulls in results from an api query, it is very basic

 

 

the problem is it pulls on many many results in a format I am not sure how to present on a results page.

 

Is there a way to get around this

 

please see webpage and results out put

 

thanks

testrest.php

API Results.txt

[Looking 2 webpages sorting out where ive queried an api]

Hi All

 

I have been figuring out how to query an api which I have managed to do and provide the output to screen. as you can see on compareandchoose.com.au/testrest.php

 

problem is I am not sure how to pass the variables into the API (which I can then query) and produce these in a readable format.  Similar to travelsupermarkets hotel menu

 

I can be contact on admin@compareandchoose.com.au

 

Please provide an example of your skills, availability and price

 

Thanks

Alan

[Cronjob stripping url]

that worked thanks very much

[Cronjob stripping url]

Hi Kicken

 

that's brilliant that works thanks very much, however I am now faced with another problem.

 

Because the files are in .GZ format I cant seem to unzip them I get an error message as shown in the new attached file saying

 

gzip: invalid suffix ''

feedimport.txt

[Cron Job! Seems to be something wrong with my php]

Well I have no idea, I am totally lost but its defo not updating the DB

[Cron Job! Seems to be something wrong with my php]

it shows a 1 at the top of screen

[Cron Job! Seems to be something wrong with my php]

its localmachine on the godaddy webhost

[Cron Job! Seems to be something wrong with my php]

yeah they are correct

[Cronjob stripping url]

ah sorry forgetting to click attach this file at the bottom

feedimport.txt

[Cronjob stripping url]

ah didn't attach it as an sh file I have changed it to text

[Cronjob stripping url]

HI Professionals

 

I have a cron job (attached) which runs a .sh script (attached) to download a csv file from an affiliate.

 

Problem is in the URL part it comes across the $ sign within the url and cuts part of the url away so I only receive a blank empty file.

 

I have also attached the results from the cronjob any ideas whats going wrong as when I paste the url into the browser there is obviously nothing there because it has been chopped

[Cron Job! Seems to be something wrong with my php]

I tried putting /usr/bin/php -f /home/username/public_html/scripts/masters.php in the cron job but then the emails stopped coming through

 

I also tried typing http://www.compareandchoose.com.au/scripts/masters.php in the browser and ti also did not load the data into the database but just shows a blank screen as there is no html output

 

I am so lost as to what it could be because those ` parenthesis around $dbH don't even exist in my code

[Cron Job! Seems to be something wrong with my php]

oh and I have tried running the webpage in the browser and when I go into the database it has not inserted the .csv file I have also put the full path in but that didn't work

[Cron Job! Seems to be something wrong with my php]

ok firstly how I didn't notice the beginning of the file not saying <?php I don't know silly me

 

anyway I have attached the new file and taken out the html stuff but I am still getting the same error

masters.php

[My price does not seem to be updating]

ive tried that and my dreamweaver php editor shows and error for the last 2 lines of code you provided $query2,$result2

[Cron Job! Seems to be something wrong with my php]

oh and the cronjob is * * * * * /home/username/public_html/scripts/master.php

[Cron Job! Seems to be something wrong with my php]

Hi Professionals

 

 

I have been testing a php cron job and it is producing errors in the email response it sends to me, I have looked and looked and cannot see what seems to be wrong.

 

Any ideas

 

 

thanks in advance

masters.php

error.txt

[My price does not seem to be updating]

Hi Professionals

 

I have problems with my code and I cannot figure out why it is not updating the price by 1

 

Within the database the merchant table price is decimal 10.2 and the name is varchar

 

 

thanks

config.php

masters.php

[help with stuff overlapping]

I have resolved this thanks

[help with stuff overlapping]

Hi Epsilon

 

 

thanks for that, I have moved the PHP and done what you said and all is working ok apart from the footer of the page, the content I am extracting from the database is still displaying cut off at the bottom of the page if I set the results per page 4 or more.

 

I have tried everything but cannot pinpoint exactly where the problem lies

[help with stuff overlapping]

Hi Professionals

 

I am struggling with my webpage which you can see located at www.compareandchoose.com.au/fashionindex.php

 

I have the transparent writing over the photo.jpg which overlaps my content and also the bottom of the left menu, right menu and results content is cut off at the bottom.

 

I have been working on this for hours but as I am new to php/css I just cannot figure out what properties are incorrect

 

I have also managed to take out the header and footer and include them in include files but cannot figure out how to do this for the left menu and right menu without the page totally messing up.

 

I will attach the files and included files to see if anyone can figure out what seems to be causing the problems

 

OH and thanks in advance to anyone

fashionindex.php

style.css

header.php

footer.php

[pagination problem]

hey physco thanks for that it works great.

 

just one thing I have notice which I am confused about is which DB connection is it using or is it using both as I am including the config file as shown above but also specifying the connection within the webpage code?

 

as you state it is better to take out as much as possible from the actual page then I only have to make any changes in one place.

 

 

thanks again you have been more than helpful in resolving my problem