SQL INSERT code PHP

Question

I have been very confused on what is wrong with this php code, it only gives me blank pages.

$sql = "INSERT INTO `mosys`.`allcheck` 
(`cDate`, 
    `cCheckNo`, 
        `cClass`, 
            `cPayee`, 
                `cPayeeAddress`, 
                    `cSender`,
                        `cSenderAddress`, 
                            `cAmount`) 
VALUES (".getDateTime()."', 
        '$_POST[cCheckNo]', 
            '$_POST[cClass]', 
                '$_POST[cPayee]', 
                    '$_GET[cPayeeAddress]',
                        '$_POST[cSender]', 
                            '$_POST[cSenderAddress]', 
                                '$_POST[cAmount]');";

}

if (!mysqli_query($con,$sql))
  {
  die('Error: ' . mysqli_error($con));
  }
}

What seems to be wrong?

here is the layout link and the php link

What should it be outputting? It'll only print something if the query fails. Do you mean that it's not inserting anything, and you're not getting an error? — andrewsi
– andrewsi, Commented Jul 12, 2014 at 16:14
@andrewsi its not inserting anything on the database and also not showing error — Ely Besiño
– Ely Besiño, Commented Jul 12, 2014 at 16:17

Marvin · Accepted Answer · 2014-07-12 16:15:40Z

2

In your PHP Code is just one output declared: die(); So when there is no error, i think your code works well. Why are you expecting something else then a blank page?

answered Jul 12, 2014 at 16:15

Marvin

15714 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ely Besiño Over a year ago

if there is no error then it should insert something, but it does not insert anything and show no error

Marvin · Accepted Answer · 2014-07-12 16:29:20Z

0

Please try this:

$sql = "INSERT INTO mosys.allcheck 
(cDate, 
    cCheckNo, 
        cClass, 
            cPayee, 
                cPayeeAddress, 
                    cSender,
                        cSenderAddress, 
                            cAmount) 
VALUES ('".getDateTime()."', 
        '".$_POST[cCheckNo]."', 
            '".$_POST[cClass]."', 
               '".$_POST[cPayee]."', 
                    '".$_GET[cPayeeAddress]."', 
                        '".$_POST[cSender]."', 
                            '".$_POST[cSenderAddress]."', 
                                '".$_POST[cAmount]."')";

}

if (!mysqli_query($con,$sql))
  {
  die('Error: ' . mysqli_error($con));
  }
}

answered Jul 12, 2014 at 16:29

Marvin

15714 bronze badges

3 Comments

Marvin Over a year ago

what's the table name you want to insert in ?

Ely Besiño Over a year ago

table name is allcheck with cCheckNo as primary

Ely Besiño Over a year ago

here is the layout link and the php link

Collectives™ on Stack Overflow

SQL INSERT code PHP

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related