Uploading failed, please try agin

Question

When I click on "Add Country", localhost says : Uploading failed, please try again. Can you tell me where is the mistake please ?

<?php

    $db = new mysqli('localhost', 'root', '', 'db');

    if(isset($_POST["submit"]))
    {
        $c_code = addslashes($_POST["c_code"]);
        $c_name = addslashes($_POST["c_name"]);
        $c_key = addslashes($_POST["c_key"]);
        {
          $sql = "insert into countries(country_code, country_name, country_key) values('$c_code', '$c_name', '$c_key')";

          $rs = mysqli_query($db, $sql);

          if($rs)
          {
            echo "<script> alert('Country uploaded successfully') </script>";
          }

          else

          {
            echo "<script> alert('Uploading failed, please try again.') </script>";
          } 
        }
    }


?>

Try adding this to your query `$rs = mysqli_query($db, $sql) or die(mysqli_error($db));` — Kevin P, Jul 25 '17 at 20:49
Probably because you're looking for `mysqli_connect()` instead of `new mysqli()`. — Obsidian Age, Jul 25 '17 at 20:49
@Fred-ii- Didn't you used to post sql injection warnings? :P — GrumpyCrouton, Jul 25 '17 at 20:53
@GrumpyCrouton constantly at first, then my fingers cramped up. — Funk Forty Niner, Jul 25 '17 at 20:58
@Fred-ii- Do you use the copy-paste method? I've been looking for your post so I can copy it because I like the wording and the links you used, but I can't find a comment with your message :P — GrumpyCrouton, Jul 25 '17 at 20:59
@GrumpyCrouton I used to keep one, but TBH I lost its whereabouts for it. Maybe it'll surface when I'm not looking for something; isn't that how it always happens? *lol!* — Funk Forty Niner, Jul 25 '17 at 21:00
@Kevin P. When I used $rs = mysqli_query($db, $sql) or die(mysqli_error($db)); I've this Unknown column 'country_code' in 'field list' — nouamane18, Jul 25 '17 at 21:02

Peter Haddad · Accepted Answer · 2017-07-25T21:28:46.090

-1

<?php

$db = new mysqli('localhost', 'root', '', 'db');

if(isset($_POST["submit"]))
{
    $c_code = addslashes($_POST["c_code"]);
    $c_name = addslashes($_POST["c_name"]);
    $c_key = addslashes($_POST["c_key"]);

   //remove this:"{" 

      $sql = "insert into countries(country_code, country_name, country_key) values('$c_code', '$c_name', '$c_key')";

      $rs = mysqli_query($db, $sql);

      if($rs)
      {
        echo "<script> alert('Country uploaded successfully') </script>";
      }

      else

      {
        echo ("Error here:" .mysqli_error($db));
      } 
    }
  //also remove this: "}"

edited Jul 25 '17 at 21:28

answered Jul 25 '17 at 21:04

Peter Haddad

78,874
25
140
134

Please mention the modification done by you in this code. – Nana Partykar Jul 25 '17 at 21:26
I just removed the `{`, added a comment in the code and changed the `echo` to know what the error is @NanaPartykar – Peter Haddad Jul 25 '17 at 21:33
@Peter Partykar Uploading failed, please try again.Unknown column 'country_code' in 'field list' – nouamane18 Jul 25 '17 at 21:37
1

did you create `country_code` column in your table? @nouamane18 – Peter Haddad Jul 25 '17 at 21:50
Peter Haddad hit it right on the money. – Kevin P Jul 25 '17 at 21:56
@Peter Haddad - Thank you Peter – nouamane18 Jul 25 '17 at 22:09
@nouamane18 no problem :) glad I could help. – Peter Haddad Jul 25 '17 at 22:11

Uploading failed, please try agin

1 Answers1