Triple_Nothing
Super Moderator
Devshed Beginner (1000 - 1499 posts)
- Join Date
- June 29th, 2009
- Last Activity
- Yesterday 07:07 AM
2 Friends
Recent Visitors
- ChromeX,
- DonR,
- foreverforever,
- minhland2345,
- mumb991,
- ngocnhu97dn,
- Pearl_9,
- phanxuan5,
- thithaodn47,
- Will-O-The-Wisp
-
Older Activity
-
Now, I do want to point out right away. The code below is not corrected or complete in any way. My goal was to simplify what you had typed to help...October 16th, 2017, 05:02 PM33 replies | 549 view(s) -
Well, the idea actually sounds very simple. You'd basicly define an array to hold the returned individuals for that day, if any. And that foreach()...October 15th, 2017, 07:35 PM33 replies | 549 view(s)
-
With bindParam you can adjust the date from an array or so, and build a loop which would only hold your ->execute(); and ->fetch() items. bindValue...October 15th, 2017, 05:31 PM33 replies | 549 view(s)
-
I think the best way to word it may be simply by saying how/when. $sex = 'male'; $s = $dbh->prepare('SELECT name FROM students WHERE sex = :sex');...October 15th, 2017, 07:41 AM33 replies | 549 view(s)
-
Well, if aiming for the year, you can define a range, or the YEAR(), and then define a LIMIT to return the 90 that you're aiming to LIMIT or max out...October 14th, 2017, 05:03 PM33 replies | 549 view(s)
-
Were you running JUST my script? Or were you adding that into yours? Is $db still defined in your PDO namespace? Edit: With random individual...October 14th, 2017, 03:53 PM33 replies | 549 view(s)
-
Hope this gets you another step... <?php function getName(\PDO $db, \DateTime $day) { $sql = 'SELECT employee.name AS Name,...October 14th, 2017, 02:41 PM33 replies | 549 view(s)
-
Where are you using $day in your function? Where is $start defined? $date = $day->format('2017-10-5'); is invalid... And if it is to process as I...October 14th, 2017, 08:53 AM33 replies | 549 view(s)
-
Only a guess, but I assuming/hoping you have this code in 3 parts. If not, feel free to post everything you got to give us a clear idea of your...October 14th, 2017, 08:31 AM33 replies | 549 view(s)
-
I am on PHP 7, and I know it has a fair amount of changes. How exactly is the code below functioning with the double ??'s $page = $_GET ?? $_SESSION...October 13th, 2017, 01:50 PM14 replies | 333 view(s)
-
Well, what ends up in the $_GET may not always be the initial arrival/defining of the page. Since most is really charts, a main item that may just...October 12th, 2017, 07:33 PM14 replies | 333 view(s)
-
To avoid the echo-ing HTML remarks, does this code suffice? I move my isset() to the upper part of my code checking/setting my $_SESSION variables....October 12th, 2017, 06:18 PM14 replies | 333 view(s)
-
First off, your foreach() is defining $recipientID, so why are you doing it again right away? foreach ($_POST It does make sense to use this item...October 12th, 2017, 07:24 AM1 replies | 119 view(s)
-
Hope this helps a bit... <?php function getDateCounts(\PDO $db, \DateTime $start) { ("SELECT ..."); // Missing binding variable? $stmt...October 12th, 2017, 07:13 AM33 replies | 549 view(s)
-
Just wondering if anyone has suggestions for/against my alteration? I know the 'short-hand' line is a bit long, but wondering if the idea has much...October 11th, 2017, 08:14 PM14 replies | 333 view(s)
-
Since I believe you have 3 goals, your format should be similar to: if () { echo ''; } elseif () { echo ''; } else { echo ''; } If you...October 11th, 2017, 05:04 PM26 replies | 567 view(s)
-
Just switched over to the "Valid Pages" idea, so I hope this looks good! ;) <?php session_start(); $_SESSION = isset($_GET) ? $_GET :...October 8th, 2017, 01:01 PM14 replies | 333 view(s)
-
As y'all have provided suggestions, they whole $permitted_pages does provide a simple way to add the else/default action/value. The functions are...October 8th, 2017, 11:59 AM14 replies | 333 view(s)
-
Hey all. I know the 2 are rather alike. I'm just looking for possible suggestions to pick one over the other before I finalize my structure in this...October 8th, 2017, 11:22 AM14 replies | 333 view(s)
-
Then you might be putting it in the wrong place. This will output everything that was fetched from the database, and stored into that array. Are you...October 7th, 2017, 05:56 PM26 replies | 567 view(s)
-
If the direct query returns the expected result, your query should be working as you desire. Since you mentioned your echo was supplying the expected...October 6th, 2017, 08:01 PM26 replies | 567 view(s)
-
As a quick note, I believe kicken intended to 'return $result;' instead of 'return $row;' in his getDateCounts() function.October 6th, 2017, 07:42 AM26 replies | 567 view(s)
-
Well, the thing is we are offering an answer to the basic of a question without the true fullness in knowledge of the intent. Your first question may...October 5th, 2017, 07:50 PM26 replies | 567 view(s)
-
When you say "null for the counts", you can still SELECT the DATES. The thing with the count is the fact that the count has really nothing to do with...October 5th, 2017, 05:12 PM26 replies | 567 view(s)
-
In relation to your if/then/else... You won't be able to check as you started. The first will simply check if $officer is greater than 3, and set...October 5th, 2017, 03:41 PM26 replies | 567 view(s)
-
@kicken: Nice mention of the CASE WHEN. I tried to think of putting it into a single query, but that didn't cross my mind. ;) @SGC3: As far as...October 5th, 2017, 06:50 AM26 replies | 567 view(s)
-
Well, there is nothing wrong with the thought of your PHP, as long as $officer is to take precedence over $total. However, your SQL isn't right at...October 4th, 2017, 06:33 PM26 replies | 567 view(s)
-
Well, my script works fine now, but the thought of looking through a list, if aiming for DISTINCT items, a human would note a value if it is the...September 26th, 2017, 08:00 PM5 replies | 247 view(s)
-
Ya. I've checked out a handful of debates out there. It seems they are rather alike, but I've seen nothing mention an answer to a thought of: In...September 26th, 2017, 12:45 PM5 replies | 247 view(s)
-
I feel this is a really basic request via a GROUP BY, but I must just be overlooking it... All I want to do is have a set of years returned that...September 26th, 2017, 10:20 AM5 replies | 247 view(s)
Latest Reputation Given
Thread / Date
User / Points
Comment
User / Points
Comment
-
Thread / Date
switch() vs elseif()
October 8th, 201702:38 PMUser / Points
You gave 0 toComment
Nice. -
Thread / Date
Adding Query Result to a variable
October 7th, 201706:43 AMUser / Points
You gave 0 toComment
I always forget that which does not exist... -
Thread / Date
PHPMyAdmin - sub-folders only?
June 9th, 201607:15 AMUser / Points
You gave 0 toComment
No Comment Made -
Thread / Date
Combining/Cleaning up a header...
May 15th, 201607:57 PMUser / Points
You gave 0 toComment
Thanks!
-
Thread / Date
Cannot update database
May 8th, 201601:34 PMUser / Points
You gave 0 toComment
Nicely displayed. Visual appearance is EXTREMELY helpful in troubleshooting. ;-) -
Thread / Date
Query excludes results with partially empty entries
January 12th, 201608:04 PMUser / Points
You gave 0 toComment
Ya, I've no clue where that came from...
-
Thread / Date
Pagination Not Showing Page2
January 10th, 201608:10 AMUser / Points
You gave 0 toComment
It being colored is a pleasurable feature. If it's simply the color is required, one can copy/paste to their own editor. -
Thread / Date
A simple math problem with PHP
April 30th, 201502:55 PMUser / Points
You gave 0 toComment
Nice job! ;-) -
Thread / Date
Query between two dates
November 23rd, 201406:54 AMUser / Points
You gave 0 toComment
My apologies, hence my "IF I am correct, BETWEEN is ran rather literally" -
Thread / Date
Seach and dropdown in php
November 13th, 201409:42 AMUser / Points
You gave 0 toComment
Ya. I say the default/selected is more an "Edit" mode type thing.
Latest Reputation Received 10160 point(s) total
Thread / Date
User / Points
Comment
User / Points
Comment
-
Thread / Date
Adding Query Result to a variable
October 6th, 201710:14 AMUser / Points
You recieved 4103 fromComment
Indeed -
Thread / Date
Adding Query Result to a variable
October 5th, 201705:11 PMUser / Points
You recieved 2 fromComment
No Comment Made -
Thread / Date
NULL in Prepared Statements
June 27th, 201709:38 AMUser / Points
You recieved 4536 fromComment
Sounds good! -
Thread / Date
How Come Variable Not Assigned And Php Knows Where To Look For Value ?
May 28th, 201704:30 PMUser / Points
You recieved 1 fromComment
No Comment Made -
Thread / Date
Need some help with menu to showing up correctly
September 26th, 201604:07 AMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
Coding a Image Generator W/ HWID Login System
July 26th, 201603:57 PMUser / Points
You recieved 10 fromComment
No Comment Made -
Thread / Date
Foundation 6 Resize issues plus more
June 23rd, 201610:13 AMUser / Points
You recieved 10 fromComment
Thanks! -
Thread / Date
php/JSON/jQuery - what am I doing wrong ?
June 22nd, 201601:31 PMUser / Points
You recieved 7 fromComment
No Comment Made -
Thread / Date
Foundation 6 Resize issues plus more
June 22nd, 201612:47 PMUser / Points
You recieved 10 fromComment
No Comment Made -
Thread / Date
Database Joins, Loops and Flags, Flags, Flags
June 12th, 201606:17 PMUser / Points
You recieved 0 fromComment
I know the feeling
But sometimes it can be nice with different type of explanation.
