logs archiveIRC Archive / Freenode / #php / 2015 / September / 18 / 1
morfin
and it is time finally learn GIT
mchelen1
<3 git
morfin
because most jobs explicitly say - you SHOULD know GIT
mchelen1
they do, but then i find out for many people that means git add, git commit, git push
as soon as you start talking with them about branches and merges, they are lost
larsi
anyone know if using prepared statements with php and having a special character in the column name causes issues?
Unknown column 'lagt på' in 'field list'
which is exactly the column name in the table
must be
doesn't report on any other column
Br0totype
Thanks all for the Memory Leak discussion. I'll be back later <3
larsi
ok, so after removing special chars from the columns the record is added
anyone know why?
Bad_Advice_Cat
larsi, you might've not set charset and collations properly.
larsi
most likely
not sure what it uses by default
         

Bad_Advice_Cat
å might as well be a letter R to the computer, if it can't understand WTF that is.
Then you should check and find out what it uses.
(Action) wonders what larsi's PDO connect code looks like.
larsi
all it contains is the host, username, password and db
guess I'll pass the charset as well
Bad_Advice_Cat
larsi, always do.
Is it mysql/mariadb by any chance?
larsi
mysql
Bad_Advice_Cat
Hehehe, okay. - Yeah be sure that charset is set.
larsi, try utf8mb4
larsi
thanks
utf8mb4?
I put utf8 only and it accepted it
I guess utf8mb4 is the 'real' utf8?
(in mysql at least)
Bad_Advice_Cat
larsi, that's 4byte UTF-8 in MySQL.
"UTF-8" in MySQL is actually "3byte UTF8".
(deceptive? Yeah...)
larsi, yes.
larsi, though there is some gotchas for using utf8mb4 (it's a good idea to look it up. )
morfin
what? why?
how it can be 3byte UTF8?
larsi
apparently mysql can only store utf8 encoded symbols that consists of 1-3 bytes
(well, the utf8 charset)
https://mathiasbynens.be/notes/mysql-utf8mb4
Bad_Advice_Cat
larsi, this message basically sums it up: https://github.com/vanilla/vanilla/issues/2082 -- The limitation of key size on InnoDB (Though that can be fixed by changing 2 settings)
YES!!!!! PHP 7.0.0 RC3 :D
mbrzuzy
yolo
graffix_
anyone here know anything about ispconfig?
JD-Robbs
Half-way through RC ;-)
morfin
maybe not 100% related to PHP question but should i put my class in namespace VendorName/PackageName?
JesseH
So I wrote pong in PHP. https://github.com/jessehorne/ponghp/ :P
Tylak
can we play it?
JesseH
Tylak, Yes. Beware though, I'm a PHP beginner, so the code is horrible.
__adrian
morfin it's generally a good idea, if your code might ever be mixed with code someone else wrote
TML
morfin: Only if you think you're going to be a "Vendor" with multiple "packages" that each need a distinct namespace
JesseH
But just clone that, install the things it says you need, and then run RunGame.sh if you're on linux.
         

morfin
probablyu
JesseH
Tylak, If you run into any issues, which you might, let me know.
morfin
and then i just include vendor/autoload.php and that's all?
i mean if i install via Composer
iio7
Is there any difference between using bindParam(':price' or bindParam('price', without the semi colon?
TML
PDO?
iio7
I have gotten my hands on a class in which some binds are with and some without.
TML
iio7: Are you using PDO?
iio7
TML, what do you mean by just typing "PDO?"?
Yes.
TML
No difference
but consistency is a good thing
iio7
So that's why both are working. Hmm. Are one of them the recommended way?
TML
Not really. Just be consistent.
I prefer not typing them
iio7
Ok, thanks.
jangoh
#javascript
wrong window
iio7
:)
AcidReign
jangoh: thats a terrible password :p
TML
I don't know - I wouldn't have ever guessed it
jangoh
actually it was /join #javascript :p
TML
see, even HARDER to guess
larsi
I was going to make a joke about being hard but...
laszlof
anyone bored and wanna debug a test for me? ;)
__adrian
not that bored :)
whatcha working on
laszlof
joomla stuff
I think the API is broken
actually, it worked with curl... so i dunno
https://github.com/laszlof/twitter-api
run phpunit against that and you'll see what i mean
theso whatever data its getting back is not valid json
__adrian
it's not mocking properly for me
cferry
sup guys
__adrian
from twitter, you're not getting valid json?
laszlof
trying to track that down now
__adrian
hi cferry
laszlof
im getting a null response
cferry
hello __adrian !
__adrian
well, null ` false.
>_<
laszlof
haha
wtf.. its not even hitting sendRequest
__adrian
you said it works over curl?
laszlof
yes, something else is wrong
__adrian
ah, you have some other thing then
« prev 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 next »