Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - CJ Jackson
136
Off-topic / Re: Windows XP End Of Support Countdown Gadget
« on May 13th, 2011, 09:32 PM »
Hard to be sure really, according to the the overview it's mentions "Looking to get off Windows XP?", I pretty much find the question ambiguous.  It could mean a XP user looking to get off XP or what you said, did you really need to be specific about Win 7 editions?  :D

Even XP Home Edition is still supported to 2014.
137
Off-topic / Windows XP End Of Support Countdown Gadget
« on May 13th, 2011, 07:45 PM »
Windows XP End Of Support Countdown Gadget,

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=53a27766-0168-4617-b44e-74b2886cec6d&pf=true

Oh, you might want to have a look at the system requirements! What can I say it's a Gadget!  :lol:
138
Other software / Re: SMF 2.0 final THIS MONTH?
« on May 10th, 2011, 05:49 PM »
would a laughing matter? I think you mean "was a laughing matter or not"  :D
139
Features: Forward thinking / Re: MySQL only!
« on May 8th, 2011, 01:01 AM »
Quote from Arantor on May 7th, 2011, 10:27 PM
Except that you still have the issue of platform specific queries, because PDO doesn't rewrite queries.
I agree, it's does not rewrite queries, only a full blown database abstraction layer can do that, such as doctrine (it's built on top of PDO).  PDO is only a database access layer, not an abstraction layer.

My intention was only to post the main different between MySQL and MySQLi, as Nao and Arantor never used MySQLi.
140
Features: Forward thinking / Re: MySQL only!
« on May 7th, 2011, 02:27 PM »
I understood   :thanks:  :lol:
141
Features: Forward thinking / Re: MySQL only!
« on May 7th, 2011, 01:26 PM »
I have used MySQLi_* before, the biggest advantage over MySQL_* is prepared statement

Code: [Select]
$prepare = $mysqli->prepare('INSERT INTO people (name, address, postcode) VALUES (?, ?, ?)'); // '?' specifies param
$prepare->bind_param('sss', $name, $address, $postcode); // The first param has to be string, which specifies the data type, the letter 's' is obvious.
$prepare->execute();

The great thing about prepared statement is that you don't need to sensitize the data input that done automatically.  PDO_MYSQL has better support for prepared statement.

Code: [Select]
$prepare = $pdo->prepare('INSERT INTO people (name, address, postcode) VALUES (:name, :address, :postcode)');
$param = array(
':name' => $name,
':address' => $address,
':postcode' => $postcode
);
$prepare->execute($param);

With PDO you can use named parameters and you don't need to specifies data types that done automatically.  Prepared statement is the way forward.  I like to see someone try to pull off a SQL injection with prepared statement.

I would stick with the MySQL software, mainly because of dialect different in SQL in other SQL software.  I used Oracle at Uni, it wouldn't let me insert multiple rows via 'INSERT' statement only one row is allowed per 'INSERT'.
142
Off-topic / Re: Wedge official shirt?
« on April 30th, 2011, 11:14 AM »
Quote from Arantor on April 30th, 2011, 01:45 AM
Basically, it's a special paper that you feed through your printer, you print the image in reverse, then iron it on to a plain t-shirt.
Do they work with laser jet printers?  :)
Posted: April 30th, 2011, 11:13 AM
Quote from MultiformeIngegno on April 30th, 2011, 10:38 AM
Inkscape is the way! :D
For hobbyist I agree, for employment Adobe Illustrator, sadly.
143
Plugins / Re: Plugin hooks
« on April 20th, 2011, 12:49 AM »
Quote from Nao/Gilles on April 19th, 2011, 05:19 PM
I will only resort to libel, slander and vilification to get someone out of my way. That's who I am. 8-)
Isn't defamation the SMF team ways as well? Didn't they use defamation to get you out of their way?  :D

I am aware that truth is an excuse for defamation, but lies are not.  I know you don't lie.  ;)
144
Off-topic / Re: Re: [FAQ] How can I become a friend?
« on April 18th, 2011, 11:17 PM »
The Inbetweeners | Jay's Friend | Series 1 - Episode 4 (The video's owner prevents external embedding)

:eheh:

EDIT: damn you video owner, DAMN YOU!
145
Off-topic / Re: Strange behavior from WAMP server...
« on April 15th, 2011, 01:05 AM »
Apache from the official site is complied with VC6 and can be unstable for that reason especially with XP sp3 and above, I have had problem with that myself keeps crashing now and then.

You can try downloading the one from Apache Lounge as those binaries are compiled with VC9 which has better performance, stability and memory management, never had any problem with it.

http://www.apachelounge.com/download/

Use PHP 5.3 because that compiled with VC9, also use mod_fastcgi instead of mod_php, it's more matured and stable.

http://windows.php.net/download/
146
Off-topic / Re: Spambots
« on April 14th, 2011, 09:55 PM »
but not all smartphones, right? ;)
147
Off-topic / Re: Spambots
« on April 14th, 2011, 09:29 PM »
I know many spambot can read javascript, but how many of them can execute javascript?
148
Off-topic / Re: Post count fever
« on April 14th, 2011, 04:51 PM »
What a lotta of....... plus 1's
149
Off-topic / Re: Spam
« on April 14th, 2011, 04:12 PM »

Weird Al Yankovic- Spam
150
Off-topic / Re: Texasmans Programming Blog
« on April 14th, 2011, 12:18 AM »
Quote from Nao/Gilles on April 13th, 2011, 11:58 PM
Their fries are tiny and bland... They're only edible when adding lots of salt.
That reminds me of KFC, their chips are also bland, except they are thick, let me guess those fries your talking about taste like cardboard right.  :lol:

This thread started off has a flame war and now we are talking about food.  :lol: