Free 000webhostapp database connection

#1

I am not able to get connect in database using following codes.

define ('DB_NAME', 'id1011985_ostadshagerdi');
define ('DB_USER', 'id1011985_ghufranataie');
define ('DB_PASSWORD', '**********');
define ('DB_HOST', 'ostadshagerdi.000webhostapp.com');

$link = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD);

The Error is

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /storage/h6/985/1011985/public_html/register.php:8 Stack trace: #0 {main} thrown in /storage/h6/985/1011985/public_html/register.php on line 8
#2

You are using deprecated mysql function…so downgrade your php version to 5.4 and then try again.
“settings” – “general” – “php version”

#3

Can you suggest other cods to connect database using provided database and host info. if you write please

#4

Check the below link…you will get help.

1 Like
#5

thank you I read it but still I am having problem if you please check the following codes.

<?php $servername = "localhost"; $username = "root"; $password = ""; $database = "test"; // Create connection $conn = mysqli_connect($servername, $username, $password, $database); // Check connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } echo "Connected successfully"; header("Location: register.html"); $value1=$_POST['txtname']; $value2=$_POST['cellnumber']; $value3=$_POST['dist']; $value4=$_POST['specialization']; $value5=$_POST['membername']; $value6=$_POST['date']; $sql = "INSERT INTO students (StudentName, CellNumber, District, Specialization, PromotionMember, Date) VALUES ('$value1', '$value2', '$value3', '$value4', '$value5', '$value6')"; if (!mysql_query($sql)) { //*line27 die ('Error: ' . mysql_error()); } else { echo ("معلومات ارایه شده شما ثبت شد"); header("Location: register.html"); } mysql_close(); ?>

and the error is

#6

Try this:- Made few changes

<?php

$servername = "localhost";
$username = "root";
$password = "";
$database = "test";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $database);

// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}

echo "Connected successfully";
header("Location: register.html");

$value1=$_POST['txtname'];
$value2=$_POST['cellnumber'];
$value3=$_POST['dist'];
$value4=$_POST['specialization'];
$value5=$_POST['membername'];
$value6=$_POST['date'];
$sql = "INSERT INTO students (StudentName, CellNumber, District, Specialization, PromotionMember, Date)
VALUES ('$value1', '$value2', '$value3', '$value4', '$value5', '$value6')";

if (!mysqli_query($sql)) { //*line27
die ('Error: ' . mysql_error());
}
else
{ 
echo ("معلومات ارایه شده شما ثبت شد");
header("Location: register.html");
}
mysqli_close();
?>
#7

Try the above and see if it works or not.

#8
<?php $servername = "localhost"; $username = "root"; $password = ""; $database = "test"; // Create connection $conn = mysqli_connect($servername, $username, $password, $database); // Check connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } echo "Connected successfully"; $value1=$_POST['txtname']; $value2=$_POST['cellnumber']; $value3=$_POST['dist']; $value4=$_POST['specialization']; $value5=$_POST['membername']; $value6=$_POST['date']; $sql = "INSERT INTO students (StudentName, CellNumber, District, Specialization, PromotionMember, Date) VALUES ('$value1', '$value2', '$value3', '$value4', '$value5', '$value6')"; if (!mysqli_query($sql)) { die ('Error: ' . mysql_error()); } else { echo ("معلومات ارایه شده شما ثبت شد"); header("Location: register.html"); } mysqli_close(); ?>

connection is successfull but data insertion is getting error on line 23 which is (if (!mysqli_query($sql)) { )

#9

Now try this…

<?php
$servername = "localhost";
$username = "root";
$password = "";
$database = "test";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $database);

// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
$value1=$_POST['txtname'];
$value2=$_POST['cellnumber'];
$value3=$_POST['dist'];
$value4=$_POST['specialization'];
$value5=$_POST['membername'];
$value6=$_POST['date'];
$sql = "INSERT INTO students (StudentName, CellNumber, District, Specialization, PromotionMember, Date)
VALUES ('$value1', '$value2', '$value3', '$value4', '$value5', '$value6')";
if (!mysqli_query($conn, $sql)) { 
die ('Error: ' . mysql_error());
}
else
{ 
echo ("معلومات ارایه شده شما ثبت شد");
header("Location: register.html");
}
mysqli_close();
?>

You need to add the connection variable as the first argument which in this case is $conn(in line 23)

#10

Thank you That problem solved but still not inserting data to database

#11

I’m not exactly sure now…Try this forum you’ll get help.
https://forums.phpfreaks.com/

#12

is your issue solved??

#13

Thank you so much it helped me so much to connect to my database
Thanks again…

1 Like
#14