create mysql database, tables and insert data using php functions

Поділитися
Вставка
  • Опубліковано 15 вер 2024
  • create mysql database, tables and insert data using php functions
    in this video you will learn how you can create database and tables using wampserver and phpmyadmin....and you will be able to insert data using php and mysql...
    google,youtube,create,database,table,mysql,php,query,function,insert,into,delete,update,phpmyadmin,insert data,how to,learn,mysql database,create database,create table,insert data,using php functions,youtube,google,2017,new
    google,youtube,insert data into tables using php functions,learn how to,insert data,Table,Insert,PHP (Programming Language),Data (Dimension),Into,function,php functions,insert data into mysql,mysql,table,update,statement,query,fetch,connection,mysql functions,connectionn class,class,method,wampserver,wamp,using wamp server,training,tutorials,insert data tutorial,how to insert,phpmyadmin,learn,database,php language,ajax,html,jquery,phpmyadmin, learn how to create mysql database and tables, learn how to insert data into tables using php functions | phpmyadmin

КОМЕНТАРІ • 244

  • @Royowski01
    @Royowski01 7 років тому +6

    You speak slowly and clearfully that is meaningful and important for me to understand and to hear . Thank you so much !!

  • @AwfullyFrosty
    @AwfullyFrosty 6 років тому +25

    Thank you so much i have been spending hours on this for a final project due tommorow and you just saved me from failing. Thank you so much!

  • @CountingSheepsTonight
    @CountingSheepsTonight 6 років тому +14

    This guy is awesome! but he takes his time to utter a few words so I have putted the video into the speed of 1.25, I recommend you to try it.
    It really helped me to understand him better :)

  • @walidamaan4099
    @walidamaan4099 6 років тому

    i am a beginner. couldn,t solve some syntax errors even after studying two months. this video helped so far thanks

  • @onlineeducation6448
    @onlineeducation6448 5 років тому +1

    you are genius brother.because of you my alot of problem gona sort out.thanks

    • @michaeljackson8517
      @michaeljackson8517 5 років тому

      can u help me with the codes, my email id is newletter4@gmail.com thanks in advance.

  • @shubham-qd1lw
    @shubham-qd1lw 2 роки тому

    Usefull thankyou.

  • @gabrielayornu3778
    @gabrielayornu3778 4 роки тому +5

    Thank you sooo much, you've save my night and I can now sleep peacefully.
    Please, kindly do a video on a constraints.
    Thank you

  • @mammurama8778
    @mammurama8778 2 роки тому

    tq so much its really help full for me

  • @Monkey-is9hl
    @Monkey-is9hl 2 роки тому +2

    Chokran

  • @VishalKhemnar360
    @VishalKhemnar360 7 років тому +1

    I was searching for this video. thank you.

  • @shohebkhan9819
    @shohebkhan9819 Рік тому

    Thank you bro this helps a lot

  • @mickeyjohnndayikeza3425
    @mickeyjohnndayikeza3425 4 роки тому

    thank you so much i have i undestand how to create database with phpmydmin

  • @mujahidahmad2296
    @mujahidahmad2296 5 років тому +4

    Remember new Beginner that Storage Engine = MRG_MYISAM is read only that means that you cant insert data into the table through php code for that you do Storage Engine = innoDB. 3:15

  • @savanrithvouth5630
    @savanrithvouth5630 6 років тому

    i love this video i hope that you will create your videos more

  • @easylearnplatform8967
    @easylearnplatform8967 3 роки тому +1

    nice and cool

  • @bhumik_patel_878
    @bhumik_patel_878 Рік тому

    Nice ❤️

  • @aishahafsa5568
    @aishahafsa5568 5 років тому +1

    i have done my work yahooo thank you sooo much

  • @autumn101000
    @autumn101000 6 років тому +1

    I could read you code very well. I have a vision problem, so thank you.

  • @edmond2000
    @edmond2000 3 роки тому

    thank you you are a good teacher

  • @st4480
    @st4480 Рік тому

    Good explanation

  • @elioraca4806
    @elioraca4806 3 роки тому

    thank you for this video! it was extremely useful!

  • @nerilyncruzado9185
    @nerilyncruzado9185 2 роки тому

    Thanks for this tutorial

  • @goosegoodman1
    @goosegoodman1 6 років тому +2

    kasa thank you for this video. I have watched many trying to do this, and yours was the first one that actually worked the way it was supposed to. Question, does phpmyadmin create sql script? Is it necessary to create separate php file? Can you crud fields in myphpadmin? Thanks again!

  • @77_abhijeetmalode69
    @77_abhijeetmalode69 3 роки тому

    Nice video Brother 🙌💯

  • @pradipraut6230
    @pradipraut6230 5 років тому

    Thanks Helpful video

  • @bhumik_patel_878
    @bhumik_patel_878 Рік тому

    Thank you so much ❤️

  • @madprogrammerrps8442
    @madprogrammerrps8442 5 років тому

    Nice video... #programmerRPS

  • @desalegngotolo5331
    @desalegngotolo5331 4 роки тому

    Thanks.it's well. I've got good point from this.......

  • @Royowski01
    @Royowski01 7 років тому +1

    Hey Kasa , thanks a lot for this guide, it is very clearful , meaningful and helpful... great !!!

  • @syrilselvi7251
    @syrilselvi7251 3 роки тому +3

    5.Create a Sql query for the table name Employees,Insert the values, alter the table as Employeedetails, select the staff details according to their age, sort the table according to their payscale
    6.Create a Sql query for the table name student, insert the values, select the name of the students according to their group, alter table as studdetails, sort the table according to their name in ascending order................pls answer sir

  • @arf7605
    @arf7605 4 роки тому

    Thanks Man.It's very helpful veido Man/////////////////////////////

  • @talebyoussef925
    @talebyoussef925 7 років тому

    thank u so much u r a great teacher

  • @nehatutorial
    @nehatutorial Рік тому +2

    Hello sir .. i have some error to adding database ....connected successfully is done but data not added in phpmyadmin

  • @JunedKhan-iq6yj
    @JunedKhan-iq6yj 6 років тому

    helpful
    thanks sir....

  • @germanslobo
    @germanslobo 5 років тому

    Thanks. Very useful!!

  • @rajeshkumarprajapat6882
    @rajeshkumarprajapat6882 5 років тому

    Super Thanks for Support

  • @normanbravo8438
    @normanbravo8438 5 років тому

    Low volume, nice video, thanks

  • @sauropyaranjansahoo862
    @sauropyaranjansahoo862 6 років тому

    thank you sir for teaching

  • @ayubaaman6822
    @ayubaaman6822 4 роки тому

    i was search this video 4 some time know i get it thank

  • @sayemshahji2785
    @sayemshahji2785 3 роки тому

    Thank you

  • @mohammedrazvi3681
    @mohammedrazvi3681 8 років тому

    yes now i got by changing search engine instead of mgr_myisam i did innodb thats it i got all thankyou

  • @jalgaming5148
    @jalgaming5148 3 роки тому

    Thank you u help me a lot

  • @PavanKumar-qw3nd
    @PavanKumar-qw3nd 7 років тому

    thank you so much. from this i have learned how to give database connectivity easily, but the query should not be worked.

  • @shovaislam7357
    @shovaislam7357 8 років тому

    Sir,you explained it very well.

  • @EntertainmentTak897
    @EntertainmentTak897 7 років тому

    sir please give one lecture of registration page.how insert the database in registration page using php.

  • @IreshDissanayakaM
    @IreshDissanayakaM 7 років тому

    Really good tutorial. Thank you! :)

  • @shubhambharijat8296
    @shubhambharijat8296 7 років тому

    good

  • @rebinmajed_4k894
    @rebinmajed_4k894 2 роки тому

    Your project is Car Parking System
    you have to demonstrate CRUD (create, read, update and delete) along with login and access rights through the implementation of the project.

  • @pavaudeshi7825
    @pavaudeshi7825 4 роки тому

    Thank u sir.

  • @jasirjawler7749
    @jasirjawler7749 4 роки тому

    Thank you😊😊

  • @mdk124
    @mdk124 7 років тому +2

    I'm trying to make a project management website, so project members can create additional tables;
    how do I enable a way to insert customized tables into a database through my own website?
    Is there a video I can watch?

  • @pianoLee-sx9dx
    @pianoLee-sx9dx 6 років тому

    I am new to database and just realised that by using null is easier if some of the variables are unknown. I also noticed that i don't have to declare or set those variables... is this also true for undefined?
    For some reason.. when i set my other variables to 0... it won't work unless i make it null

  • @jhonabuyendiaz
    @jhonabuyendiaz 7 років тому

    Same issue encountered but resolved after changed the storage engine into InnoDB too.

  • @mahabubulalam639
    @mahabubulalam639 6 років тому

    thanks lot

  • @shithi30
    @shithi30 7 років тому +1

    I really don't understand why such videos don't include the source code in a text file or something!

    • @umariftikhar8665
      @umariftikhar8665 4 роки тому

      I'm curious too whole youtube is fucked up with errors about these kind of vids like connection with sql to php

  • @doramilovic7873
    @doramilovic7873 8 років тому +8

    thanks brother..i like your videos.. you explain well
    but where should i save the script.php in my file..i did the same steps than you but when i reload localhost .nothing appears
    please answer me i need your help..best wishes

    • @iakovospr6712
      @iakovospr6712 8 років тому

      the same thing,data don't appear at database...i have this error too.. mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)..maybe it's because of error...any help??

    • @doramilovic7873
      @doramilovic7873 8 років тому

      thanks brother .it helped a lot of

    • @pavanvarma2227
      @pavanvarma2227 7 років тому

      in index.php copy and past your php script and then run it

  • @Ncert8mathematics
    @Ncert8mathematics 9 місяців тому

    Sir I got error like check manual that corresponds to ur Marian server version for the right syntax to use near

  • @latenight3055
    @latenight3055 4 роки тому +1

    here you have given values in the code but may i get code for taking values from html page?

    • @webdeveloper4453
      @webdeveloper4453 4 роки тому

      This video have a code in description.
      ua-cam.com/video/6BPLlDZ80zg/v-deo.html

  • @raghvendramishra9766
    @raghvendramishra9766 7 років тому

    please upload more new videos related php lalest

  • @sarasheikh5293
    @sarasheikh5293 6 років тому

    hi i hope you are fin me 1 question ha php my admin k throw jo database or table hum create kirta heen us ka code sublimtext3 editer ma kasa open ho ga kindly guide me

  • @victormamouroutraore2426
    @victormamouroutraore2426 6 років тому

    thank you very much. Please how we build a profile system ?

  • @sudhakar3036
    @sudhakar3036 7 років тому

    yes good..

  • @sivaramis5612
    @sivaramis5612 5 років тому

    Thanks bro

  • @mohammadakbarhashimi6759
    @mohammadakbarhashimi6759 5 років тому

    I have create a database but wanted to create another sub-dataset to import his related tables to sub database , please help me how to create

  • @collinsonyegbado309
    @collinsonyegbado309 5 років тому

    Thanks for the video. In case a student id is like this :fuo/18/bch/3007,which one should i use,int or varchar. I would like to achieve the following objective. If a student clicks on the registration page,he/she will be prompted to enter his/her student id.if the id is found in the database ,the registration page will open and the student will be allowed to fill in other details.how do i go about this?

  • @kuqiu5003
    @kuqiu5003 Рік тому

    3'23", by setting the 'Storage Engine' to 'MRG_MYISAM', you are setting the table to 'READ-ONLY' which is a bazaar.

  • @donsimon2196
    @donsimon2196 8 років тому

    Salutare, poți face un tutorial cum sa spargi parole de Facebook cu acest program...pls m-am abonat la canal

  • @anomolisagag2270
    @anomolisagag2270 4 роки тому

    hi, your video very helpful
    I need to ask how to create a database for files, what is the datatype?

    • @webdeveloper4453
      @webdeveloper4453 4 роки тому

      Data type is the type of data like text,intergers or varchar...if you wanna create column of name then data type should be the 'text'..
      if still not clear then watch my video..
      ua-cam.com/video/l5sFpiDKp5s/v-deo.html

  • @JosephatKennedy
    @JosephatKennedy 5 років тому

    After installing wamp server, I went to phpMyAdmin web address and click to localhost but it asked me to enter user and password. I did not create any database yet. What do I do please?

  • @arjunchauhan3210
    @arjunchauhan3210 6 років тому +1

    connected sucessfully to mybd database but data is not inseted

  • @fahmnyshokran-7671
    @fahmnyshokran-7671 6 років тому

    Okay, but when i upload my website,
    What i need to change in "$host" variable? Or it will be the same?

  • @marcusnyoung3595
    @marcusnyoung3595 7 років тому

    hello bro thanks for this awesome video, what i intend to do is creating a database that will require a client using a unique pin or pin from a set of pins to log in. How do i go about that please? i'm a complete novice. thanks.

  • @menakaonline
    @menakaonline 6 років тому

    for me, sql is not executing. there is no msg like data inserted,. pls help how to execute sql

  • @kingsken7336
    @kingsken7336 2 роки тому

    Nice video, but how did you get the codes, did you write it or it is generated by php.

    • @kingsken7336
      @kingsken7336 2 роки тому

      I don't know where to write this code, in the app can someone tell me pls.

  • @TheMynameismax
    @TheMynameismax 8 років тому +1

    hi does this mean everytime I log into my account on fb I am accessing my own .php page? and everyone else has their own separate php page? then how do you see each other posts ?

  • @Jeavea
    @Jeavea 6 років тому +1

    Thanks

  • @TheGuidingLight25
    @TheGuidingLight25 7 років тому

    thank u sir

  • @unknownaccount8669
    @unknownaccount8669 7 років тому +1

    why we need to use general ci?

  • @HowTo-nr7uk
    @HowTo-nr7uk 8 років тому

    Thank you so much my friend!! (Y)

  • @newvideo584
    @newvideo584 7 років тому

    thank u g

  • @omarshiha3965
    @omarshiha3965 6 років тому +2

    gives me this error 'Access denied for user 'root'@'localhost' (using password: NO) in C:\xampp\htdocs\test\day.php on line 8
    ERROR (1045) Access denied for user 'root'@'localhost' (using password: NO)'

  • @mohammedrazvi3681
    @mohammedrazvi3681 8 років тому

    sir , i got the problem in insert data it didn't confirm as well it didn't show inserted at database panel please help me

  • @sivaanand2123
    @sivaanand2123 6 років тому

    Unbelievable!

  • @nge5118
    @nge5118 Рік тому

    I need to make a server (server management?) To work i cant connect to database

  • @jenieadolfo6905
    @jenieadolfo6905 7 років тому

    thankyou

  • @raghvendramishra9766
    @raghvendramishra9766 7 років тому

    thanks

  • @hichamoufettoul4724
    @hichamoufettoul4724 4 роки тому

    hi hope you fine thank you about this tutorial i have a project in which i want to creat server to collect my data from arduino please help what should i do

  • @folklorefrench
    @folklorefrench 8 років тому

    the engine storage you chose didn't work for me. I used the myisam which removed the error that the table is read only

  • @ahamedbilal8389
    @ahamedbilal8389 4 роки тому

    Hi for me db connected by value is not inserted into the table pls some one reply

  • @MindphpTube
    @MindphpTube 7 років тому

    it would be nic

  • @mr_pawar_3
    @mr_pawar_3 4 роки тому

    Nice can plz upload java and xampp

    • @mawazoson5224
      @mawazoson5224 4 роки тому

      Hey bro watsap i'm IT student in Tanzani and i need to know abou programming i can get your contact?
      my email hamadimawazo5@gmail.com sorry for disturbance

  • @rw7799
    @rw7799 7 років тому

    looking to add a jquery date to phpmyadmin . . .how do you add a date row?

  • @meznagnacomedytube6074
    @meznagnacomedytube6074 2 роки тому

    Please write down a link for source code if you have a website!!!

  • @zainulabydeen2809
    @zainulabydeen2809 8 років тому

    my coding doesnot working ?? database not selecting error ?? why it is

  • @ashwink2139
    @ashwink2139 8 років тому +6

    Helpful but , when i give a query it fails .. what could be the reason ? but the connection is successful

    • @joonamikkonen2774
      @joonamikkonen2774 8 років тому

      +ashwin k Same here. The query failed although I connected just fine. Wonder why that is...

    • @joonamikkonen2774
      @joonamikkonen2774 8 років тому +1

      +ashwin k actually I had the same problem with other tutorial as well which is why I tried this one. O.O

    • @ashwink2139
      @ashwink2139 8 років тому

      +Joona Mikkonen I later successfully inserted values in the mysql database .. By the way what problem do u face now ?

    • @joonamikkonen2774
      @joonamikkonen2774 8 років тому +3

      +ashwin k at this very moment I just got it working. So the problem was I couldn't INSERT INTO the table. later I discovered that it was read only. I changed the storage engine into InnoDB and it works. Don't know exactly how thoguh :p

    • @joonamikkonen2774
      @joonamikkonen2774 8 років тому +3

      I would love to know why the storage engine was the problem though. I mean... I checked all the privileges on localhost root and all the checkboxes were checked. O.O

  • @mysterious_billionaire
    @mysterious_billionaire 5 років тому +1

    why did u select that mrg_myisam

  • @Abdullahshahidvlogs
    @Abdullahshahidvlogs 7 років тому

    thanks boy explained really well

  • @marjtopacio8243
    @marjtopacio8243 8 років тому

    How can datas from my website be stored in the database? :)

  • @muskanmujawar454
    @muskanmujawar454 9 місяців тому

    How to insert the data into table online

  • @YoussefARRASSEN
    @YoussefARRASSEN 6 років тому

    Morocco you are from morocco