mysql - How to set user/admin accounts for a redirect after log in? PHP -


My problem with this code is that the IF statement which determines which page to go index Php seems to default i have already created a login table in mysql and the username / password column, and the second column with a boolean value indicating that the user is the administrator. 

  session_start (); // Start Session $ error = ''; // blank ($ _ POST ['username']) empty ($ _ POST ['password'])) {$ error = "username or password is invalid"; } Else {// Define $ username and $ password $ username = $ _POST ['username']; $ Password = $ _POST ['password']; // server_name, user_id and password as a parameter to establish a connection with the server via $ connection = mysql_connect ("", "", "", "", ""); // Select the database $ db = mysql_select_db ("", $ connection); // Register: Finds the queries of the users to bring SQL queries and user matches. $ Query = "SELECT * login from WHERE username = '$ username' and password = '$ password'"; $ Result = mysql_query ($ query) or die (mysql_error ()); $ Line = mysql_fetch_array ($ result); $ Count = mysql_num_rows ($ result); $ Auth = $ row ['Admin']; If ($ count == 1) {if ($ auth ['admin'] == 1) {session_start (); $ _SESSION ['Admin'] = $ auth; $ _SESSION ['username'] = $ username; Header ("location: member.php"); } Otherwise ($ auth ['admin'] == 0) {session_start (); $ _SESSION ['Admin'] = $ auth; Header ("location: index.php"); }} And {$ error = "username or password is invalid"; } Mysql_close ($ connection); // Close connection}}

I have written your login script to use it. I think that you will find what it will be better for you. 

  if (isset ($ _ POST ['username'])) {$ username = stripslashes ($ _ POST ['username']); $ Username = strip_tags ($ username); $ Username = mysql_real_escape_string ($ username); $ Password = $ _POST ['password']; // $ password = MD5 ($ password); $ Db_host = "host"; $ Db_username = "username"; $ Db_pass = "password"; $ Db_name = "db_name"; Mysql_connect ("$ db_host", "$ db_username", "$ db_pass"); Mysql_select_db ("$ db_name"); // Join your database, if the user name is $ sql = mysql_query ("SELECT * FROM login WHERE usernames = '$ username' and password = '$ password'" is set); $ Login_check = mysql_num_rows ($ sql); If ($ login_check> 0) {// if the session is on, after the session is started; // Start Session here (only once) ($ line = mysql_fetch_array ($ sql)) {// user administrator query $ auth = $ row ['admin']; $ _SESSION ['Admin'] = $ auth; // Set Administrator session variable $ _SESSION ['username'] = $ username; // Set user name session variable if ($ auth == 1) {header ("location: member.php"); // if the user is at 1, send it to member} and if ($ auth == 0) {header ("location: index.php"); // If user is at 0, then send to index} exit (); }} And {header ('location: login.php'); // If the user does not exist, reload the login page. } Mysql_close (); }

I recommend using MD5 hash password.

When a person registers your site, you pass the password to MD5 hash this line $ password = MD5 ($ password); Before DB Entry

About your $ AUTH, above it assumes that your entry in the database is either 0 or 1. By the way, if you are controlling it, I recommend using enum in the SQL database. Set type "enum" and type to '0', '1'


Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more