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

Meet the developers behind Ableton (14min video)

An excellent short documentation about the developers behind Ableton, the legendary creators of Ableton Live and Push. Without doubt, Live

sass laravel

Extremely easy SASS in Laravel (with pure PHP)

Working with SASS is awesome: it reduces your workload dramatically, makes web projects much cleaner, DRYs your code, adds awesome

Support FLARUM, the future of PHP forum scripts (with some dollars on Kickstarter)

PHP forum scripts are horrible, let’s face it. Nearly everything that’s available is hard to install, hard to handle, hard

php uk conference

Slides & talks from PHP UK Conference 2014

The slides of most of PHP UK CONFERENCE 2014‘s talks are online, very interesting stuff, have a look. And a

php

Why Modern PHP is Awesome And How You Can Use It Today (Slides by Matt Stauffer)

Useful basic linux stuff: Show kernel version, distribution name and distribution version on Ubuntu systems

Always nice to know: Show kernel version: uname -r Show kernel version and CPU: uname -a Show distribution version: lsb_release

Berlin, prepare for TOA conference (15th – 17th of July)

If you are in Berlin right now (and have 80-300 € to spend and 2-3 days of holidays (or “spontanious

mod-rewrite-ubuntu-14-04-lts

How to enable mod_rewrite in Ubuntu 14.04 LTS

A little note first: This is the most basic way to enable mod_rewrite. However, it’s not the best way. The

php

Test out PHP 5.6alpha1 on Windows 7 / 8 with two clicks

The popular Apache-MySQLP-PHP stack EasyPHP has become very professional, maintained and especially modularized in the last 2 years, and when

html6

Is this the first HTML6 specification?

  I just found this very interesting “project” including an active, but unpopular GitHub repo: http://html6spec.com/ https://github.com/OscarGodson/HTML6 Looks like these

1/4

Categories

Search

phpstorm 7.0 php
A perfect video tutorial to get started with xdebug in PHPStorm
css4
Angelina Fabbro talks about “CSS4” in this excellent conference video
What’s new in PHPStorm 9
Interesting stats on SONY’s hacked passwords
vagrant
How to copy Vagrant boxes (or duplicate them)
[Link] Making a website vertically responsive
Quick fix for 404 error in WordPress category / tag page
Redesigning Windows 8 – fantastic and clever drafts by Jay Machalani
phpstorm-github-code-color-syntax-theme
Get Github’s syntax highlighting colors in PHPStorm
The New Era of JavaScript (28min conference talk, Jack Franklin, 2013)
hiphop php
PHP’s HipHop outperforms PHP 5.5 with Zend OPCache and Nginx by 15-20 times
O’Reilly’s Programming JavaScript Applications by Eric Elliott for free (Early Access release)
github-logo-octocat
GitHub rolls out .PSD diff and viewing
Frontend Ops Conf 2014 – Keynote by Alex Sexton: “Front End Operations”
Microsoft announces “holographic” 3D interfaces (promo video)

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