CodeIgniter From Scratch: Day 2videos

CodeIgniter From Scratch: Day 2

DiggThis

Continuing on from day 1, today, I’ll teach you five different ways to write select statements for your database. If you haven’t watched the first entry in this video series, don’t worry; each video can function on its own as a single tutorial. Having said that, I highly recommend that you watch each screencast.

Catch Up

Day 2


Related Posts

Add Comment

Discussion 93 Comments

Comment Page 2 of 2 1 2
  1. qwerty says:

    “SELECT title, author, contents FROM data WHERE id = ? AND author = ?”;

    id = primary key. It will NOT find more rows than 1.

  2. binary says:

    simply return $q->result(); makes function getAll() more smaller instead of adding it to another array called $data.

  3. Johan says:

    Hi

    I have a problem with UTF-8 charset. Iam swedish so i use letters as “å, ä, ö”.
    When i connect to my “db” all l”å, ä, ö” cant show. I have tried to search but dont really know what to do. It has been working before i started to use Codeigniter. I´ll tell you i´m a beginner. ;)

    I have tried the “meta tag” with UTF-8 and then all content from the “db” shows correctly but not the regular HTML?

    Any suggestion?

  4. Paul says:

    Thanks for these great tutorials. I’m just starting out with CodeIgniter so this is a great help.
    However, I’m having some trouble with the code in this tutorial.
    At the end of the tutorial when everything is done, I’m getting PHP errors when visiting the endresult through my browser:

    Deprecated: Assigning the return value of new by reference is deprecated in C:\xampp\htdocs\ci_day2\system\codeigniter\Common.php on line 130

    Deprecated: Assigning the return value of new by reference is deprecated in C:\xampp\htdocs\ci_day2\system\codeigniter\Common.php on line 136
    A PHP Error was encountered

    Severity: 8192

    Message: Function set_magic_quotes_runtime() is deprecated

    Filename: codeigniter/CodeIgniter.php

    Line Number: 60
    A PHP Error was encountered

    Severity: 8192

    Message: Assigning the return value of new by reference is deprecated

    Filename: libraries/Loader.php

    Line Number: 255
    A PHP Error was encountered

    Severity: 8192

    Message: Assigning the return value of new by reference is deprecated

    Filename: database/DB.php

    Line Number: 133

    ————–
    Any idea what the problem is? Is CodeIgniter not compatible with my PHP version (5.3.0)?

    • Paul says:

      I checked out the latest version of CodeIgniter via SVN and that solved the problem. It was a compatibility issue with PHP 5.3.0.

      Again, thanks for these awesome tutorials. :)

  5. monika says:

    wow…!!this tutorials is so much worth for CodeIgniter learnes..!!CodeIgniter rocks.

  6. fish mouth says:

    Wicked series Jeffrey, thanks so much

  7. SH says:

    Thank you, it was really helpful.

  8. adelle says:

    Such a Great Thing .. Thanks Jeff

  9. Kit says:

    Wow, binding is way better than typing mysql_real_escape_string() over and over.

  10. emcgfx says:

    Direct Link to the video:

    Day 2: Database Selecting Methods
    http://a-mirror.video2.blip.tv/NETTUTS-CIDay2743.flv

  11. Jeffrey Way says:

    Vacation. Going over all tutorial submissions today. :)

  12. Yoosuf says:

    yeah its named as CI:Dat 2

  13. Nate says:

    What? VACATION? Good gawd. *sigh*

    *mumbles*….vacation….

    :P

Comment Page 2 of 2 1 2

Add a Comment