Create databases, users, and tables in MySQL and create the database connection in PHP.
Apply PHP knowledge to capture and secure input from user before sending it to the database.
Create the add, update, delete and retrieve functions in the PHP web app interacting with MySQL database
In this 1-hour long project-based course, you will learn how to create a simple note-taking web app using PHP and MySQL. PHP and MySQL enable developing powerful dynamic web pages and applications. They are some of the most widely used technologies in the world right now for developing back-end applications. They allow you to create dynamic content on your webpage and bring it to life. They also allow to persist data in the backend database and use them in every different way. Eventually, you will be able to use the concepts you learned to build more complex and powerful web pages and applications using PHP and MySQL. This will open huge career opportunities in the field of back end web and mobile development. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.
In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:
Preparing the Database
Capturing User Input
Adding Records to the Database
Retrieving Records from the Database
Deleting Records and Security
Your workspace is a cloud desktop right in your browser, no download required
In a split-screen video, your instructor guides you step-by-step
Really good to learn basics in working with mysql database using php to insert, update and delete items in the database.
Nice to learn the underlying php and sql. The template is already present in the starter files.
hands-on skill of database management system is brief yet clear and easy to understand
this course help me to improve my skill to know more php language, thanks coursera
What will I get if I purchase a Guided Project?
By purchasing a Guided Project, you'll get everything you need to complete the Guided Project including access to a cloud desktop workspace through your web browser that contains the files and software you need to get started, plus step-by-step video instruction from a subject matter expert.
Are Guided Projects available on desktop and mobile?
Because your workspace contains a cloud desktop that is sized for a laptop or desktop computer, Guided Projects are not available on your mobile device.
Who are the instructors for Guided Projects?
Guided Project instructors are subject matter experts who have experience in the skill, tool or domain of their project and are passionate about sharing their knowledge to impact millions of learners around the world.
Can I download the work from my Guided Project after I complete it?
You can download and keep any of your created files from the Guided Project. To do so, you can use the “File Browser” feature while you are accessing your cloud desktop.
What is the refund policy?
Is financial aid available?
Financial aid is not available for Guided Projects.
Can I audit a Guided Project and watch the video portion for free?
Auditing is not available for Guided Projects.
How much experience do I need to do this Guided Project?
At the top of the page, you can press on the experience level for this Guided Project to view any knowledge prerequisites. For every level of Guided Project, your instructor will walk you through step-by-step.
Can I complete this Guided Project right through my web browser, instead of installing special software?
Yes, everything you need to complete your Guided Project will be available in a cloud desktop that is available in your browser.
What is the learning experience like with Guided Projects?
You'll learn by doing through completing tasks in a split-screen environment directly in your browser. On the left side of the screen, you'll complete the task in your workspace. On the right side of the screen, you'll watch an instructor walk you through the project, step-by-step.
More questions? Visit the Learner Help Center.