ST Alpha - "So ... while paralyzed by database interaction choices last night, I definitely learned one thing." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 153

So ... while paralyzed by database interaction choices last night, I definitely learned one thing.

Posted by Beryllium (aka grayman) Sep 26 '13, 08:22

(What I already knew:)

There are three types of MySQL database access baked into PHP. A library of functions called "mysql_*" (they are outdated & dangerous), a library of functions/objects called "mysqli_*" (they are less-outdated and slightly safer), and "PDO", which is pretty powerful and allows you to abstract database access stuff.

(What I learned)
mysqli_* prepared statements are *ass*. When writing an update query in a prepared statement, it looks like this:

UPDATE tablename SET columnname = ? WHERE id = ?;

And then you have to replace the question marks using a call like this (if the id is "5", for example):

$query->bindParams('sd', [ 'NewColumnValue', 5] );
$query->execute();

Doing it with PDO was much nicer:

UPDATE tablename SET columnname = :columnvalue WHERE id = :row_id;

and

$stmt->execute(['columnvalue'=>'NewColumnValue','row_id'=>5]);

The ability to name columns like that is so much easier to maintain, especially in complicated queries.

Responses:

For comparison, this is how DB2 has always worked. If I had been anywhere they used anything except PDO, I would have had to choke a bitch. -- nm - GregW Sep 26, 09:30
This post looks better when viewed on the beta site, FWIW -- (link) - Beryllium Sep 26, 08:24 [Backboard] 17
- I'm not crazy about the general look of the beta site fwiw. -- nm - Don Homer Sep 26, 08:29 15
  - word -- nm - Spawn Sep 26, 08:29
  - Neither am I. I like the responsive behaviour on mobile, but overall it's ... blah -- nm - Beryllium Sep 26, 08:29 13
    - It needs even more orange. - Spawn Sep 26, 08:30 12
      - and bats!....nm - x Sep 26, 08:31 10
        
        I want bats that follow the cursor. But if you click on them, something bd happens. So you have to shake them before clicking on a post. - Spawn Sep 26, 08:34
        
        [deleted] 8
        
        *that* may be the one thing everyone agrees on. bats. -- nm - Andie Sep 26, 08:37 7
        
        And I want one for my avatar, too. -- nm - Spawn Sep 26, 08:39
        
        [deleted] 5
        
        I promise nothing. But I am curious. -- nm - Beryllium Sep 26, 08:41 4
        
        Bat-curious? -- nm - mara Sep 26, 08:44 3
        
        [deleted]
        
        Golly Gee, Batman ... I don't know about this .. -- nm - Dick Grayson si Sep 26, 08:45 1
        
        Heh -- nm - mara Sep 26, 08:47
      - heheh. Well, the way threading is displayed and the way posts are displayed ... both need *serious* help. - Beryllium Sep 26, 08:31
- ack! it's....weird! -- nm - oblique Sep 26, 08:28

Post a message top

So ... while paralyzed by database interaction choices last night, I definitely learned one thing.

Replies are disabled on threads older than 7 days.