What should I do about this if else statement?

Question

1.00/5 (3 votes)

See more:

if($sql){
echo "alert('New record successfully added!');";
echo "document.location='insert.php';";
}else{
echo "alert('Something Went Wrong!!!!');";
}

WHATS WRONG WITH THIS CODE PLEASE HELP ME .

IN MY LOCALHOST I INPUT DATA AND WHEN I CLICK SUBMIT IT SAYS "SOMETHING WENT WRONG " WHICH IS THE ELSE STATEMENT. i DONT KNOW ABOUT THIS .PLEASE HELP

What I have tried:

i TRIED EVERYTHING ,AND I FAILED ! i AM SEEKING HELP FROM SOMEONE WHO HAVE HIGHER KNOWLEDGE ABOUT MY PROBLEM.tHANK YOU FOR HELPING ME IN ADVANCE

Posted 25-Oct-21 4:02am

Working Student Ph

Updated 25-Oct-21 9:31am

Add a Solution

Comments

Richard Deeming 25-Oct-21 11:27am

Start by fixing your CAPS LOCK key - PHP is at least partially case-sensitive, so trying to write PHP code with a keyboard which is obviously broken isn't going to work.

Unless your keyboard actually isn't broken, and you were just rudely yelling at us?

Working Student Ph 27-Oct-21 4:03am

ohh caps Lock ,Sorry guise .

2 solutions

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 · 2021-10-25T04:42:00

It means that ... something went wrong.

Most often, these kind of problems stem from bad SQL: bad syntax, bad table and / or column names, or using string concatenation to pass values instead of using parameterised queries.

So start with your code to generate the SQL command, and use the debugger (or inline logging / display statements) to examine exactly what it generates.
Once you have that, you can start lookinG for why it's failed - but until then you are just guessing - and so would we be!

Richard MacCutchan · Answer 2 · 2021-10-25T09:31:00

Solution 3

The main problem is that your error message is worse than useless. Obviously if $sql is false then something went wrong, but what do you expect your users to do when they see that message? You need to analyse exactly what went wrong and post a message that contains some useful information. As a first step add some log messages to your application so you can see what is happening.

Posted 25-Oct-21 9:31am

Richard MacCutchan

Comments

Working Student Ph 27-Oct-21 4:09am

Thank you everyone for giving me suggestion. This will help me improve on the future.