Let’s say that I have two tables on my DB (table1 and table2, and both of them have the same structure.
JavaScript
x
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
-----------+---------+-----------+----------+---------+----------+--------------+-------------
name | text | | | | extended | |
days_week | text | | | | extended | |
datetime | tsrange | | | | extended | |
room | text | | | | extended | |
semester |text | | | |extended. | |
Indexes:
“table1_name_days_week_datetime_excel” EXCLUDE USING gist (name with=, days_week with=, date time with &&)
"table1_room_days_week_datetime_excel” EXCLUDE USING gist (room with=, days_week with=, datetime with &&)
My goal is to insert the data on the table that I’ll be deleting on the dropdown.
Sample if I select 1° semester on the dropdown all of the data will be added on the table1.
if I select 2° semester on the dropdown all of the data will be added on the table2.
This is what I have so far
JavaScript
<form name="testform" method='POST' action="add.php">
<label>Semester</label>
<select type="text" name=semester>
<option value=1ºsemester>1º semester</option>
<option value=2ºsemester>2º semester</option>
</select>
<input type=submit value=Registrar>
</form>
<?php
$semester=$_POST['semester'];
$con = @pg_connect ("port=5432 host=localhost dbname=postgres user=postgres password=a");
if($con == NULL) {
echo "Cannot Connect to database.";
exit (0);
}
$sql = "insert into ? (name, days_week, datetime, room, semester) values ('$name', '$days_week', '$datetime', '$room', '$semester');";
$res = @pg_query ($con, $sql);
if ($res == NULL){
echo "Error";
exit (0);
}
?>
Thanks in advance for any help
Advertisement
Answer
Just add a check before executing the query.
JavaScript
$semester=$_POST['semester'];
if($semester == '1ºsemester'){
$table = "table_1";
}else{
$table = "table_2";
}
$q = "insert into $table ........";
//Rest of your code