Chapters

12 Chapters | 45:36 |

01

How to Speak Database

4:20
02

Queries, Databases and Tables: Oh My!

4:57
03

INSERTing and SELECTing Data

2:35
04

Updating, Deleting and Putting it All Together

4:21
05

Talking to Databases in PHP

2:35
06

Object-Oriented Intro: Classes and Objects

3:23
07

Centralized Configuration

4:22
08

Limiting the Number of Results

2:44
09

Optional Function Arguments

3:37
10

Using Query Parameters

3:34
11

Querying for One Pet

3:04
12

Preventing SQL Injection Attacks with Prepared Statements

6:04

> PHP > Course 3: Talking to a MySQL Database in PHP

Buy Access to Course

05.

Talking to Databases in PHP

|

Autoplay

Keep on Learning!

If you liked what you've learned so far, dive in! Subscribe to get
access to this tutorial plus video, code and script downloads.

Start your All-Access Pass

Buy just this tutorial for $12.00

Previous Challenge

Next Chapter

Script
Comments

Login or register to check out the script

15 Comments

Sort By

Login or Register to join the conversation

Lucio S. 7 years ago

I'm not using xampp to go through these examples. Just thought I'd point out that I had to change 'host=localhost' in the PHP code to 'host=127.0.0.1' in order to get this to work. Loving the tutorials though ;)

1 |

weaverryan SFCASTS Lucio S. 7 years ago edited

Hey Lucio S.!

Good tip! 127.0.0.1 is probably better anyways - that's your REAL local IP address. Most systems also allow "localhost" as a sort of alias to 127.0.0.1... but as you proved, 127.0.0.1 is more portable because it *always* works :).

Cheers!

1 |

Ricardo-T 1 year ago

Hi,

Where to download the project?

Regards,
Ricardo

|

Victor SFCASTS Ricardo-T 1 year ago

Hey Ricardo,

You can download the project code for the current tutorial on any chapter page, e.g. on the one where you asked your question: https://symfonycasts.com/screencast/php-ep3/php-talks-to-mysql

See the "Download" -> "Course Code" button in the right top corner of this page. This specific course is paid, so you need to own this course or being an active subscriber on SymfonyCasts to download it.

Cheers!

|

Mahmut-A 2 years ago edited

Hi,

When I use PDO module, I. am receiving below error in my web server error_log. I am trying to add this extension PDO module but still having problem.
Have you seen this problem before?

Sun Jan 07 03:27:23.451080 2024] [php:error] [pid 1142] [client 10.212.134.200:55480] PHP Fatal error: Uncaught Error: Class "PDO" not found in /var/www/html/code-php-ep2/start/index.php:3\nStack trace:\n#0 {main}\n thrown in /var/www/html/code-php-ep2/start/index.php on line 3

|

Mahmut-A Mahmut-A 2 years ago edited

Hi again,

After searching google, I understand that pdo_mysql module is missing. I installed by yum install php-pdo_mysql and checked with php -m, then restart httpd server. now working.

Additionally, could you please help me to show output of db in nice way? I see as below.

array(3) { [0]=> array(6) { ["id"]=> int(1) [0]=> int(1) ["name"]=> string(10) "Chew Barka" [1]=> string(10) "Chew Barka" ["breed"]=> string(6) "Bichon" [2]=> string(6) "Bichon" } [1]=> array(6) { ["id"]=> int(2) [0]=> int(2) ["name"]=> string(9) "Spark Pug" [1]=> string(9) "Spark Pug" ["breed"]=> string(3) "PUG" [2]=> string(3) "PUG" } [2]=> array(6) { ["id"]=> int(3) [0]=> int(3) ["name"]=> string(12) "Pico de Gato" [1]=> string(12) "Pico de Gato" ["breed"]=> NULL [2]=> NULL } }

1 |

Victor SFCASTS Mahmut-A 2 years ago

Hey Mahmut,

Yes, exactly! Good catch :) You need to install and enable. that pdo_msql, thanks for sharing it with others!

Additionally, could you please help me to show output of db in nice way? I see as below.

What do you mean?

If you want a nice debug styles - you can leverage Symfony VarDumper component, use dump() or dd() to make the debug output nicer :)

Cheers!

|

Mahmut-A Victor 2 years ago

actually, when I use var_dump(), it outputs in one line all array. In video, it is shown line per line. How can I enable it on my browser.
for json output, I am using JSONVue.

|

weaverryan SFCASTS Mahmut-A 2 years ago

Hey @Mahmut-A!

I think I know the problem :). There is a PHP extension called "XDebug". If you have this installed, then var_dump() will output in the fancier way that you see in the video. I bet this is what you need to match the video output you see.

Cheers!

1 |

Mahmut-A weaverryan 2 years ago

thank you so much. worked

|

CloudCreators 5 years ago

PHP Fatal error: Uncaught PDOException: could not find driver in /Users/shubham/AirPup/index.php:2
Stack trace:
#0 /Users/shubham/AirPup/index.php(2): PDO->__construct('mysql : dbname=...', 'root', 'Titanic@123')
#1 {main}
thrown in /Users/shubham/AirPup/index.php on line 2
[Sat Jul 3 18:50:40 2021] [::1]:58302 [500]: / - Uncaught PDOException: could not find driver in /Users/shubham/AirPup/index.php:2
Stack trace:
#0 /Users/shubham/AirPup/index.php(2): PDO->__construct('mysql : dbname=...', 'root', 'Titanic@123')
#1 {main}
thrown in /Users/shubham/AirPup/index.php on line 2

I am stuck at this, I dont have server installed on my mac but why this PDO line is creating such errors I have the pdo_mysql module in my php

|

Victor SFCASTS CloudCreators 5 years ago

Hey Shubham,

Hm, please, make sure your DB credentials are correct first and you didn't make any typos in it. If everything looks good, try to restart the server, I'd recommend you to restart your laptop just in case and try again. The error really sounds like you don't have pdo_mysql module, maybe if you started the server and installed it after - the already running server does not see it, so you have to restart.

If you're still experiencing this error even after laptop restart - please, share a bit more information, what do you do to see this error? Do you run it in your terminal? What command? What OS do you use?

I hope this helps!

Cheers!

Cheers!

|

skipper-henrik 5 years ago

hey,
we didn't talked about the object-operator -> yet. Did we?? Would be nice to introduce that...

happy I found https://stackoverflow.com/questions/3037526/where-do-we-use-the-object-operator-in-php

Aha, there is also a scope operator :: hm, hm ...

|

weaverryan SFCASTS skipper-henrik 5 years ago edited

Hey eltnap !

Ah, you're right! We talk about that in the NEXT chapter - https://symfonycasts.com/sc... - so I was just a minute too early! I think I wanted to get some "database query" success before we dove into some object-oriented stuff. So, while we "touch" on the object-oriented stuff in this tutorial, we have a few other proper tutorials on that topic - https://symfonycasts.com/sc...

From an object-oriented perspective, the -> operator is use to call a method on an instance of an object. The :: is used to call a static method on a class. We actually don't talk at all about static methods until episode 4 of our object oriented series - https://symfonycasts.com/sc... - in part because they "should be" rarely used (using objects typically will lead you to better code) and so I only wanted to introduce them later.

Anyways, I probably just dumped more details than you needed - but let me know if this is helpful or if you have any other questions :).

Cheers!

|

skipper-henrik weaverryan 5 years ago

Thank You Ryan.
And Sorry. Five minutes after my post I was taught not to be too fast in wondering....
Stay save and happy holidays to all of the team!

|

Previous Challenge

Next Chapter