Visit Jeremy's Blog.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 03-23-2010, 05:24 AM   #1
Registered: Feb 2010
Posts: 116

Rep: Reputation: 15
Cool "How to connect to mysql databases;"

I have installed mysql ,php ,apache,phpmyadmin
i have create a forum on mysite check it on


Now i have create a database with name login and then i create a table with name loginn ..After that in loginn table i create colums with name username (data type=varchar),and password(data type=int);
i want when someone entered username and password in my sql ,it goes to database and userconnect to next page as we generally do in orkut or other social sites;
I dont know how to connect with php with mysql and how to do it whole

pls help me to do it '

Last edited by amritpalpathak; 03-23-2010 at 09:42 AM.
Old 03-23-2010, 05:43 AM   #2
Senior Member
Registered: Oct 2004
Distribution: Debian Squeeze x86_64
Posts: 1,748
Blog Entries: 11

Rep: Reputation: 233Reputation: 233Reputation: 233
Just do a "php mysql" in google and you should find decent tutorials to get you going. If not just add "tut" or "tutorial" to the google bar.
Old 03-23-2010, 06:07 PM   #3
Registered: Oct 2008
Distribution: Debian Lenny
Posts: 39

Rep: Reputation: 15
once upon a time the end
Old 03-24-2010, 02:52 AM   #4
LQ Guru
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.10, Centos 7.5
Posts: 17,700

Rep: Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494
password(data type=int)
would be wrong unless you're going to force the users to use integers for passwords; you want varchar.

You're going to need


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
yum install php-mysql fails with mysql 5.1 - "Error: mysql conflicts with MySQL" rebelde Linux - Software 2 03-13-2009 11:32 AM
mysql "cannot connect to socket error" on Redhat 9 SpellChainz Linux - Software 6 06-24-2007 03:12 PM
Buzilla issue: "Can't connect to local MySQL server through socket '/tmp/mysql.sock'" vitopn Linux - General 3 05-21-2007 11:13 AM
Which Databases in nsswitch.conf can be used with "dns" keyword saudoi Solaris / OpenSolaris 5 12-29-2005 11:37 AM
"No hdlist" error message to get urpml databases to work doobers Linux - Software 2 08-02-2004 04:04 AM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 01:24 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration