Thank you so much for your patience with me. Or that I am not comparing the input password with the one in the database correctly. For best results, restart the mySQL server while you're at it. The solution is to clear your browser's cookies. I think godaddy's default settings are returning the password in a format that cannot be read by my script. There's this bug in phpmyadmin (or feature who knows anymore) that occurs if you've been logged in as a user without permissions. The offending code results in line 38 being printed to the screen and the users account not being activated. and Canada only), weve already logged you in and youll go right into the database. Note: For Pro Managed WordPress accounts (available in U.S.A. and Canada only), we've already logged you in and you'll go right into the database. It is only recommended to perform these steps if you are comfortable using command-line interfaces. Please note that this will require the use of command-line operations. Next, connect to your database server via SSH. This seems to be a result of shared hosting. For the website you want to manage, select Settings from the menu. For the website you want to manage, select Settings from the menu. First, ensure that your database has been created and can be accessed. So please ignore the code in the first post and use this code instead. 1 Answer Sorted by: 1 Plesk via GoDaddy does not allow you to have admin privileges over phpMyAdmin. I feel like an idiot, but I posted the code from a file I was experimenting with and I cannot see a way to modify my first post. I promise that after I am more proficient I will contribute what I can to this forum. I think their default settings have something to do with this problem. This is a very user-friendly program that makes it simple to find the information you require. 'index.php' // Define the URL:Įcho 'Either the email address and password entered do not match those on file or you have not yet activated your account.' If you are not familiar with MySQL, we recommend that you read our beginners’ guide first before starting phpMyAdmin. $_SESSION = mysqli_fetch_array ($r, MYSQLI_ASSOC) mysqli_error($dbc)) Įcho 'Query worked' // I added this line $r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\nMySQL Error: ". $q = "SELECT user_id, first_name, user_level FROM users WHERE (email='$e' AND pass=SHA1('$p')) AND active IS NULL" To do this, I put the IP Address given to me in the GoDaddy hosting. This is an inefficient process, so now I want to use PHP to connect to the GoDaddy server. Upload this file on the localhost phpmyadmin. Download the sql file on the remote phpmyadmin. Then the error message:Īn error occurred in script '/home/content/l/a/s/lastinghearts/html/login.php' on line 33: Object of class mysqli_result could not be converted to string Therefore, if something new is added to the database on the public server, I would have to. That link takes him to a login page here he types his email and password. He opens it and clicks on link to activate his account. Basically the user comes to my website () and registers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |