I cannot seem to make this code work. It is also a base for my other page(update) that doesn't want to update.
The code is supposed to add information into the database.
The query works by itself. I thought that maybe query is too complex(because pro has fields that are connected to different tables: fundpro, city, typepro and city is connected to country), but since it works by itself I guess there is a way to make it work in PHP and I'm just doing it wrong.
In update page(link above to question and the code) form shows correct fields, so I assume there are no major mistakes in both pages, the problem is in the "delivery" of the information to the database or something.
I really need the insert-data page, it is practically the only page i really need in the end, and I cannot make it work to my org and pro tables, while my country tables has workable add and edit pages that is quite similar.
I ran out of ideas what might be the reason and I do not know how to make it work for me. Maybe someone sees the problem or knows an alternative approach?
tl;dr data doesn't get INSERTed into the database from the fields. query is coccer by itself, based on update.php file, form returns the information correctly.
Here are SQLFiddle and EER Diagram.
<?php
header('Content-type: text/html; charset=utf-8');
isset($_GET['submit'])?$submit=true:$submit=false;
if(!$submit){
?>
<!DOCTYPE html>
<html>
<head>
<style>h1{color:red;}label{color:darkred;}</style>
<title>Add project</title>
<meta charset=”UTF-8”>
</head>
<body>
<h1>Add project:</h1>
<form name="f1" action="" method="GET" onSubmit="return validateForm(this)">
<label>IDpro </label><input type="text" name="idpro"><br>
<label>numpro</label><input type="text" name="numpro" ><br>
<label>namepro </label><input type="text" name="namepro" ><br>
<label>datef </label><input type="text" name="datef" ><br>
<label>datet </label><input type="text" name="datet" ><br>
<label>descr </label><input type="text" name="descr" ><br>
<label>typepro </label><input type="text" name="typepro" ><br>
<label>fundpro </label><input type="text" name="fundpro" ><br>
<label>IDci </label><input type="text" name="idpro" ><br>
<input type="reset" value="clear">
<input type="submit" value="add" name="submit"><br>
</form>
</body>
</html>
<?php
}else{
include "../config.php";
isset($_GET['idpro']) ? $idpro=$_GET['idpro'] : $idpro='';
isset($_GET['numpro']) ? $numpro=$_GET['numpro'] : $numpro='';
isset($_GET['namepro']) ? $namepro=$_GET['namepro'] : $namepro='';
isset($_GET['datef']) ? $datef=$_GET['datef'] : $datef='';
isset($_GET['datet']) ? $datet=$_GET['datet'] : $datet='';
isset($_GET['descr']) ? $descr=$_GET['descr'] : $descr='';
isset($_GET['typepro']) ? $typepro=$_GET['typepro'] : $typepro='';
isset($_GET['fundpro']) ? $fundpro=$_GET['fundpro'] : $fundpro='';
isset($_GET['idci']) ? $idci=$_GET['idci'] : $idci='';
$sql="INSERT INTO pro(idpro, numpro, namepro, datef, datet, descr,typepro_idtypepro, fundpro_idfundpro, city_idci) VALUES (?,?,?,?,?,?,?,?,?)";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('ssddsiiii', $numpro, $namepro, $datef, $datet,$descr, $typepro_idtypepro, $fundpro_idfundpro, $city_idci, $idpro);
$stmt->execute();
$stmt->close();
$mysqli->close();
header("Location: view.php");
//}
}
?>
UPDATE: simpler code, same pattern:
header('Content-type: text/html; charset=utf-8');
isset($_GET['submit'])?$submit=true:$submit=false;
if(!$submit){
?>
<!DOCTYPE html>
<html>
<head>
<style>h1{color:red;}label{color:darkred;}</style>
<title>Add city</title>
<meta charset=”UTF-8”>
</head>
<body>
<h1>Add city:</h1>
<form name="f1" action="" method="GET" onSubmit="return validateForm(this)" >
<label>city id </label><input type="text" name="idci"><br>
<label>city </label><input type="text" name="nameci"><br>
<label>country id </label><input type="text" name="country_idco"><br>
<input type="reset" value="clear">
<input type="submit" value="add" name="submit"><br>
</body>
</html>
<?php
}else{
include "../config.php";
isset($_GET['idci'])?$idci=$_GET['idci']:$idci='';
isset($_GET['nameci'])?$nameci=$_GET['nameci']:$nameci='';
// isset($_GET['nameco'])?$nameco=$_GET['nameco']:$nameco='';
isset($_GET['idco'])?$idco=$_GET['idco']:$idco='';
//if(($name!='')&&($nameci!='')&&($nameco!='')){
//echo "$name $nameci $nameco";
$sql="INSERT INTO city(idci, nameci,country_idco) VALUES (?,?,?)";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('isi', $idci, $nameci, $country_idco);
$stmt->execute();
$stmt->close();
$mysqli->close();
header("Location: view.php");
//}
}
You are only allowing for 9 parameters in your insert statement but are passing through 10 in your bind_param method.
<label>IDpro </label><input type="text" name="idpro"><br>
<label>numpro</label><input type="text" name="numpro" ><br>
<label>namepro </label><input type="text" name="namepro" ><br>
<label>datef </label><input type="text" name="idpro" ><br>
<label>datet </label><input type="text" name="idpro" ><br>
<label>descr </label><input type="text" name="descr" ><br>
<label>typepro </label><input type="text" name="numpro" ><br>
<label>fundpro </label><input type="text" name="numpro" ><br>
<label>IDci </label><input type="text" name="idpro" ><br>
You have set the name of multiple input fields to same value. Like:
<label>typepro </label><input type="text" name="numpro" ><br>
<label>fundpro </label><input type="text" name="numpro" ><br>
Your Query:
$sql="INSERT INTO pro(idpro, numpro, namepro, datef, datet, descr,typepro_idtypepro, fundpro_idfundpro, city_idci) VALUES (?,?,?,?,?,?,?,?,?)";
You see there the order - (idpro, numpro, namepro, datef, datet, descr,typepro_idtypepro, fundpro_idfundpro, city_idci); Your database expects the arguments you provide to match them. So, the first argument will be mapped onto idpro. If you send idpro as the last argument, it will be mapped to city_idci causing datatype mismatch error.
Correct your order and get your basics right.