Hi, I am new in 000webhost. I have a concern regarding my database. My database has a table that contains about 10 rows and it is working perfectly in XAMP. Then I have uploaded my files to 000webhost in free account and created the exact database. my front-end works perfectly but the problem I have noticed is when I open my admin page and create new posts for my website, it does not display error but it is not uploading to my database and not post in my website. I tried to reduce my rows into six rows and it is working. My question is, is there a limit of rows for a free account? Thanks
100 tables, 1GB
A user had 3000+ rows so unsure if there is a limitation
Hi, sorry for my late reply. Still I can not figure out what went wrong with my site. Not sure if this concerns with the codes or with free account. As of now, what I am doing is creating new listings in my localhost using XAMPP then export my table and upload to my 000webhost account. Thanks for the reply by the way.
Hi, just another issue regarding with my database. I am creating a table for real estate. here is my insert that is working on my localhost and also in infinityfree but when i uploaded it to 000webhost, it doesn’t insert any data to database. Please note that it is my first time in php and mysql. Any help is really appreciated, thank you.
<?php $localhost = "host"; $username = "user"; $password = "pass"; $dbname = "dbname"; // create connection $connect = new mysqli($localhost, $username, $password, $dbname); // check connection if($connect->connect_error) { die("connection failed : " . $connect->connect_error); } else { // echo "Successfully Connected To Database"; }; $getDate=date_create('Asia/Manila'); $date = date_format($getDate,"M. d, Y"); $file_uploaded = date_format($getDate,"M. d, Y"); if(isset($_POST['submit'])){ $name = mysqli_real_escape_string($connect ,$_POST['name']); $address = mysqli_real_escape_string($connect ,$_POST['address']); $feature = mysqli_real_escape_string($connect ,$_POST['feature']); $descrip = mysqli_real_escape_string($connect ,$_POST['descrip']); $lotarea = mysqli_real_escape_string($connect ,$_POST['lotarea']); $floorarea = mysqli_real_escape_string($connect ,$_POST['floorarea']); $pricePerSqm = mysqli_real_escape_string($connect ,$_POST['pricePerSqm']); $floors = mysqli_real_escape_string($connect ,$_POST['floors']); $toiletbath = mysqli_real_escape_string($connect ,$_POST['toiletbath']); $carport = mysqli_real_escape_string($connect ,$_POST['carport']); $category = mysqli_real_escape_string($connect ,$_POST['category']); $developer = mysqli_real_escape_string($connect ,$_POST['developer']); $price = mysqli_real_escape_string($connect ,$_POST['price']); $res = mysqli_real_escape_string($connect ,$_POST['res']); $dp = mysqli_real_escape_string($connect ,$_POST['dp']); $mnth = mysqli_real_escape_string($connect ,$_POST['mnth']); $percentofdp = mysqli_real_escape_string($connect ,$_POST['percentofdp']); $transregfee = mysqli_real_escape_string($connect ,$_POST['transregfee']); $mnthchrge = mysqli_real_escape_string($connect ,$_POST['mnthchrge']); $equity = mysqli_real_escape_string($connect ,$_POST['equity']); $monthlyequity = mysqli_real_escape_string($connect ,$_POST['monthlyequity']); $loanableAmount = mysqli_real_escape_string($connect ,$_POST['loanableAmount']); $tcp = mysqli_real_escape_string($connect ,$_POST['tcp']); $loanpercent = mysqli_real_escape_string($connect ,$_POST['loanpercent']); $meta_descrip = mysqli_real_escape_string($connect ,$_POST['meta_descrip']); $meta_keywords = mysqli_real_escape_string($connect ,$_POST['meta_keywords']); $ytube = mysqli_real_escape_string($connect ,$_POST['ytube']); $file_name = mysqli_real_escape_string($connect ,$_POST['file_name']); //echo "
//" . $name . " Added successfully!
//
";
$target_dir="../images/";
$target_file= $target_dir . basename($_FILES["images"]["name"]);
$temp_file=$_FILES["images"]["name"];
if (empty($temp_file)) {
$message = "Please Add Featured Image";
echo "";
$connect->close();
}
move_uploaded_file($_FILES["images"]["tmp_name"], $target_file);
$pdf_dir="../files/";
$pdf_file= $pdf_dir . basename($_FILES["file"]["name"]);
$pdf=$_FILES["file"]["name"];
move_uploaded_file($_FILES["file"]["tmp_name"], $pdf_file);
$query="INSERT INTO propety (name,address,descrip,feature,lotarea,floorarea,pricePerSqm,floors,toiletbath,carport,category,developer,price,res,dp,mnth,percentofdp,transregfee,mnthchrge,equity,monthlyequity,loanableAmount,tcp,loanpercent,meta_descrip,meta_keywords,post_date,ytube,file,file_name,file_uploaded,images) VALUES ('$name','$address','$descrip','$feature','$lotarea','$floorarea','$pricePerSqm','$floors','$toiletbath','$carport','$category','$developer','$price','$res','$dp','$mnth','$percentofdp','$transregfee','$mnthchrge','$equity','$monthlyequity','$loanableAmount','$tcp','$loanpercent','$meta_descrip','$meta_keywords','$date','$ytube','$pdf','$file_name','$file_uploaded','$temp_file')";
// Multiple Images For Property Gallery
$insert=$connect->query($query);
$last_id = $connect->insert_id;
$feats_id = $last_id;
$number = count($_POST["features"]);
$c=count($_FILES['img']['name']);
if ($c < 3) {
$message = "Please Add At Least 3 Images For Gallery";
echo "";
$connect->close();
}
if($insert){
if($c < 10){
for ($i=1; $i <$c; $i++) {
$img_name=$_FILES['img']['name'][$i];
move_uploaded_file($_FILES['img']['tmp_name'][$i] , "../images/" .$img_name);
$query_multi="INSERT INTO details(images,proid) VALUES ('$img_name','$last_id')";
$ins=$connect->query($query_multi);
}
}
if($number > 1)
{
for($i=0; $i<$number; $i++)
{
if(trim($_POST["features"][$i] != ''))
{
$query_feats = "INSERT INTO prop_feats (features, feat_id) VALUES('".mysqli_real_escape_string($connect, $_POST["features"][$i])."','".$feats_id."')";
mysqli_query($connect, $query_feats);
}
}
//echo "Features Added To Property";
}
else
{
echo "Please Enter At Least One Feature";
}
}
// Property Features
// Err Messages
if($connect->query($query,$query_feats,$query_multi) === TRUE) {
$message = "Something went wrong! Please check your inputs";
echo "";
$connect->close();
}
else {
if(isset($_GET['posts'])){
$id=$_GET['posts'];
$res= "SELECT id FROM propety where id='$id'";
$result = mysqli_query($connect, $res);
if (mysqli_num_rows($result) > 0) {
$row = mysqli_fetch_assoc($result);
}else {
$errorMsg = 'Could not Find Any Record';
}
$img = $row['images'];
}
echo "";
}
$connect->close();
}
?>