php script error i mysql connection error

Question

this is my script

<?php
  define('HOST','databases.000webhost.com/localhost');
  define('USER','id847165_user');
  define('PASS','qwertyuiop');
  define('DB','id847165_db');
  $con = mysqli_connect(HOST,USER,PASS,DB);

  $name = $_POST['name'];
  $address = $_POST['address'];

    $sql = "insert into Persons (name,address) values ('$name','$address')";
  if(mysqli_query($con,$sql)){
    echo 'success';
  }
  else{
    echo 'failure';
  }
  mysqli_close($con);
?>

this is my error

Warning: mysqli_connect(): (HY000/2002): Connection refused in /storage/h5/165/847165/public_html/db.php on line 6

Notice: Undefined index: name in /storage/h5/165/847165/public_html/db.php on line 8

Notice: Undefined index: address in /storage/h5/165/847165/public_html/db.php on line 9

Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in /storage/h5/165/847165/public_html/db.php on line 12
failure
Warning: mysqli_close() expects parameter 1 to be mysqli, boolean given in /storage/h5/165/847165/public_html/db.php on line 18

screenshot of database enter image description here

can anyone help me to make it correct

You do not do _any_ error checking or handling whatsoever, you blindly trust that the connection will work and use the handle. The connection call returns `false` (a boolean...) if it fails, that is the reason for your warnings... — arkascha, Feb 23 '17 at 11:19
@Naincy Warning: mysqli_connect(): (HY000/2002): Connection refused in /storage/h5/165/847165/public_html/db.php on line 6 Notice: Undefined index: name in /storage/h5/165/847165/public_html/db.php on line 8 Notice: Undefined index: address in /storage/h5/165/847165/public_html/db.php on line 9 Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in /storage/h5/165/847165/public_html/db.php on line 12 failure Warning: mysqli_close() expects parameter 1 to be mysqli, boolean given in /storage/h5/165/847165/public_html/db.php on line 18 — Arun Mohan, Feb 23 '17 at 11:23
@ArunMohan yes arun, its saying "Network not Reachable" there is nothing wrong with code there is issue on server side might be they not allowing to connect or restricted the IPs and some other security stuff....but nothing wrong with your connection code — Naincy, Feb 23 '17 at 11:45
you should learn about parameterized statements, because your code is wide open to **SQL Injection attacks** — Franz Gleichmann, Feb 23 '17 at 12:09
@ArunMohan imagine someone posting an address like `'); DROP TABLE Persons; -- `. as soon someone does this, your Persons-table is *gone*. — Franz Gleichmann, Feb 23 '17 at 12:14
this is a real simple thing. You're trying to connect to your host on a remote connection. If you didn't "pay" for their hosting, then you can't use a remote connection. — Funk Forty Niner, Feb 23 '17 at 13:02

Kaushik solanki · Answer 1 · 2017-02-23T13:10:59.163

1

if your site is hosted on 000webhost

forget your 00wh info, when you create your database, you have to give it a name, username, and password, then you'll see them in the page,
$user="";<---- User name you entered when making the database(prefixed with "a8314628_"),
$password="";<---- password you entered when making the database,
$database="a8314628_forum";<---- looks like you've got this part right,
$hostname="";<---- it will be shown where i mentioned above.,
click the MySql button, ALL the info is right there, if you've set up the db.

here's an example only:
$user="a8314628_something";
$password="password";
$database="a8314628_forum";
$hostname="mysql2.000webhost.com"

it looks like you put "databases.000webhost.com/localhost" somewhere, that's wrong

good luck

:)

Please Follow My step to Clear your Problem,

1) open your https://files.000webhost.com/ to upload OR add your file

2) inside public_html folder create 1 file call index.php

3) put this code inside this

    <?php
      define('HOST','localhost');
      define('USER','id847165_user');
      define('PASS','qwertyuiop');
      define('DB','id847165_db');
      $con = mysqli_connect(HOST,USER,PASS,DB);

if(isset($_POST['name'])){
      $name = $_POST['name'];
      $address = $_POST['address'];

        $sql = "insert into Persons (name,address) values ('$name','$address')";
      if(mysqli_query($con,$sql)){
        echo 'success';
      }
      else{
        echo 'failure';
      }
    }else{
echo 'Please send data in $_POST First';
}
      mysqli_close($con);
    ?>

4) close&save File

5) Run your website

edited Feb 23 '17 at 13:10

answered Feb 23 '17 at 11:24

Kaushik solanki

438
3
15

Hey got it? How to get your 00webhost **HOST NAME** ?? – Kaushik solanki Feb 23 '17 at 11:26
Hello sir I didn't get yoo how to take hostname – Arun Mohan Feb 23 '17 at 11:29
Your Hostname **databases.000webhost.com/localhost** is wrong. Please Get it from your hosting server **000webhost** U can read more about it Follow thia link.. https://www.000webhost.com/forum/t/i-need-help-in-connecting-my-database/6734 – Kaushik solanki Feb 23 '17 at 11:32
I can't find mysql.000 something thike that – Arun Mohan Feb 23 '17 at 11:41
log into your member's area, go to your account's CPanel, click on the MySql button and add a database, once that's done, it will show you the required info there. $user="put username here"; $password="put password here"; $database="put dbname here"; $hostname="something like mysql2.000webhost.com" mysql_connect($hostname,$user,$password); @mysql_select_db($database) or die( "Unable to select database"); – Kaushik solanki Feb 23 '17 at 11:43
In hostname it shows only localhost – Arun Mohan Feb 23 '17 at 11:46
See in the attached pic i have shown it in question – Arun Mohan Feb 23 '17 at 11:46
i think u can try to **hectographic-painte.000webhostapp.com** as host name but i m not sure.. as per your sceenshot display.. – Kaushik solanki Feb 23 '17 at 11:49
No i have tried it – Arun Mohan Feb 23 '17 at 11:50
Pease see my updated answer.. Where is your file uploaded ?? in **000webhost**?? – Kaushik solanki Feb 23 '17 at 11:55
I didn't get you sir how to get it – Arun Mohan Feb 23 '17 at 11:57
in files.000webhost.com – Arun Mohan Feb 23 '17 at 11:59
Please see my updated answer and follow my step, set Host name as "localhost" Problem is not there But U put **$_POST**, in script and Please Do it as i shown u in My answer.. – Kaushik solanki Feb 23 '17 at 12:22
Hey Dear got it or not? – Kaushik solanki Feb 23 '17 at 12:24
Fatal error: Uncaught Error: Call to undefined function issset() in /storage/h5/165/847165/public_html/index.php:8 Stack trace: #0 {main} thrown in /storage/h5/165/847165/public_html/index.php on line 8 – Arun Mohan Feb 23 '17 at 12:26
replace issset to **isset** – Kaushik solanki Feb 23 '17 at 12:27
update me if it's work.. – Kaushik solanki Feb 23 '17 at 12:28
There is no output as sucess – Arun Mohan Feb 23 '17 at 12:30
Without domain of hosting site and just local host how it works sir – Arun Mohan Feb 23 '17 at 12:32
yes your problem is solved.. Connection error is gone.. u want to send data in $_POST After that it's insert data in db.. PLease REad OR Google about Form And $_POST **I think u r new in PHP** – Kaushik solanki Feb 23 '17 at 12:33
Run this url And read what is there **http://hectographic-painte.000webhostapp.com/** – Kaushik solanki Feb 23 '17 at 12:34
If your problem is solve please up the vote :) – Kaushik solanki Feb 23 '17 at 12:34
Ya but now i need to connect with android devie how is it possible for that i created this script – Arun Mohan Feb 23 '17 at 12:35
Sir my problem is not still solved – Arun Mohan Feb 23 '17 at 12:37
First of all you just don't try to cheat beginners am not so fool as you ok just only one echo statement without condition so by default it will be displayed on screen – Arun Mohan Feb 23 '17 at 12:39
1

Hi @ArunMohan I think now you need to study how to call POST API from Android, Please have look in this tutorial: http://androidexample.com/How_To_Make_HTTP_POST_Request_To_Server_-_Android_Example/index.php?view=article_discription&aid=64........... The answer given by Kaushik solanki is good enought.....you should accept the answer as I think.....For more android help you can ask question for android. – Himanshu Feb 23 '17 at 12:49
`issset` there's 1 `s` too much here. so edit your answer here – Funk Forty Niner Feb 23 '17 at 13:08

score 1 · Answer 2 · edited May 23 '17 at 12:17

I tried below code and it gives me error like

Failed to connect to MySQL: Network is unreachable

000webhost only lets you access the database trough it's own PHP host

You can't access it from your own computer, unless you upgrade your account (by paying). Cannot connect to database (000webhost)

<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);

$con = mysqli_connect("databases.000webhost.com","id847165_user","qwertyuiop","id847165_db");

// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
else {
 echo 'connected';
}
?>

Possible solution https://www.youtube.com/watch?v=yYmVDNbFkEY — Naincy, Feb 23 '17 at 11:53

score 0 · Accepted Answer · answered Feb 23 '17 at 11:22

0

Use localhost as connection hostname.(Only if your file is in 000webhost server)

change 'databases.000webhost.com/localhost' to

'localhost'

answered Feb 23 '17 at 11:22

Kiran Benny Joseph

6,755
4
38
57

Sorry still error – Arun Mohan Feb 23 '17 at 11:29
Is your error get reduced or not? @ArunMohan – Kiran Benny Joseph Feb 23 '17 at 11:36
ya its now reduced – Arun Mohan Feb 23 '17 at 11:49
so what are the errors now – Kiran Benny Joseph Feb 23 '17 at 11:52
@ArunMohan I am the first one who answer it mann. Any way thanks – Kiran Benny Joseph Mar 18 '17 at 05:22

php script error i mysql connection error

3 Answers3

:)