How do I update my numeric record in database ?

Question

1.00/5 (1 vote)

See more:

what I want to do is, everytime a user chooses an option from my dropdownlist on my registration form, the records on my database table adds up by 1.

I keep getting there error:

Fatal error: Uncaught mysqli_sql_exception: Unknown column 'information_service' in 'where clause' in C:\xampp\htdocs\user-page\user_interface\appointment.php:11 Stack trace: #0 C:\xampp\htdocs\user-page\user_interface\appointment.php(11): mysqli_query(Object(mysqli), 'UPDATE scoring ...') #1 {main} thrown in C:\xampp\htdocs\user-page\user_interface\appointment.php on line 11

HERE is the code of my form

HTML

<pre><body>
		<div class = "container-fluid">
			<form method= "post" action= "appointment.php">
				<h1>Book Appointment for Guidance</h1>
					<div class= "group">
					<select name="service" id ="services" onchange="enableType(this)">
						<option value ="0">--Choose Services--</option>
						<option value ="individual_inventory">Individual Inventory</option>
						<option value ="counselling_service">Counselling Services</option>
						<option value ="information_service">Information Services</option>
						<option value ="follow-up_service">Follow-up Services</option>
						<option value ="psychological_testing_and_evaluation">Psychological Testing and Evaluation</option>
						<option value ="referral">REFERRAL</option>
						<option value ="placement_service">Placement Services</option>


					<input name="submit" type ="submit" class="button" value="Submit">
			</form>
		</div>
</body>

What I have tried:

THis is my php code:

PHP

<pre><?php include_once('connect.php');

if(isset($_POST['submit'])){

    $serv =$_POST['service'];
    $type =$_POST['types'];
    $case =$_POST['cases'];

       if($serv){
           $mysql ="UPDATE scoring SET services_score = services_score + 1 WHERE services = $serv";
           mysqli_query($dbh,$mysql);
       }
       if($type){
        $mysqls ="UPDATE scoring SET types_score = types_score + 1 WHERE counseling_types= $type";
        mysqli_query($dbh,$mysqls);
    }
    if($case){
        $mysqlss ="UPDATE scoring SET cases_score = cases_score + 1 WHERE counseling_cases = $case";
        mysqli_query($dbh,$mysqlss);
    }
}

?>

The variable $serv is assigned for the <select> tag named 'service'. and the information_service from the error message is a value name for <option>Information Service. it is also a name of a row in my database. I have named the row and the value the same, so that, if the user chooses any from the option, then the code will execute to call the row from my database according to the user selected option. but the code recognizes the option value as a column name.

please help me

Posted 23-Nov-22 20:48pm

Robert Ramirez Nov2022

Updated 24-Nov-22 0:42am

v2

Add a Solution

Comments

Richard Deeming 24-Nov-22 8:25am

Your code is vulnerable to SQL Injection[^]. NEVER use string concatenation/interpolation to build a SQL query. ALWAYS use a parameterized query.
PHP: SQL Injection - Manual[^]

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2022-11-23T21:42:00

It's not that code - read the error message:

Error

unknown column 'information_service' in 'where clause' in C:\xampp\htdocs\user-page\user_interface\appointment.php:11

It can't find a column called information_service in your DB.

Since none of what you show us references information_service the problem is elsewhere in you code where we can't see it.
So start by looking at the file appointment.php and specifically at line number 11 - that's where the problem is being reported.