Search results for query: *

I wrote a function to put the page number at the bottom of each page and I understand in general why it's not working but cannot work out the logistics to make it work. This is being run inside a foreach loop after the rest of the content is written to the screen. $PageNo (and $RevDate) are...

I'm trying to come up with a query that will give me a range of years from a specific start to specific end, and then to auto-increment the list starting at another specific value. So far I've succeeded partially by getting the year values from an existing table but it does not have the full...

How can I get the row number in a list of entries? It's not the number of rows in the result that I need: it is a line by line count of each one.

I'm trying to parse the apache.log file and have a function working that does so, but I know little about regex and could not parse it directly. I reviewd and tried just about every posting I could find here and on other sites but nothing worked. Please see $pattern below and can tell me how to...

I created a function to emulate the Apache access.log in MySQL and it is working but there are several things with which I need help. Any thoughts on the following? The first is $status for which I created the GetStatus() function but when it is used, the server times out. Using the same code...

I've created a relatively simple function to convert the Apache access.log file to MySQL, and the plan is to run it just once (if it doesn't time out!) per site to populate the table, then it won't need to be run again as the site will then keep the table up to date automatically with other...

I'm working on what should be a simple function to get the name of one of two California counties. However, on the line highlighted below, address_components[3] for one county gives the proper value but for other it needs to use address_components[4] to get the proper value. That is, for one of...

I am trying to create a function that has the input of a block of text with a code [VisitDate] it in to be replaced by certain text but can't get it to work. The query itself is pulling up the proper results so currently there is one where Message is 2 (the rest are 0) but there may be times...

I am a back-end programmer so don't know JavaScript very well other than the very basics so I am unsure how to add a feature to some existing code. The form has a number of field verifications to be sure that everything is filled but I also want to add a final message where selecting OK will...

I know that PHP cannot fetch the screen size but using a bit of JavaScript to write a cookie, it gave me a value with which to start. However, I must have missed something because I can't get the session written! Does anyone see what's wrong? I use sessions all the time and sessions themselves...

I have a function I wrote some time ago that replaces a bit of text in a paragraph and it's working well but I am trying to rework it to be able to make multiple replacements and cannot seem to get it to work. The replaced text is something like [VisitDate1], [VisitDate2] etc. and here is the...

Can someone help with using %d in a sprintf()? I thought it would take the signed integers which, in this case, are for latitude and longitude, and insert them and it does do so but it rounds them to all zeros after the decimal. The MySQL fields are decimal(8,6) and decimal(9,6) respectively so...

Some time ago I created a function for building font-based images on one of my sites and it is working fine but now I need to repurpose it for another site that sometimes needs to use two different fonts to create the image. Using the GD library (Imagick is not available), can someone help me...

I use this code on several sites but it seems to be resisting my efforts to add it to a new one. When I submit the empty form as a test, all fields except EMail highlight in yellow but for only a second or two, then the form submits. There is no alert and no yellow on the EMail field. It's not a...

I created a set of data using Excel and saved it as CSV for importing into a MySQL database. I am not done creating the data entries, however find that now when I open the file in Excel, some cells get converted to dates when they are not dates. In one column in particular, the data sometimes...

I created a function for creating a PDF from MySQL database entries and it is working but I am unable to put the thumbnail images onto the same line as the text. I understand that FPDF does not support this for some reason so I added an extension but it seems to do nothing more than it would...

This may be a MySQL query question but I suspect that PHP would be needed instead. In a table with a number of columns, there are two as shown below that I'm having trouble with. The data is from 1930s, 1940s and 1950s automotive parts books so I cannot change it but I need to be able to search...

I'm trying to remove two folders, Windows.old and Windows.old(1), but have been unsuccessful so far. I followed Microsoft's instructions for cleaning the hard drive but the folders remain. I tried the CMD prompt in Administrator mode and ran RMDIR "C:\Windows.old" /S and when that didn't work I...

I'm trying to insert a date/time to MySQL using sprintf() but can't seem to work out how to do it. The date and time are formatted as 2014-10-01 09:30:00 but I'm not sure how to format the data to insert it. I tried '%04d-%02d-%02d %02d:%02d:%02d' but get an error of too few arguments. What am I...

Some time ago I created a form with some functions for uploading files to my Web server. No real problem there but then I decided to also repurpose a function for resizing the image but I am having difficulty in getting the new file name and placing it into the table. I know why but I'm not...