ginerjm
-
Posts
6,906 -
Joined
-
Last visited
-
Days Won
99
Everything posted by ginerjm
-
I sure hope not. It's called spam.
-
That's an insert query - but not a retrieval. Unless your question concerned data not getting on to the table. I thought you were having difficulties retrieving 'all' your data, so this would not be it.
-
Storing of Row labelled as "problematic"
ginerjm replied to RuleBritannia's topic in PHP Coding Help
Have fun! -
The query would be most helpful - if we can help at all.
-
Storing of Row labelled as "problematic"
ginerjm replied to RuleBritannia's topic in PHP Coding Help
Sounds to me like you are NOT handling this project wisely. With the possibility for "thousands of rows here daily" having any significant number of errors, that you don't want these things to be processed, but rather rejected at input. You really should step back and think about what you can do to help validate the input while the user is in the act of doing it so as to prevent as many 'rejections' as possible. Do you really want to be reviewing dozens(?) of errors every day? PS - this is the first time I've heard of your approach to error handling in 30+ years of design and development. Very strange. -
Since you haven't given us a peek at some actual CODE, perhaps you can tell us which of the fields you place in your table are missing? Then we might be able to guess at it.
-
Storing of Row labelled as "problematic"
ginerjm replied to RuleBritannia's topic in PHP Coding Help
What do you mean by a processing error? Do you mean you can't add the data to the table? Perhaps you should solve the problem rather than shuffling the data somewhere else. Check for valid data entry before attempting to post it to the db. -
The way it works in forums - you write your code. We help if you have a bug or problem with it.
-
Php form validation error after pressing the send button
ginerjm replied to NeoNoe89's topic in PHP Coding Help
already addressed in your OTHER FORUM posting! -
Looking at your plan it seems very workable. I would revise the two tables to be sure that you can match like room titles/ids since currently they seem to be different. Process then would be to seek records from both tables that match the standard room type desired and any 'special' room rate records that match that type and the specified date range. Pretty straight forward to me.
-
Need to translate datetime from 10 digit to standard date
ginerjm replied to systemsgotyou's topic in PHP Coding Help
You can read up on DATE_FORMAT function of MySQL (its online) or you can use the date function of php to translate it (its in the php manual) -
I"m trying to use an email to generate some input to a script of mine. I begin by using the script on my client to generate an email that contains a form with information and an input tag and a submit button. The form triggers this same script again, but with a different intended action which is to gather the input values and update my database. Here is the form from the email: <!DOCTYPE html><html> <form name='emailform' method='POST' action='http://(mydomainname)/(myscriptname)'> (general text) <div style='background-color:#c0c0c0;padding:10px 20px;width:50%;'> <label>#20 - Bottles purchased:</label> <input type='text' name='pq_qty_20' value='' size=3 pattern='[0-9]'> </div> <br> _________<br><br><br> <div style='background-color:#c0c0c0;padding:10px 20px;width:50%;'> <input type='submit' name='btn' value='Post Email Purchases'> </div> </form> </html> So - testing this on my laptop with my browser open and running this script, I generate the email. Going to my email client and grabbing the email I click on the <input tag and my browser immediately opens up a new window running the same script. Filling in the input value and then clicking the submit button opens up a third window on my browser but no other activity occurs. What should be happening is no new browser windows (hopefully) but a process to update a record in my db from the input in the email - this does not happen though. So - I have managed to generate a vaild html email which when I test using the script on my laptop seems to be working. But when using the form from my email client I get screwy and non-existent results. Anyone done this before?
-
Isn't your url a path to a folder? Can you then read the contents of a whole folder with file_get_contents? From my reading, f_g_c reads a 'file'. I think you need to use glob on that $url and then go thru each one looking at the last modified date or whatever criteria you want to use.
-
Sorry - don't know much about regex strings.
-
FPDF works very well. What is "tamil content"?
-
For future reference you have a "script with a function and a form".
-
You have a form with a function? That's about the only thing I understood from your post. And I don't believe it. I'd love to see the code that implements this 'thing'.
-
200 views and no replies - usually means we don't understand what you are asking. Your descript may make sense to you - you know what you are doing. We don't and can't figure it out from your sketchy outline. Want to try again? I really don't understand it at all.
-
Lookup and Find a table and show data based on another table
ginerjm replied to ArthurHick's topic in PHP Coding Help
A new table for each new event? Or a new row in the events table? The former seems more likely. YOu create a new table and put how many rows in it after that? -
I saw the part about the passwords, but it didn't mention dbname.
-
I'm still wondering why it works when you don't select a database name.
-
Sorry - that doesn't help me to help you either. Good luck.
-
I've been a programmer for 30+ years - still don't have a structure. Programming is about learning to solve problems in a logical way and writing code in sensible way so that you and others can decipher it in the future. That's about as much structure as one needs.
-
IMHO - as a newbie you should begin by trying simple procedural php and html and SEE how it's done. You have a perfect learning-tool example project in front of you, so just work on the php to generate the page (html) and the php to handle the input and post the data to your db. When you have that working you can then find something else to do (phase 2?) that you can work a class into. Basically, this example doesn't need classes as it is so small and limited. Good luck.
-
You really expect somebody to volunteer to read thru 200+ lines of your code of which we know nothing and try to 1) figure out what it's supposed to do and 2) what it is you want it to do when 3) you don't even know? Usually when people ask for help on a forum they have done their homework and tried to isolate a small are where the problem may be and then clearly stated what is is doing wrong. Can you do that?