Search the Community

I'm testing a remote connection to my Mysql DB and table. I followed the basic procedure: 1 - I created DB ("employee101") by Mysql wizard. 2 - I created employee_data table by Myphpdamin. 3 - I created two DB users ("hazak" (cpanel user) and "remcon". 4 - I set users access and rights to "employee101" DB. 5 - I built two PHP scripts to remotely access Db and table, and put them in "hazak" public_html directory, as follows: 1 - conn.php (connection): <?php$db_name = "hazak_employee101";$mysql_username = "hazak";//$mysql_username = "remcon";//$mysql_password = "&cx=Q******";$mysql_password = "al********";$server_name = "localhost:3306";$conn = mysqli_connect($server_name, $mysql_username, $mysql_password, $db_name);if($conn){echo "connection success";}else{echo "connection not success";}?> 2 - login.php (login): <?php require "conn.php";$user_name = $_POST["user_name"];$user_pass = $_POST["password"];$mysql_qry = "select * from employee_data where username like '$user_name' and password like '$user_pass';";$result = mysqli_query($conn, $mysql_qry);if(mysqli_num_rows($result) > 0){$row = mysqli_fetch_assoc($result);$name = $row["name"]; echo "login success - user ".$name;}else{echo "login not success";}mysqli_close($conn)?> 6 - Remotely run the script. First using "hazak" user set in conn.php and second, using "remcon" user in the same script. I got the same error message (bellow) and when I created an email acoount to "hazak" (cpanel) user the message gone away and I could remotely connect to DB and access "employee_data" table. but the same didn't happened to the "remcon" user. Since I could't find reference to this error on heliohost.org Mysql pages I´m not sure about what is the error cause. Can anybody tell the possible cause/solution for this error and help me? Error message: Warning: mysqli_connect(): (HY000/1045): Access denied for user 'remcon'@'localhost' (using password: YES) in /home/hazak/public_html/remcon/conn.php on line 8

I am getting this error when accessing the homepage of my heliohost site: I checked my 'config.php' file and made sure that the the db name, db user, the password, and the server (stevie.heliohost.org) was correct. I also added the user to the database I created. What could be wrong? Any ideas? Thanks in advance

Hello everyone. I'm tryin to make a secure PHP script on johnny server where makes SQL query (Preventing SQL Injection), using mysqli class procedural style. The problem is than I got a Fatal error callin mysqli_stmt_get_result() cause is a undefined function, so I search in PHP bugs & forums and find this: http://www.php.net/manual/en/mysqli-stmt.get-result.php#105802 So, here is my feature request. Is possible to update the PHP version or Install that plugin? Thanks, OPhE.