| Judul | : | PHP MySQL Tutorial |
| info | : | Get the Code Here : http://goo.gl/Aocylf PHP Tutorial : https://www.youtube.com/watch?v=7TF00hJI78Y MySQL Tutorial : https://www.youtube.com/watch?v=yPu6qV5byu4 Previously I covered the vast majority of both PHP and MySQL in 2 videos. This time I decided to bridge the gap and show how to simply grab data from and edit data in a MySQL database using PHP. We specifically cover creating users with limited access for security reasons, setting up secure database connections, pulling data from a database, adding data to the database and prepared statements. |
| Upload | : | 05 September 2014 |
| Putar | : | PC | 3GP High | 3GP Low |
| Uploader | : | derekbanas |
| Durasi | : | 19:22 |
| Source | : | Www.YouTube.Com |
Comment
- Derek Banas - I cover creating secure users, secure database connections, pulling data from a database, adding data to the database and prepared statements
- Notorious Canadian - i just started learning database, i'm learning DB2 and SQL right now in college i was wondering are there any videos on that? Like Using SQL to create & modify tables in DB2 database? Thank you!
- Andrej Batarilo - Awesome tutorial, good job!
- Kerim Madison - Derek what's up? When we use MySQL database in our website, on Local servers we have a bunch of folders and files that might operate all MySQL Database and Server-Side PHP process. OK But how is it on Remote/Online servers like Hostgator? And will MySQL database file work without its folders and files. And some people place their database file to outside of public_html folder, does its location also matter?
- Honjudd - Im trying to echo the query results into divs and style them like I do in HTML using a CSS file, is that even possible? Im assigning ids to the divs but cant get the CSS file to recognize them.
- Theodore Quentin Evelyn- Rahr - Great video, thank you very much for making it.
- yamspaine - :) Postgres is probably similar.. Shouldn't we be using that instead of MySQL? Nice show, good editing. The security stuff is important enough to cover while introducing the topic. ignorance is bliss followed by site p0wnage and much sorrow. Also it is a bad practice to copy and paste the same code, why not just call the page that you already wrote. (I thought you were going to do this)
- Arthur Siloka - I keep getting the Error Occurred. how do I get around that?
Jennifer Kroll - Well Hello Derek! Great tut! I've been working with it for a few days and adapted it slightly, however I'm having a problem binding my parameters (I think). While I've checked extensively over the past day or so to make sure everything else is working correctly, I've come to find that when querying the db to insert data, there seems to be a problem with the question marks as place holders for the VALUES that will be inserted by the bind parameter statement i.e "INSERT INTO XNATusers (first_name, last_name, email, PI_lastname, lab, date_registered, user_id) VALUES (?, ?, ?, ?, ?, NOW(), NULL)"; ....The cool thing is if I place the question marks in quotes, it will write to my db as actual question marks lol. I checked the variables that should be binded by the bind parameter statement i.e $f_name, $l_name etc and they are passing and storing the correct values but affected rows always returns 0 in this case. Here is a snip of my code: Can you (or any one else) see what might be going wrong here? It's driving me crazy!! (Also, my table has been set up correctly in mysql) Thanks so much :).
$query = "INSERT INTO XNATusers (first_name, last_name, email, PI_lastname, lab, date_registered, user_id) VALUES (?, ?, ?, ?, ?, NOW(), NULL)"; /*when I put question marks in quotes, it DOES insert into db as ?????*/ $stmt = mysqli_prepare($dbc, $query); echo $f_name; echo $l_name; echo $email; /* <-- all of these variables pass and have correct values*/ echo $pi_last; echo $lab; /*Seems good up to this point*/ mysqli_stmt_bind_param($stmt, "ssssssd", $f_name, $l_name, $email, $pi_last, $lab); mysqli_stmt_execute($stmt); $affected_rows = mysqli_stmt_affected_rows($stmt);
- Angelina Jolie - Hi Derek ! Could you talk about how and where images and videos are stored inside databases or servers and how are they retrieved? Maybe an android tutorial about retrieving images and videos from a custom database or server? Thanks In Advance !
- Kevin The Bull - is is possible to turn these pages into functions in one PHP file, then reference the functions instead of the separate file addresses? I am having trouble putting this system to work on my wordpress site.
- Alex Wetton - I have my PHP working and when I try to run getstudentinfo.php I get the error: Parse error: syntax error, unexpected '$query' (T_VARIABLE) in /Applications/MAMP/htdocs/howdy/getstudentinfo.php on line 5 My line 5 is: $query = "SELECT id, email_banned, created_on, notes, FROM banned_emails"; Id, banned_emails, created_on and notes are columns in my SQL table. Banned_emails is the table name Thanks :)
KJ Sudarshan - Hi Derek, i have used the same code as yours but i get this error :(
Connected successfully Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given in C:\xampp\htdocs\vehicleadded.php on line 152
Warning: mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt, boolean given in C:\xampp\htdocs\vehicleadded.php on line 154
Warning: mysqli_stmt_affected_rows() expects parameter 1 to be mysqli_stmt, boolean given in C:\xampp\htdocs\vehicleadded.php on line 156 Error Occurred
Warning: mysqli_error() expects exactly 1 parameter, 0 given in C:\xampp\htdocs\vehicleadded.php on line 169
Warning: mysqli_stmt_close() expects parameter 1 to be mysqli_stmt, boolean given in C:\xampp\htdocs\vehicleadded.php on line 171
Please help :).
- Beat Toedtli - wayyy too fast...
- Qidus Solomon - hey Derek I need your help, now I am trying to develop online cinema reservation system and I am using Php, so please share me some of your thoughts from where can I start 10q
- Prashant Patel - Hey Derek, Great Tutorial as always. You won't believe this but I practically learn more programming from your youtube channel rarher than from the collge.One quick request can you post a quick video on "Image processing in Android Using OpenCv(Or any Other you think is better").That would be of great help to all of us.
- Anthony Rosamilia - good vids.
Abhishek Balani - Hello Derek,
One request: Can you please cover how to bind our app with our server (like hosting) and use of OAuth? I am pretty sure it will be helpful for many users.
- Eduardo Medina - #PHP #MySQL #MariaDB
- anurodh tripathi - this is exactly for which i have search for
- michaelguy - This guy is a good instructor
- Sakis Soro - Damn derek,so so good tutorial ! thanks dude you are the man
- don kaspersky - this so much appreciated, especially that its available for free :)
- Alex Wetton - Hi Derek, great video :) possible stupid question: will the code still work even if I am running my website locally off my hard drive for testing purposes? Thanks in advance, alex
- thaqalain10 - If I haven't told you already, you're one from my most favourite youtubers :) Thanks for putting the code up online too!
Terima kasih.!! Anda telah mengunjungi halaman Download Video PHP MySQL Tutorial. Kunjungi terus blog ini untuk mendapatkan update terbaru.!!
0 Response to "Download PHP MySQL Tutorial Gratis"
Post a Comment