ginerjm
-
Posts
6,906 -
Joined
-
Last visited
-
Days Won
99
Everything posted by ginerjm
-
Since those tables all have the exact same symbolic structure, I'm wondering why you don't have their data all in one table. That would be normalization. What makes it necessary to store those records in 3 separate tables? -
Queries don't return arrays. Why do you need so many queries? Is your db not normalized properly? From the sound of your project, You s/b able to pull up the info you need with a properly written query and then be able to process that resource and display it all in one pass.
-
What timezone do you want to use? Or is it based on the location of the client? PHP is going to give you the time that is set in the .ini file, which probably is related to the location of the server farm. If you're not setting it, then perhaps the default is set by GD and you should use phpinfo to determine what it is. If it's not what you want, read up on how to modify php.ini settings. (Hint: search the php manual) I'm no expert on handling times in zones related to the client, so I may be of no help here. But if you are the one seeing the problem, I think it's what I said above.
-
You really needn't have included ALL that code. As for how to NOT require a field in an html form - easy. Fields (input tags) are never required. Simple as that.
-
Sorry - can't make sense out of all that data, nor do I get what your topic subject is talking about. I don't know how an sql query can return an array in its result. Since MySQL tables don't contain arrays, where would one obtain an array in a query result? Maybe you can re-word your question and try to describe your dilemma with less 'example' and more 'content'?
-
You should be setting your default time zone setting in your php.ini. I think that would solve this. At least include it in a generic startup 'include' in all your scripts. Actually, I believe that php gives you an error/warning when you try to use a data/time function and you don't have it set. Sorry to hear that you've hitched yourself to GoDaddy.
-
That's just it though - you need much more than "simple help". As I said before - read a book - learn the old fashioned way. When you get something developed that resembles good code and need some help, then we'll be more than willing to help. BTW - nice try on your spelling corrections but you still have it wrong. tsk, tsk. At 13, perhaps you should be concentrating more on school - reading, writing, arithmetic, and such instead of trying to learn programming. Those things will get you much farther in this world than learning how to program. Spelling too!
-
Sorry - but you're digging yourself in deeper. 1 - your grammer is not good. Check your uses of tense in your last post... tsk, tsk. 2 - examples of your perfect spelling: <li><a href="#">Freinds</a></li> <li><a href="#">Cirlce</a></li> 3 - if your isp is providing you such great help, ask them for more. Sorry - I've done enough here.
-
Where did you get the idea to use foreach???? From some other example? Read up on what foreach does. Then think about what you want to do and how to access arrays. And then the solution should be plain.
-
Why is it so obvious? 1 - you select a db with a numeric name - very unusual IMHO. 2 - then you query a table that is named the same as the db - also very unusual. 3 - you write a query that has no criteria in it to get the specific record you need 4 - then you attempt to access the results of a query but you're feeding it a query string 5 - then you attempt to echo the resource supposedly returned from your (non-executed) query, but again you are providing the query string So - I'd say it's pretty obvious. Read your book; learn how to use the mysqli functions in php; then attempt this code again. With so much wrong with your code it is meaningless for us to offer you assistance. And - learn how to spell too! You'll make a better impression.
-
It is obvious you have ABSOLUTELY NO KNOWLEDGE of anything you are doing here. Try a book.
-
Might I suggest that you post code that others may not find patently offensive?
-
Where do you execute your query? Not that the query makes sense.
-
Delete multiple rows with PDO and checkboxes
ginerjm replied to davidolson's topic in PHP Coding Help
Can't use a bound variable that has multiple values. Read the manual -
Delete multiple rows with PDO and checkboxes
ginerjm replied to davidolson's topic in PHP Coding Help
?? I repeat: ?? -
You signed up for a class (required or otherwise) and haven't done the learning part and want us to do your homework? Send me your professor's name and address and I'll tell him/her that the school is too demanding for you and that you should be excused from having to do any actual learning. No charge!
-
How do you know it's not working? You don't output anything. 1- Remove the leading % sign in your like argument. 2 - I'm assuming that 'subhire_id' looks like "2014.1065.nn" ?
-
Psycho - you are leaving out the display of the current row when there is a break on a category. One needs to output the total line when there is a break but then you have to display the current data in the next row,
-
This tells me absolutely nothing other than you need to order by Name And Contact
-
HTML and PHP won't fit on same line in output
ginerjm replied to LivingReceiver's topic in PHP Coding Help
What does this do for you? for ($I=0; $I<1; $I++) Why not just echo $pic[0] ? So anyway - you have a div that is of unknown width; perhaps that is the problem. Also - I am unaware of any <large> or <red> or <text> html tags. Are these something new? -
Dump the colspans you dont' need them. Learn how to put column headings in an html table (read a reference on html - plenty out there). Hopefully your sample is just not bothering to display actual variables and that you do know how to show php vars in a table.
-
HTML and PHP won't fit on same line in output
ginerjm replied to LivingReceiver's topic in PHP Coding Help
I'd start by writing better html. Have no idea what your first few lines are doing. As for keeping things on a line.it all depends on the width of your available screen space. Are you controlling that somewhere? (Tip: try using single quotes in place of your slash-double quotes. It's not only easier to write but much easier to read.) -
I think the OP needs to think more about what to display rather than what to read. The way this kind of thing is done (the same way every time) is to be sure the items are in the right sequence; check for a break in a category and output what needs to be done for that category; then output what is on the current record, remember to display those 'header columns' that need to be reset with this latest change. Remember to check your category changes in reverse order too. The major category, then the 2nd major one, and so on. When a category changes you need to be sure to handle totals for each category below that one as well as the breaking one. Once you figure this out you'll be amazed how easy it is and you'll have the technique for the future in all your projects.
-
You have a space between your slash and your url name. Specify the url correctly and perhaps it will work.
-
I don't read external files, so my purpose in answering is to ask if you have made the effort to add some debugging info to your modules to be sure that what you expect to happen is actually happening as the flow passes thru each module. A few echo's can go a long way towards isolating your problem so that THEN you can post the offending (small) section of code and perhaps get a quicker answer.