Not familiar with Doctrine script, but... This old-style JOIN should achieve the same result as a RIGHT JOIN in most SQL scripts:
SELECT parent.*, child.*
FROM table child, table parent
WHERE parent.id = child.parent_id
OR child.parent_id IS NULL;
It is generally better for performance (though a bit more code) to explicitly declare the columns and data types instead of SELECT..INTO. This may be faster:
CREATE TABLE #t2
(
id INT
);
INSERT INTO #t2(id)
VALUES
(
SELECT MAX(id)
FROM t1
WHERE Period <= '01-11-2013' ...
Let me look that one over, you may very well be right
@DaggNabbit fixed and gave you credit :)
I need to remember to use IN when I'm dealing with an array as opposed to a single value
well in languages like C, any time you have some braces, like in a for loop or whatever, all variables declared inside are local to the "block" formed by the braces
At least IMO, this can be solved quite a bit more cleanly than the examples above show. The "trick" to solving the problem efficiently is to produce running products, starting from both the left and the right side of the input array. To keep some of the later code simple, it's easiest to append a...
I want to make a graph from input from a text file in the format:
vertex1 vertex2 cost time
where vertex1 and vertex2 are strings that form an edge and cost and time are the properties of that edge. This information will be used to construct the Graph based on cost. I want to plan out the pro...
I post a similar code previously, but i do some major modifications in code so i am posting it again by deleting the previous question.
I am not too familiar with threads and blocking, so can you please review this code for me?
Using of Future is enough or not?
This code come from here.
Note: ...
@Nobody pastebin.com/ppM7Hhun instead of having a function for each and every shit to update, cant I have one function to update display name, rank, email, etc?
well I am no regular user/expert in php so take this with a grain of salt:
I would set up the update function as explained but make it private and offer all those updateRank/updateDisplayName functions that then call the update function with very controlled input
that way you can make sure the function does not get misused
and you minimize the amount of writing that has to be done
Just use public function update { } bind your input like this maybe.. public function bind($param, $value, $type = null){ if (is_null($type)) { switch (true) { case is_int($value): $type = PDO::PARAM_INT; break; case is_bool($value): $type = PDO::PARAM_BOOL; break; case is_null($value): $type = PDO::PARAM_NULL; break; default: $type = PDO::PARAM_STR; } } $this->stmt->bindValue($param, $value, $type); }`
My objective is to update necessary data using one function instead of having different functions to update different fields. So, I've created one and I think this is not really elegant, efficient or secure. I would seriously like a review if possible.
Key.
$data is an array.
$data[0] =...
My objective is to update necessary data using one function instead of having different functions to update different fields. So, I've created one and I think this is not really elegant, efficient or secure. I would seriously like a review if possible.
Key.
$data is an array.
$data[0] =...
You are vulnerable to SQL Injections. Even when you are using Prepared statements, doing It wrong will kill you.
$sql = "UPDATE users SET " . $data[0] . "=? WHERE username=?";
This makes you exposed to SQL injections because your function is not private. You should not allow "user" access to...
So on the advice of the SO GODS i have decided to start using PDO.
I have run into a bit of a dilemma, binding user input and building a prepared statement is all well and good but what if i need the user input as a variable for a compare?
Can i just create a function to clean the input?
This ...
I recently had a job interview in which they gave me an hour to write some real code. It wasn't a huge amount, probably less than 100 lines. After about 45 minutes, I compiled, ran it, and got it to work. I may have spent 5-10 minutes working out compile errors and a couple minor bugs, but ove...
Creating tags is a privilege that comes with 150 rep.
We have found, through experience, that an explosion of tags is a bad thing on Code Review. Just because you can create a tag, does not mean you should.
Creating tags should be done with significant fore-thought, and probably discussion too:...
I wrote the following that tries to crack a message that was encrypted via a simple caesar cipher through brute force. I'm fairly new to Haskell, so any and all input is appreciated.
Because there are infinite ways that something could have been encrypted, it assumes very simple "offset" encrypti...
After reading a lot about F#, I am today cutting my very first real life F# code and I'd appreciate any feedback on my approach.
I'm writing a simple utility to analyse a log file. The code below represents my approach for identifying sections of the log and representing them in a structure. T...
Other day, I bumped my bookshelf and a coin fell down. This gave me an idea. Is it possible to compute the mass of a coin, based on the sound emitted when it falls?
I think that there should be a way to do it. But how?
Hello I've been designing a game server, where player has inventory, bank, and other features with items.
There are some definitions of what item can be in my game:
Item is either stackable or not stackable.
If item is stackable, item's amount can be up to 100 per stack.
So since each item c...
Ran into the same problem. Thanks for sharing. I had other problems, though. I had to ignore the interface block that carries the colour data around and hard-code a value in the fragment shader for it to display anything at all. I hope I'll understand why further down the line. — broncoAbierto29 mins ago
The program should output this:
_1 _1
_1 0
_1 1
0 _1
0 1
1 _1
1 0
1 1
Currently I have this code:
(4 ~: i.9) # (3 # i:1) ,. 9 $ i:1
But I think it can be better.
It would be interesting to see any other variants.
I'm implementing a login script and I want it to be more secure:
function sec_session_start() {
$session_name = 'sec_session_id'; // Set a custom session name
$secure = SECURE;
// This stops JavaScript being able to access the session id.
$httponly = true;
...
@Phrancis I've driven by there, but never been around at the right time to see any races there. I've also driven by Sonoma Raceway a number of times (on the way to Napa Valley), but (again) never been around at the right time to catch a race.
@CodeX No (but even if I had, I probably wouldn't admit it).
@JerryCoffin haha, im thinking of switching to a framework but really reluctant as i like to know that the code i have is all i need and when you code something yourself its your baby, you know?
@anirudh - Regarding this post, your answer was deleted because it was nothing more than updated code (no actual review). The other user's answer contained some review, but it wasn't entirely a review.
@CodeX I can see the attraction of many languages, even ones I don't care for. PHP, I really can't even understand the attraction. If you really want dollar signs in your variable names, you can use Applesoft.
Let me offer at least a partial answer in regards to MySQL and prepared statements. Someone else can address PHP once your code is cleaner.
You would exec the following code within your MySQL instance. This needs done only once.
-- start creating procs
DELIMITER //
-- username check proc ...
Look at Simon's great answer though.
Someone once said to me, "99% of MySQL users are PHP programmers that don't know what they're doing" and I can't agree more ;-)
@Phrancis I thought it was the other way around (99% of PHP programmers were MySQL users who didn't know what they were doing). I guess those don't contradict though. 99% of them use both and don't know how to program in either one (or anything else).
I just thought I would start a little coding project for my music business... Would any application programmer here be interested in helping? Mostly in creating an interface to interact with a DB
Authentication and keeping information secure is my goal with writing my Authentication class while making sure it is extendable completely as possible over making it usable for anything over just hashing passwords.
I believe I have made it simple as possible to allow it to hold its own as a cla...
Do you think I could post on Programmers with scope of project and ask if someone wants to help? I don't know if that's off-topic or not, nobody seems to know what Programmers is for anyways lol...
I want to make a graph from input from a text file in the format:
vertex1 vertex2 cost time
where vertex1 and vertex2 are strings that form an edge and cost and time are the properties of that edge. This information will be used to construct the Graph based on cost. I want to plan out the pro...
My objective is to update necessary data using one function instead of having different functions to update different fields. So, I've created one and I think this is not really elegant, efficient or secure. I would seriously like a review if possible.
Key.
$data is an array.
$data[0] =...
You are vulnerable to SQL Injections. Even when you are using Prepared statements, doing It wrong will kill you.
$sql = "UPDATE users SET " . $data[0] . "=? WHERE username=?";
This makes you exposed to SQL injections because your function is not private. You should not allow "user" access to...
So on the advice of the SO GODS i have decided to start using PDO.
I have run into a bit of a dilemma, binding user input and building a prepared statement is all well and good but what if i need the user input as a variable for a compare?
Can i just create a function to clean the input?
This ...
Creating tags is a privilege that comes with 150 rep.
We have found, through experience, that an explosion of tags is a bad thing on Code Review. Just because you can create a tag, does not mean you should.
Creating tags should be done with significant fore-thought, and probably discussion too:...
After reading a lot about F#, I am today cutting my very first real life F# code and I'd appreciate any feedback on my approach.
I'm writing a simple utility to analyse a log file. The code below represents my approach for identifying sections of the log and representing them in a structure. T...
Other day, I bumped my bookshelf and a coin fell down. This gave me an idea. Is it possible to compute the mass of a coin, based on the sound emitted when it falls?
I think that there should be a way to do it. But how?
Hello I've been designing a game server, where player has inventory, bank, and other features with items.
There are some definitions of what item can be in my game:
Item is either stackable or not stackable.
If item is stackable, item's amount can be up to 100 per stack.
So since each item c...
I'm implementing a login script and I want it to be more secure:
function sec_session_start() {
$session_name = 'sec_session_id'; // Set a custom session name
$secure = SECURE;
// This stops JavaScript being able to access the session id.
$httponly = true;
...
