Logo
  • PHP
    • HipHop / HHVM
    • Modern PHP
    • PHPStorm
    • LAMP
    • Laravel
    • Composer
    • PDO
  • JavaScript
    • node.js
    • AngularJS
  • CSS
    • SASS
    • “CSS4” (CSS level 4)
  • HTML
  • Git
  • LAMP
  • Vagrant
  • UI / UX
  • Architecture of …
  • Off-Topic
With ♥ from Berlin
February 4, 2014
Chris
PHP
Comments Off on [Link] How to create, read, update and delete (CRUD) with PDO, MySQLi and MySQL the right way (prepared statements)

[Link] How to create, read, update and delete (CRUD) with PDO, MySQLi and MySQL the right way (prepared statements)

PreviousNext
php

Mike Dalisay has written an excellent tutorial on the CORRECT USAGE of basic CRUD functions (create, read, update, delete) with PDO, mysqli and mysql. Please note that basic pure mysql_ functions are outdated for some years now and should be avoided! Only bloody amateurs use mysql_. This is an very valueable tutorial if you want to start with PDO (the correct way to do database requests!) or want to have a look on how to use mysqli correctly (using prepared statements). Take the time to read through this, it’s essential stuff for your daily work.

7-php-crud-update-record-listed

The tutorials contains videos, screenshots, copy&paste code examples and a really really good explaination.

Mike Dalisay – PHP and MySQL CRUD Tutorial for Beginners

 

cruddatabaseMySQLmysqlipdoPHP
Share this
php

PHP 5.6.0 RC1 is available

The first Release Candidate of PHP 5.6 is available here on php.net, as usual also for Windows systems. The RC

Material Design – How Google designed Android L (7min video)

A very interesting insight into Android L’s (= Android 5.0) new design and the ideas behind. Android was always #3

php

Redesigning the PHP logo – who wants ?

The current PHP logo is a really lovely one, it is highly accepted and has its own charme, transports a

What’s new in PHPStorm 9

PHPStorm 9 has just been released a few days ago, and as a PHP developer you should definitly give it

-45% (or even 50%) off on DesignWall today

Get 45% off on DesignWall.com with this coupon code: AMTHUNTER45 It’s also possible to get off 50% by taking part

How to hack time (KUNG FURY promo campaign)

:) Finally, KUNG FURY is out! No need for further words, unless you lived in a cave for the last

october cms

October CMS, built on top of Laravel, is beautiful, clever and on the way to be the new #1 CMS

Do you remember when you tried to edit one line of code inside TYPO3 or Contao ? And the extreme

Frontend Ops Conf 2014 – Keynote by Alex Sexton: “Front End Operations”

https://www.youtube.com/watch?v=7HGe8zZ1G6k

java vs php

Switching from Java to PHP. Seriously. A very interesting and pre-judice-free talk with Ph.D. Aris Zakinthinos

Ph.D. Aris Zakinthinos, CTO of achievers.com, a well-scalability-experienced guy and former IT employee of the military, has just delivered one

phpstorm 7.0 php

How to install GitHub’s, NetBeans’s and Sublime2’s syntax highlighting code colours theme in PHPStorm 6/7

PHPStorm’s default code colouring might not be what you want, especially when you just switched from NetBeans. But there are

1/4

Categories

Search

php uk conference
Profiling PHP Applications by Bastian Hofmann (video from PHP UK Conference 2014)
DigitalOcean coupon voucher 50
Only today: $50 coupon for DigitalOcean SSD VPS / hosting
How to fix the ugly font rendering in Google Chrome
php
Is there a JSFiddle for PHP ? Yes !
-45% (or even 50%) off on DesignWall today
sass laravel
SASSmeister is a real-time JSfiddle for SASS / CSS. Awesome!
hiphop php
Vote for “Hack” for HipHop/HHMV support (future style PHP) in PHPStorm 8
phpstorm-8
Killer-feature in PHPStorm: Search everywhere
css3-chrome-font
[Link] Retinafy your Site / Device by Nijiko Yonskai
vagrant
How to copy Vagrant boxes (or duplicate them)
shadow dom
A quick video introduction into Shadow-DOM, the game-changing DOM-subtree-technology
Redesigning Windows 8 – fantastic and clever drafts by Jay Machalani
photoshop-cc-deal
Adobe offers Photoshop for $9.99 per month (limited deal)
Compare 250+ cloud server plans with Cloud Cost Calculator
mod-rewrite-ubuntu-14-04-lts
How to install / setup PHP 5.5.x on Ubuntu 12.04 LTS

Tags

apache bash centos composer conference coupon CSS debian fonts framework git GitHub hack HHVM HipHop HTML HTML5 IDE JavaScript JS LAMP laravel linux mod_rewrite MVC MySQL Nginx optimization PHP PHP 5.5 PHP 5.6 phpmyadmin PHPStorm security server SSD Ubuntu UI UX vagrant video virtual machine voucher VPS wordpress
Side-Project: Wordle-Solver:
www.wordle-helper.info

Pages

  • Privacy Policy