PHP & MySQL Tutorials For Beginners
4.4 (100 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7,641 students enrolled
Wishlisted Wishlist

Please confirm that you want to add PHP & MySQL Tutorials For Beginners to your Wishlist.

Add to Wishlist

PHP & MySQL Tutorials For Beginners

This course contains all of topics about PHP and MYSQL. Let's start and code web sites
4.4 (100 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7,641 students enrolled
Created by ilyas Akkuş
Last updated 8/2017
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 7 hours on-demand video
  • 5 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • By the end of the course,you will br ready to create your web site ,blog,cms admin
  • in this course you will learn php functions,variables,files,sef,global variables, and a lot of more...
  • This Course Contains 86 Lectures for you
  • Goal of This Course is to learn everything about PHP
  • Using Phpmyadmin
  • Using mysql on phpmyadmin
  • Using mysql functions
  • Mysql_Fetch_(array,row,object,assoc) functions
  • using mysql functions with Php on Phpmyadmin
View Curriculum
Requirements
  • Before you start this course , you should set up wamp or xampp apache server
  • You should be aspirant for learning Php
Description

Learn Best: Php For Beginners - Mysql For Beginners

By the end of this course, you will be a PHP coder .But this is important subject, you can't write dynamic site with only PHP. Besides You should learn Mysql (recommended) or another database management systems. Also if you want to be web developer, you should keep an eye on these subject :

  1. How may it's design be
  2. What it will include and how you will build it
  3. When you plan on completing it

This may seem like a waste of time and effort, but attempting to build a web site with Php & Mysql. It seems difficulty but you never think such as that , because Php and Mysql have very strongable structure and you will learn Php&Mysql with easy way.

Let's Get started , How should You build a Web Site ?

First Step:

Why Php ?

Php is the most using web programming language in the world. So programmers has chosen php for doing forum scripts, All Forum scripts(vBulletin,datalife engine,Worpress Cms,Joomla Cms, etc..) and besides Php was famous in 2003 within using of Facebook ..Facebook , Twitter, ....etc (Big Company) have used PHP on their systems. Php is open source language. If you want to develop your algorithms , You should start to learn Php.

You will learn Php by this course easy way..

This Course contains all things about php last version..This course was prepared for the beginners.But everybody can join this course . Because This course is very actual , easy coding that consist HD videos..(720p) .if You start php now ,this course is for you. This course contains pure php videos and everything about php 5.4 for beginners . I shared codes of this course.

Let's Get Started..End of This Course, You will start your web project with php..

Besides You will want to learn Object oriented programming of php with Php Frameworks with Codeigniter,Zend ,Kohana,Cakephp,Symfony..etc. in the future our course

Analyze This Course if You like that Start learn Php in Best Way

· First Chapter on Php

· Operators

· Conditions(if,switch case)

· Loops

· Global Variables

· Functions

· Text Functions (strlen,strcount,trim..etc.)

· Mathematical Functions

· Include & Require

· Encode Functions (md5() , Crc32() , sha1())

· Time and Date Functions

· Cookie and Session create

· Arrays (Advanced)

· Files Management (Advanced)

· File Upload

· Send Mail with PHP

Mysql is very popular DBMS(Database management system) and is free . You use mysql with an interface -> (PhpMyAdmin).

Phpmyadmin is handy tool. You may do your processes on Phpmyadmin manuelly or with Sql Code.

Mysql was popular owing to Php . You can use Php and Mysql for Dynamic Web Sites (CMS).

Dynamic WebSites must contain Cms(Content Management System). Because your customer will want to be Website's Admin Panel.

if you learned Php then You should learn this course

Using Mysql on phpmyadmin detaily

Using Mysql with Php (with Mysql functions)

We will learn mysql_fetch_array,mysql_fetch_row,mysql_fetch_assoc,mysql_fetch_object on this course .Besides we will learn select (submitting), Insert ,Update , Delete, Like,Limit,etc..

on this course,

I Hope This course will usefull for you ,this course starts for beginners to advanced

· Create Db

· Create Table

· Using Phpmyadmin

· Insert,Update,Delete,Select on Phpmyadmin manuelly

· Select where

· select like (search)

· order by ,group by

· Joins -> inner join,left join,right join

· Php and mysql lib

· Mysql fetch (array,object,row,assoc)

· mysql affected rows etc..

Take this free Php For Beginners - Mysql For Beginners and learn everything you need to get started.

Who is the target audience?
  • This course is for the php beginners
  • Beginners will learn everything about php
  • No unnecessary information Watch and See Difrentation
  • Beginners,Advanced,All php coders
Students Who Viewed This Course Also Viewed
Curriculum For This Course
118 Lectures
07:18:54
+
First Chapter Php
9 Lectures 20:19
install xampp apache server and phpmyadmin to your pc for start php course
Install Xampp Apache Server
5 pages

What is php? Introducing about php
Preview 03:12

We will learn php data types (integer,float,string,...)
Php Data Types
2 pages

Php variables is explaining
Preview 02:08

Using of php unset function
Preview 02:15

Special Character in php
Preview 05:22

Defining long text "<<<longtext     longtext";
Defining Long text
01:51

Type casting in php
Type Casting
02:55

define()

and Const variables

Define variable & Const variable
02:36
+
Operators
5 Lectures 18:25
Arithmetic Operators in Php
Arithmetic Operators
03:02

Appointment Operators in PHP
Appointment Operators
03:33

Redounding and reducing Operators
Redounding or Reducing Operator
05:30

Comparison Operators in Php
Comparison Operator
04:48

Logical Operators in Php
Logical Operator
01:32
+
Conditions(if,switch)
5 Lectures 20:22
İf conditions in PHP
If Structure
03:42

Else if in PHP
Else If
04:52

else structure in PHP
Else
03:54

Condition Operators in php
Condition Operator
03:05

Switch Case in PHP
Switch Case
04:49
+
Loops
5 Lectures 20:51
For structure in PHP
For Loops
02:56

While Structure in PHP
While Loops
07:11

Do While Structure in PHP
Do While Loops
02:24

Foreach Structure in PHP
Foreach Loops
04:03

Break & Continue Structure in PHP
Break & Continue
04:17
+
Global Variables
7 Lectures 27:28
$_globals  Structure in PHP
$_GLOBALS
03:12

$_server  Structure in PHP
$_SERVER
04:51

$_GET Structure in PHP
$_GET
04:17

$_Post  Structure in PHP
$_POST
04:38

$_Cookie  Structure in PHP
$_COOKİE
04:08

$_Files  Structure in PHP
$_FİLES
03:22

$_session  Structure in PHP
$_SESSİON
03:00
+
Functions
4 Lectures 13:19
Functions without parameters Structure in PHP
Functions _ without parameters
02:42

Functions with parameters Structure in PHP
Functions _ with Parameters
03:28

Functions return value Structure in PHP
Functions_Return_value
02:48

Functions with array Structure in PHP
Functions_with_Array
04:21
+
Text Functions
11 Lectures 33:47
Strlen() Structure in PHP
Strlen()
02:50

trim,ltrim,rtrim() Structure in PHP
Trim,Ltrim,Rtrim
04:01

substr,mb_substr() Structure in PHP
Substr & mb_substr
02:42

str_count() Structure in PHP
Str_count
02:08

Text functions in PHP

Strtolower,Strtoupper,ucfirst,lcfirst,ucwords
04:20

Explode function in PHP

Explode
02:45

Str_replace() Structure in PHP
Str_replace
01:53

Strrev() Structure in PHP
Strrev
01:50

Strpos,Stripos() Structure in PHP
Strpos , Stripos
03:31

Htmlentites,htmlspecialchars,stripstagsand the others() Structure in PHP
Htmlentities,htnlspecialchars,Strip_tags,addslashes,stripslashes
03:59

Printf() Structure in PHP
Printf(%d,%s)
03:48
+
Mathematical Functions
3 Lectures 06:33
Ceil,Floor and Round structure in PHP
Ceil , Floor , Round
02:30

rand()  functions structure in PHP
Rand() , get_rand_max() ,mt_get_rand_max() , mt_rand()
02:18

Max,Min,Pi () Functions structure in PHP
Max() , Min() , pi()
01:45
+
Include and Require
2 Lectures 11:12
include and require () Functions structure in PHP
Include , include_once and Require , require_once
04:46

Header () Functions structure in PHP
Header()
06:26
+
Encode Functions
3 Lectures 05:09
md5() Functions structure in PHP
Md5
02:50

Crc32 () Functions structure in PHP
Crc32
01:17

Sha1 () Functions structure in PHP
Sha1
01:02
10 More Sections
About the Instructor
ilyas Akkuş
4.4 Average rating
100 Reviews
7,641 Students
1 Course
Instructional System Designer & Web Coder

I graduated from İnönü University, Department of Computer and Instructional Technologies Education in 2013 and graduated master of science in same department in 2016. And I'm Ph.D. candidate in Gazi University in the same department. I'm experienced in web programming, instructional design, educational technology, modern web technologies. I have developed web apps for six years. And due to have an academic identity I research on instructional technology. I have two course in UDEMY and I will plan to add some courses related to programming and educational apps.