PHP and MYSQL - Connecting to a Database and Adding Data

[siriusounds]

Really nice videos. but where did you check for the actual blank forms? Does "submit", by default works only if there is anything to submit. Also, can you submit NULL?

[jepipay]

starfi.sh

[jepipay]

PLEASE DO VISIT OUR LINK WE OFFER TOP SHELF internet solution come join us and learn more about web development

[tlmcqu80]

wow!, thanks, and I'm loving ur site right now...

[bhutanlhayul]

Great video. But i just don't have time to learn all the php and mysql. Can you please suggest some good sites that have photograph templetes for a online photo gallery.

Thanks a lot.

[praveshb13]

Hello buddy! I wud lyk 2 thank u, 4 ur video tutorial was of gr8 help 2 me. I did not know how to program using php - mysql, ur video was a gr8 introductive step! :)

[Jabberwock156]

Thanks for the tutorial man. I would just suggesting making the letter size bigger because it's a little hard to read. Oh, and for some strange reason my code only worked after I deleted the quotation marks from (ID, Name, Description) in Create.php.

[phgh1520]

i like this tutorial!!!!

[Rightwingful]

After two days of errors. I have to differ mysql_query("INSERT INTO people

(Name, Description) VALUES. without the single quotation mark and use header("Location: index.php) one time. After I did this slight midification it work 100%

Thank you very much for this useful tutorial.

[ShaneNL69]

I am trying to connect to my dbhost but i can't figure out what to do. It's on another server and the index.html is on again a different server. So how can i find out what the dbhost is?

[facebookprogrammer]

Curious around 23:00 how will the user see the message USE HAS BEEN ADDED if there is a server-side re-direct immediately after?

[manasume]

i installed xampp but when i start it, apache is not running, only my sql is running, do you know what can i do about that?

[MusiqOfAmani]

Where is the source code? Also thanks a lot I'm using this on my Final Project at Un

[aneesmug]

Grate jooooooooooooooooooob Boooooss

it is tooo much goooooooooooooooooooood

Thanks.

[carloseztorres]

Thanks!!!!!!

[TheLegend1245]

I'm so confused:(

[TheLegend1245]

Is it the same as creating a Mysql table and a PHP form to connect?

[frabbasi1]

Thanks for the great knowledge and specially for the web site

[easyvideoseries]

ITS AWESOME....love d video....best tutorial i have seen

[tharaclassic]

@easyvideoseries

[easyvideoseries]

ITS AWESOME....love d video....best tutorial i have seen !

[ktajpuri]

this wallpaper comes with windows 7 noob

[zainshah120]

can any one tell me please the software he is using...please...

[mrwaeta1]

@zainshah120 he is using aptana studio google it ,, try netbeans its awsome

[JSnooza88]

im getting this error when I add data: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''ID', 'Name', 'Description') VALUES (NULL, 'marvin','is awsome')' at line 1

[rykitz]

Extremely helpful! Thank you so much! :) Keep up the great work!

[05psvalent]

Error

MySQL said:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

[05psvalent]

hey can u provide me this wallpaper

[OwnerGangraz]

Okey, i get the Info out of the database, but how do i get it in. I followed your steps, and i cant do it. Can you opst a Download link for the .Php files you made? Thanks

[samosakun]

do u know how to set for the localhost?

if we r using php myadmin?

[MuhammadRaza2009]

i am having an error Undefined Index :(

[MuhammadRaza2009]

this is sooo helfull...

[jessenikki]

Very nice! Thanks much!!

[MySGB]

Extremely helpful!

[wineelk]

Thanks mann !!!

U helped me a lot :)

[MrSapitt]

Parse error: syntax error, unexpected T_STRING, expecting ']' in D:\xampp\htdocs\phpbasics\mysq­ltut\create.php on line 9

:(

[WNxLone]

Thanks very much!

You are very easy to understand and you explain this well. Thank you!!!

[MEGAXSTU]

Thanks for showing the ropes and introducing a great software!

[kapilrc]

how to insert image which has a link - into a database?

[SullivanSoftware]

Great tutorial! PHP MySQL frameworks such as wizzyweb.com can also be helpful

[unknown95485]

its aptana u dumb fuck

[jeth99]

ur awesome



[Vishalkaushal011]

i got error in line 9 in index.php

[iijimaee]

Hello I have tried the tutorial above and I faced the problem below. Can you please tell me how to solve it? Thanks!

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''ID', 'NAME', 'DESCRIPTION') VALUES(NULL,'joe', 'good')' at line 1

[christine69reyes]

i cnat read it so small

[CallMeMantou]

why ID the only one that's set to primary?

[rusurobert92]

thank you for the tutorial

[rsabinno]

CURSO COMPLETO DE WED DESIGN

80 AULAS IDEAL PARA INICIANTES

Acesse: W w w . surflogosredeunica . com

[guydatpwnz]

what i want is a tutorial how to create a registation system from every step possiable and how to apply it to my website.

[monkeysu]

Hi, i faced a problem and that is i actually follow your instruction, but when i view it in the browser, it become empty page. Can you help me to solve the problem please?

[monkeysu]

Hi , i faced a problem and that is, when after i click the submit button it shown no database selected. But i already look thru the code and confirmed that i had already selected it. Can you please help me to solve this problem? Thanks!

[AlexanderMonty]

Everything is fine except for me not being able to return to the updated output . If I go to the index page everything is there but I want this to happen automatically...

I get this error ...

User has been added!

Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\mysqltut\inclu­des\connection.php:11) in C:\xampp\htdocs\mysqltut\creat­e.php on line 20

[ssikarim]

Thank you very mutch, Good tutorial

[knitsu]

fixed the first error, got firther in the video, which made me understand alot, however still getting an error in line 7 or create.php on my browser when i run my code

line7

if(!$POST['submit']) {

error = You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''ID' , Name, Description') VALUES (NULL,'Sally','user'' at line 1

[xOwnageMasterx]

Nice tut rated 5*.

Thing is im trying to get a private server on a cpu game (AQW)

and it can't connect to "MySQL" it is actually the only issue im having...

So my question is, have you had any experience with this on priv. server games?

Such as WoW?

[MrRakesh448]

I am complete Novice please help me in php as well as database. My problem is when i run the script in local host it wont get executed the whole code is displayed on the browser. where do i need to save the php connection script ? kindly please guide me. i was able to connect to my php local host then extract the database from mysql but the php script to connect the server and display the table or query run in the script i was not able to do it.

Thanks !!

[cacamanyuu]

First Video

where it explains how to insert data by using Forms!

exellent job mate! i was looking 4 this

Keep up the good work

greetings From Argentina!

[zaaramsul]

you have no idea how much i love you for making this video! been trying to make this damn form work for days!

[ikbal92]

hello, i am getting problem when using the code line below:

if(!$_POST['submit'])

{ echo "blabla........";

}

my problem is evenif i fill the form with all the details it gives shows that "echo" and the data are not inserted into the database.....

[TheTruth90]

VERY VERY Helpful. Very nice Guide, damn good Job :) I think, now i know what to do ;), thanks :)

Very good Job :) Going on ;)

Vielen Dank für dieses Tutorial. Jetzt hab ichs endlich verstanden, denke ich ^^ .

Echt super Sache :) Weiter so.

[HedoBum]

I forgot...DUDE! I feel sorry for your keyboard. Were you mad at it?

[HedoBum]

I thank you from the bottom of my loins! This has been plaguing me for days! I've been going NUTS trying to get my code to work and I couldn't get help that works from ANYWHERE. I've finally got it to work for me (for the most part but this has got me the farthest ever)

Thanks once again ! 

[babarhussainkea]

you are a star! :) thanks!!!

[robinjay5566]

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'a6055404'@'localhost' (using password: YES) in /home/a6055404/public_html/dat abese connect.php on line 3

thats what it say........................

what is my error?

[HedoBum]

@robinjay5566

This is a problem with your mySQL settings. You have to adjust this with PHPmyAdmin. Go to the privileges tab on the main page and you can set your username and passwords there

[johndoe83104]

Can you tell me what progam do you use to record youre desktop?????

[HedoBum]

@johndoe83104

Camtasia Studio by techsmith

[RK143king]

please tell me sir why i make data base sql registration form please help me

[WISDOMandGRACE]

I followed this to the letter and when I user the fill in form, even if nothing is in the fields it will create a new user, completely blank. Here's what it says after all is said and done:

User has been added!

Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\mysqltut\creat­e.php:13) in C:\xampp\htdocs\mysqltut\creat­e.php on line 14

[AlexanderMonty]

@WISDOMandGRACE

Hi ! I get the exact same problem. Did you manage to resolve ? Great tutorial but gutted that I couldnt finish everything tonight because of this ever so small error.

[Spongehead1000]

im using eclipse with php but with the create.php file says unexpected "if" statement and it underlined the if

what should i do

[vpklotar]

what "notepad" are you using?

[pbj746]

@vpklotar notepad++

[vpklotar]

@pbj746 it doesn´t look like that

[TheFiscster510]

@pbj746 No, its something called Aptapa... i think.. but i cant find it anywhere... and i may be wrong.

[Obizi123]

@TheFiscster510 its aptana

[TheFiscster510]

@Obizi123 Yeah i realized that when i full screened it i couldnt see it clearly at first lol

[zainshah120]

@pbj746 i had downloaded the latest version of notepad but these options are not present there

[CALAVIDEOS2013]

@vpklotar looks like aptana 3.0 studio.

[ShaneNL69]

@vpklotar The 'notepad' this user is using is called 'Aptana studio Professional'

But I use notepad++ and Adobe DW CS5. But I am going to test this one out

[newcptv]

Dude thank you this worked perfectly my company will now succeed because of this we are glad that you have shared this knowledge.

[igloodesigners]

excellent stuff very concise and simple might need a little help styling the table.

I'm using it as a score board for primary school children and want to have the rows at the top of the table styled with css classes would you be able to help

[zeuss143]

Thanx for loading this video

[drakogemini257]

do i have to save my file to htdocs if i have a xampp folder?

[BURNLEYWHUT]

can i use this method to connect to wordpress?

[dbest737]

how did you learn to type?

[SideSteppingAverage]

copied this code but getting following output when i run my index:

" . $people['username'] . ""; } ?>

[lofhy]

how can you do this with flash (please upload a vid on about it)

[tuleo554]

a good tutorial but you haven't really built a usable application at the end

to make a simple but powerful Ajax app try this

watch?v=_oQSfLgbxL4

[MrNepalstar]

Nice but some times shows error in "fetch_array("

on line 1 i don't know what is that can u help my Apache is latest then your is so ?

[Gurthy24]

Nice tutorial... thanks

[Fai89]

Rather then presenting the information in this format, how would I present it in a table, to make the date more easier to distinguish?

[larazadelasmotos]

Very Good Script, Thank you::

See I alway get this error after i click eon submit "create.php".... Dont know what it is,

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''id', 'Name', 'Description') VALUES (NULL ,'chava','perro')' at line 1

[EvilTurt]

very cool tutorial you guided me to the right direction

[andddrewsays]

i have been looking for a tutorial like this for so long, i appreciate it that you took the time to explain everything... seriously thank you so much!

[kyle0015]

can you show me how to make a example of data form that actually insert a data in a browser and saving data in mysql.

[syaqiq89]

can you help me??

i just create one aplication for my web project at my school using adobe dreamweaver,at my web page, i want user to give information about them and then this information will add into my database which i create using phpmyadmin,ow should i do for that??

[deadwing5]

copied it word for word and I get this:

Warning: mysql_fetch_array() expects parameter 1 to be resource, string given in C:\xampp\htdocs\mysqltut\index­.php on line 8

line 8: while($person = mysql_fetch_array ($result)){

[pbj746]

the line should look like this:

while($person = mysql_fetcharray ($result)){

[ThaPaddeProductions]

Help!

then im trying to use in my browser its just showing this

" . $person('User') . "" } ?>

help plz :(

[pbj746]

the code should look like this:

" . $person['User'] . "";

}

?>

make sure you have a php server installded

[ThaPaddeProductions]

hmm dont know with the php serv... i got XAMPP should ther it be a php serv installed in that?

and my thing still dosnt works :(

(ps. that program ur using, can u send a link to dl? have found 1 but not the same and ur's looking better, mine named "Aptana RadRails"

[pbj746]

yeah XAMPP is a php server and im just using regular "Aptana Studio", since your using a rails version that could affect your code im not sure how but you never know. and lastly double check that your file is called [insert filename].PHP not .html or anything like that

[ThaPaddeProductions]

Hmm still dont work :(

cud u help me by team viewer or something?

[yyassaman74]

Very useful tutorial, thanks alot, waiting for more PHP tutorials from you!