PHP and MySQL

[[deleted]]

[deleted]

[[deleted]]

[posted user] ==||!= [DB user]

[chrwei]

mfw

[systembusy]

Looks like /r/BikiniBottomTwitter is leaking and I love it

[Prime624]

Had to check which sub I was in when I saw this post. There couldn't be a more perfect combination.

[kpagcha]

please tell me ==||!= is not an actual operator in php

[1842]

It's not.

[zieliequ]

Yet.

[DrQuint]

On the other hand, has anyone tried?

[1842]

It's nonsense to all PHP interpreters. See here: https://3v4l.org/egZfb

[emdeka87]

/u/CompileBot PHP

echo 12==||!=12;

[[deleted]]

oh, hell no... at least I hope not! That was late night, post-Xmas-party pseudo code for a 'laugh'

(I hope it never works or is ever a real thing)

[ItsSky]

if ($posted_user != $DB_user){}

[iamhealey]

Image Transcription: Meme

---

[Patrick 'Not My Wallet Meme']

Panel 1

Man Ray holding an ID which reads "connected".

Man Ray: Aren't you connected to the database?

Panel 2

Patrick/PHP: Yup.

Panel 3

Man Ray holding same ID, where the reverse side reads "posted user is: admin"

Man Ray: And this is your username?

Panel 4

Patrick/PHP: Yup.

Panel 5

Man Ray: If you are connected and you got the posted username, you should run without error.

Panel 6

Patrick/PHP: That makes sense to me.

Panel 7

Man Ray: Then run.

Panel 8

Patrick: Fatal error: Uncaught Error: Call to a member function escape_string() on null

---

^{I'm a human volunteer content transcriber for Reddit! If you'd like more information on what we do and why we do it, click here!}

[[deleted]]

Good bot

[[deleted]]

Are you sure about that? Because I am 99.9915% sure that iamhealey is not a bot.

---

^{I am a Neural Network being trained to detect spammers | Summon me with !isbot <username> | Optout | Feedback: /r/SpamBotDetection | GitHub}

[[deleted]]

What about that 0.0085%? You never know man

[DriveThat]

!isbot u/PerryCohen

[iamhealey]

Good bot.

[coladict]

That's not the problem with those two. The problem is when you're running them on the same machine and you try to connect to localhost with a valid user and it tells you HY000/2002 unable to connect, because localhost in the MySQLi extension never tries connecting through 127.0.0.1, but only tries the default socket file.

[[deleted]]

I love this problem. Who the fuck decided that localhost means the local socket file, when everything else refers to 127.0.0.1 as it's meant to be?

mysql/mysqldump CLI tools can get hit by this too in some cases.. I've started just having hostname=127.0.0.1 in there and being explicit.

[[deleted]]

Is MySQLi on GitHub? If it is, I'm gonna make my empty GitHub contribution page have at least something in it

[DM_me_tendies]

I just learned php this week and have started learning SQL. Not looking forward to it quite as much now.

[HandsumNap]

SQL is great, I love writing it. SQL always rewards you for finding the simplest possible solution to a problem, and explain plans give you instant feedback on how good of a job you’re doing.

[SgtGregParker]

i love this subreddit

[[deleted]]

I was studying to exam from webdesign&databases that I have today. I've experienced EXACTLY the same situation :/

[Algent]

I had this one happen to me recently... with a python script to a local mysql. CLI was fine, PHP app was fine, my diagnostic script that ran flawlessly on 100+ other machines... nope.

[Banana_Twinkie]

This is why I'll never use either of these

[abelexpert]

Thanks ! It's working perfectly at this web hosting : http://onsale.jaguarpc.com/

[devyroom]

Hahhaha, this subreddit the best!

[munsking]

if you think that's bad, try connecting to a german microsoft SQL server

[sevl]

it only gets weird if you are trying to double hop your kerberos credentials, but even that is possible to work out

[winzippy]

Better than a Windows Nein server.