Home>
I want to register the contents entered in the input form with PHP in the database.
I checked it myself, but I can't solve it.
Is there a problem with the insert statement? .
The error has been resolved, but the input is not registered in the database.
I do not know if there is a problem with poison.
No error message is displayed, but the input is not registered in the database
Applicable source code<html>
<head>
<meta http-equiv = "Content-Type" content = "text/html;charset = utf-8" />
<title>Assign assignment</title>
</head>
<body>
New assignment registration
<form action = "database2.php" method = "POST">
<p>No.</p>
<input type = "text" name = "id" value = "" size = "50">
<br>
<table border = '1'>
<tr>
<th width = "100" nowrap>FY</th>
<th width = "100" nowrap>Class</th>
<th width = "100" nowrap>times</th>
<th width = "100" nowrap>Type</th>
<th width = "100" nowrap>Genre</th>
<th width = "100" nowrap>Difficulty</th>
</tr>
<tr>
<th width = "100" nowrap>
<select name = "year">
<option value = "">2019</option>
<option value = "">2018</option>
</select>
<th width = "100" nowrap>
<select name = "class">
<option value = "">1</option>
<option value = "">2</option>
<option value = "">3</option>
<option value = "">4</option>
<option value = "">5</option>
<option value = "">6</option>
<option value = "">7</option>
<option value = "">8</option>
<option value = "">9</option>
</select><th width = "100" nowrap>
<select name = "number">
<option value = "">1st</option>
<option value = "">Part 2-3</option>
<option value = "">4-5</option>
<option value = "">No. 6-7</option>
<option value = "">8-9</option>
<option value = "">10th</option>
<option value = "">11-12th</option>
<option value = "">13-14</option>
<option value = "">15th</option>
</select>
<th width = "100" nowrap>
<select name = "genre">
<option value = "">Attendance assignment</option>
<option value = "">Basic assignment</option>
<option value = "">Development issues</option>
</select>
<th width = "100" nowrap>
<select name = "mso">
<option value = "">Word</option>
<option value = "">Excel</option>
<option value = "">PowerPoint</option>
<option value = "">Other</option>
</select>
<th width = "100" nowrap>
<select name = "level">
<option value = "">Easy</option>
<option value = "">Normal</option>
<option value = "">Difficult</option>
</select>
</tr>
</table>
<p>Title of the assignment<br>
<input type = "text" name = "practice" value = "" size = "50">
<p>Deadline<br>
<input type = "text" name = "time" value = "" size = "50">
<p>Included content (target)<br>
<input type = "text" name = "purpose" value = "" size = "200">
<p>Samples and other points to consider<br>
<input type = "text" name = "other" value = "" size = "200">
<p>Agenda file<br>
<input type = "text" name = "file" value = "" size = "50">
<p><input type = "submit" value = "Register with the above contents"></p>
</form>
</body>
</html><html><head>
<meta http-equiv = "Content-Type" content = "text/html;charset = utf-8" />
<title>Assign assignment</title>
</head>
<body>
<? php
$con = mysqli_connect ('localhost', 'root', '2019minato');
if (! $con) {
exit ('Could not connect to database');
}
$result = mysqli_select_db ($con, 'test');
if (! $result) {
exit ('Database could not be selected');
}
$result = mysqli_query ($con, 'SET NAMES utf8');
if (! $result) {
exit ('The character code could not be specified.');
}
$id = filter_input (INPUT_GET, 'id');
$year = filter_input (INPUT_GET, 'year');
$class = filter_input (INPUT_GET, 'class');
$number = filter_input (INPUT_GET, 'number');
$mso = filter_input (INPUT_GET, 'mso');
$genre = filter_input (INPUT_GET, 'genre');
$level = filter_input (INPUT_GET, 'level');
$practice = filter_input (INPUT_GET, 'practice');
$time = filter_input (INPUT_GET, 'time');
$purpose = filter_input (INPUT_GET, 'purpose');
$other = filter_input (INPUT_GET, 'other');
$file = filter_input (INPUT_GET, 'file');
$result = mysqli_query ($con, "INSERT INTO bank (id, year, class, number, mso, genre, level, practice, time, purpose, other, file) VALUES ('$id', '$year', ' $class', '$number', '$mso', '$genre', '$level', '$practice', '$time', '$purpose', '$other', '$file') " );
if (! $result) {
exit ('Data could not be registered');
}
$con = mysqli_close ($con);
if (! $con) {
exit ('Could not close connection with database');
}
?>
<p>Registration is complete.<br />Back</p>
</body>
</html>Please describe what you tried for the problem here.
Supplemental information (FW/tool version etc.)Please provide more information here.
-
Answer # 1
-
Answer # 2
There are no definitions.
$id is defined in the if statement.
This will use an undefined variable in the SQL statement.$id = "";
If you write
if () {
$id = ...
}, it will not be undefined.
Related articles
- php - an error that i personally cannot solve
- php - variable undefined error when updating view file with laravel
- php fatal error "cannot redeclare" error statement
- php - event cannot be picked up when button is written in modal with jquery
- [php] if the destination file of the form is hit directly with the url, the value cannot be passed
- php - wordpress custom taxonomy cannot be saved/selected as a tag from the article posting screen of the management screen
- [php/html] cannot default a specific value in the pull-down
- cannot migrate in php-laravel mysql environment
- php fatal error: call to a member function fetchrow () does not show site
- i want to check the form input with php, display an error on the same page if it is not filled in, and move to another page only
- php - i get the error typeerror: cannot read property'id' of undefined while implementing the message posting function
- php - csv download of data cannot download when the number of columns increases
- php - wordpress shows an error that css is not reflected
- python 3x - [python] [selenium] i get an error when i put a variable in find_element_by_xpath
- php - the id of the edited data in view cannot be obtained on the confirmation screen
- php - cannot display the value of the many-to-many relationship destination table in view
- i want to issue an error message on the same page if there is no input in the php input form i want to move to another page only
- php - [laravel 6] cannot implement multiple tag search function
- i get a local variable error in python
- php - i want to display an error or redirect
Related questions
- php - database i want to be able to select any sort
- php - does the value exist in the database? but when i visit the details page, it returns 404 (test)
- php - laravel relation cannot be defined
- i want to know an efficient way to learn fuelphp from now on
- php - regarding when extracting laravel relation defined data
- php - what is the best way to save balances in mysql?
- php - laravel can't access local mysql
- php - when making a subscription with ec-cube, i would like to add a function that automatically places orders on behalf of cust
- i want to delete all db table data from php
- php - i want to solve the problem that an error occurs as soon as i put $result = $stmt-> fetch (pdo :: fetch_assoc) ;
Maybe it ’s the Notice
I think it's a line
Isn't it strange that logic is checking $_REQUEST with isset?
It is set to $id only when isset, but conversely, if it gets caught by isset, $id is undefined
Please rewrite as follows.
Moreover, although insert statements are currently issued unconditionally, conditional branching may be necessary.
It is recommended to process mysqli with prepare instead of passing by value directly
By the way, if you quit mysqli and use pdo, there will be a lot more useful sites, etc.