I need to dump a database table (query) directly to an xls file without storing file on server. Here is some code Ray wrote. It saves the file to the server and creates a link to download.
I run the rhe client program (a credit card processor) and run simple scripts to return the values it posts
and PHP works.. not asp.
I have no access to the posting script/program
With php I …
I have this session variable:
it stores inside wed, the qty chosen along with the price.
when I print it out I get:
I have an if statement which is :
"none" hides my …
I have two tables in MySQL. In the first table, I store people details and the second one is used as a "log" to record every time a person is contacted. How can I fetch all data …
When I do this:
I get this output:
I want to get this part for an array for each day "protien_id['mon'][THISPART]
But only if the "qty" is greater than 0 , for example
I have used code like this
But within a few seconds the session expires, so it redirect to login page. I need 10 Min to expire the session.
I have also created php.ini in kept in root …
When I decode some JSON I am noticing symbols are being returned. What is the best way to parse out the odd symbols being returned from the JSON string?
See below image...
I have a script that inserts items into mysql which works fine. However, what I need to do is check for duplicate entries and if found, issue alert and halt. I have coded some php but cannot …
I have a specific problem that I'm struggling with and need some assistance ... ok here we go.
I'm outputting my MySql query into a PDF as follows using the following php.
I have this json encode right now:
How can I make it like this?
meaning the "0": after the 2017-05-01 string and before the timezone to be taken off? How is this done?
I have this right now stored in my database:
How can I make it like this?
I got the above by this, as you can see they are arrays:
I have the following function on our site, which captures UTM tracking codes in cookies. Users click on external ads, or through external sites to get to our site, and the UTM is stored in the …
could I change to phpbb forum
As I understand it, unlink() is the way to go with deleting named files (in this case images) from a particular folder in PHP and MySQL.
I have some code which deletes multiple records from a table…
I got a lot of valuable help via live help here on EE last night, but I am still having a hard time trying to figure out how to display individual error messages.
In PHP only I would do something …
I have indexed the SKU column in both DB tables. How do I speed this query up? (There are 20,000+ records in table "Download")
I was using WHERE NOT IN and thought I could speed it up some by …
Is there a good and programmatic way, possibly with my htaccess or a wordpress plugin to only allow US based traffic see my site, blocking all countries but the US?
I use php,
I have a web page that I should not allow anybody posting data to my website except one specific web site.
How can I block all the posts coming from outside except one domain?
I want …
Ok, my page: http://www.col-b.uk/SLSO/?page=gallery
My requirements: A responsive image gallery using flexbox with assorted size and shaped photos. Nice-to-have: loaded dynamically.
I'd like to show a page where all dates from day_1 to day_n are populated with data from a database:
This file prints background-colors; every second file should be colored #E5EDF6 the others …
I have code that sends a single item to php for processing which works fine. However, I now find myself needing to send a 2nd item var dept, to the php and cannot seem to get it right. I have …
I am getting confused by all these different variations i.e.: success/done/promise and can't figure out how to change this code so that if there are validation errors, the form will not disappear but …
how can I do that?
initially i have the submit disabled so users cannot submit an empty list. Is there way with my existing code to detect if a list has items and enable the submit button. However if a user removes …