How can I get username into shortcode?

Get mysql username/password using php?

• i have a login page, with a html form username & password & submit button. then I have the next page connect to the database. using mysql_connect('localhost', 'userName','passWord'); how do i have "userName" & "passWord" refer to the same as the one's entered in by the user?

• Answer:

  You do NOT. That is suicide, anyone breaking the script could then totally modify the data structure and the whole server could become one giant bank phishing scam or child porn distribution site. You need to set up a user with limited access to the database, definitely not with grant option, as a user for the web site. Then set a password for the user root as well. You then use the limited user details to log in to the database from the pages. Do NOT put any of the mysql connection or login details in any web readable page and definitely not in the .directory root of any site. ALWAYS put these details into an include file in a directory protected from public reading. And set constants for the user name and password, then ONLY use the constants to call the connection. Then for each user on the site you provide a method to store their user name and an ENCRYPTED copy of their chosen pasword in a table. When someone logs in the form needs to POST the login details and compare the user name and an encrypted copy of their typed password with the stored versions. NEVER have any user access direct to the database from the web pages. If your hosting company saw you do this they would kick you out.