PHP Inserting Values from the Form into MySQL

Question

I created a users table in mysql from the terminal and I am trying to create simple task  insert values from the form  This is my dbConfig file    lt  php  mysqli   new mysqli  localhost    root    pass    testDB        check connection    if  mysqli connect errno          printf  Connect failed   s n   mysqli connect error         exit        gt    and This is my Index php      lt  doctype html gt   lt html gt    lt head gt       lt meta charset  utf-8  gt       lt meta http-equiv  X-UA-Compatible  content  IE edge chrome 1  gt       lt meta name  description  content   1  gt       lt meta name  viewport  content  width device-width  initial-scale 1  gt        lt link rel  stylesheet  type  text css  href  style css  gt        lt title gt test lt  title gt        lt  php     include once  dbConfig php         gt    lt  head gt   lt body gt        lt  php     if isset   POST  save               sql    INSERT INTO users  username  password  email          VALUES       POST  username           POST  password           POST  email                      gt        lt form method  post  gt        lt label id  first  gt  First name  lt  label gt  lt br  gt       lt input type  text  name  username  gt  lt br  gt        lt label id  first  gt Password lt  label gt  lt br  gt       lt input type  password  name  password  gt  lt br  gt        lt label id  first  gt Email lt  label gt  lt br  gt       lt input type  text  name  email  gt  lt br  gt        lt button type  submit  name  save  gt save lt  button gt       lt button type  submit  name  get  gt get lt  button gt       lt  form gt    lt  body gt   lt  html gt    After hitting my save button  nothing happens  database is still empty  I tried echo ing the INSERT query and it takes all values from the form as it is supposed to  After I try to check if this worked from terminal  I login into my sql try to return all data from users table and I get empty set

User · Answer

There are two problems in your code    No action found in form  You have not executed the query mysqli query     dbConfig php   lt  php   conn mysqli connect  localhost   root   password   testDB     if   conn    die  Connection failed      mysqli connect error          gt    index php   include  dbConfig php      lt  Doctype html gt   lt html gt   lt head gt   lt meta charset  utf-8  gt   lt meta http-equiv  X-UA-Compatible  content  IE edge chrome 1  gt   lt meta name  description  content   1  gt   lt meta name  viewport  content  width device-width  initial-scale 1  gt    lt link rel  stylesheet  type  text css  href  style css  gt    lt title gt test lt  title gt     lt  head gt   lt body gt     lt  php    if isset   POST  save            sql    INSERT INTO users  username  password  email      VALUES       POST  username           POST  password           POST  email               result   mysqli query  conn  sql        gt    lt form action  index php  method  post  gt    lt label id  first  gt  First name  lt  label gt  lt br  gt   lt input type  text  name  username  gt  lt br  gt    lt label id  first  gt Password lt  label gt  lt br  gt   lt input type  password  name  password  gt  lt br  gt    lt label id  first  gt Email lt  label gt  lt br  gt   lt input type  text  name  email  gt  lt br  gt    lt button type  submit  name  save  gt save lt  button gt    lt  form gt    lt  body gt   lt  html gt

User · Answer

lt  php      username  root        password          database  test         get the data from form fields      Id   POST  Id         P name   POST  P name         address1   POST  address1         address2   POST  address2         email   POST  email         mysql connect localhost  username  password        mysql select db  database  or die  unable to select database         if   POST  insertrecord     insert             query  insert into person values   Id    P name    address1    address2    email             echo  inside           mysql query  query            query1  select   from person            result mysql query  query1            num  mysql numrows  result             echo  lt b gt output lt  b gt            print  lt table border size 1  gt            lt tr gt  lt th gt Id lt  th gt           lt th gt P name lt  th gt           lt th gt address1 lt  th gt           lt th gt address2 lt  th gt           lt th gt email lt  th gt           lt  tr gt             i 0          while  i lt  num                         Id mysql result  result  i  Id                 P name mysql result  result  i  P name                 address1 mysql result  result  i  address1                 address2 mysql result  result  i  address2                 email mysql result  result  i  email                echo  lt tr gt  lt td gt  Id lt  td gt               lt td gt  P name lt  td gt               lt td gt  address1 lt  td gt               lt td gt  address2 lt  td gt               lt td gt  email lt  td gt               lt  tr gt                 i                      print  lt  table gt               if   POST  searchdata     Search                  P name   POST  name             query  select   from person where P name   P name             result mysql query  query           print  lt table border size 1 gt  lt tr gt  lt th gt Id lt  th gt           lt th gt P name lt  th gt           lt th gt address1 lt  th gt           lt th gt address2 lt  th gt           lt th gt email lt  th gt           lt  tr gt            while  row mysql fetch array  result                          Id  row Id                P name  row P name                address1  row address1                address2  row address2                email  row email               echo  lt tr gt  lt td gt  Id lt  td gt               lt td gt  P name lt  td gt               lt td gt  address1 lt  td gt               lt td gt  address2 lt  td gt               lt td gt  email lt  td gt               lt  tr gt                      echo  lt  table gt              echo  lt a href lab2 html gt  Back  lt  a gt      gt

User · Answer

The following code just declares a string variable that contains a MySQL query    sql    INSERT INTO users  username  password  email      VALUES       POST  username           POST  password           POST  email           It does not execute the query  In order to do that you need to use some functions but let me explain something else first   NEVER TRUST USER INPUT  You should never append user input  such as form input from   GET or   POST  directly to your query  Someone can carefully manipulate the input in such a way so that it can cause great damage to your database  That s called SQL Injection  You can read more about it here  To protect your script from such an attack you must use Prepared Statements  More on prepared statements here  Include prepared statements to your code like this    sql    INSERT INTO users  username  password  email      VALUES             Notice how the   are used as placeholders for the values  Next you should prepare the statement using mysqli prepare    stmt   mysqli prepare  sql     Then start binding the input variables to the prepared statement    stmt- gt bind param  sss     POST  username      POST  email      POST  password       And finally execute the prepared statements   This is where the actual insertion takes place    stmt- gt execute      NOTE Although not part of the question  I strongly advice you to never store passwords in clear text  Instead you should use password hash to store a hash of the password

User · Answer

lt  DOCTYPE html gt   lt  php  con   new mysqli  localhost   root      form       gt      lt html xmlns  http   www w3 org 1999 xhtml  gt   lt head gt   lt script src  https   ajax googleapis com ajax libs jquery 3 2 1 jquery min js  gt  lt  script gt   lt meta http-equiv  Content-Type  content  text html  charset iso-8859-1    gt   lt title gt Untitled Document lt  title gt   lt script type  text javascript  gt    document  ready function          form   submit function e             btn1   click function e        e preventDefault           alert  here                apnew   append   lt input type  text  placeholder  Enter youy Name  name  e1     gt  lt br gt                           lt  script gt    lt  head gt    lt body gt   lt h2 gt  lt b gt Register Form lt b gt  lt  h2 gt   lt form method  post  enctype  multipart form-data  gt   lt table gt   lt tr gt  lt td gt Name  lt  td gt  lt td gt  lt input type  text  placeholder  Enter youy Name  name  e1     gt   lt div class  apnew  gt  lt  div gt  lt button id  btn1  gt Add lt  button gt  lt  td gt  lt  tr gt   lt tr gt  lt td gt Image  lt  td gt  lt td gt  lt input type  file   name  e5    multiple    accept  image jpeg image gif image png image jpg   gt  lt  td gt  lt  tr gt    lt tr gt  lt td gt Address  lt  td gt  lt td gt  lt textarea  cols  20  rows  4  name  e2  gt  lt  textarea gt  lt  td gt  lt  tr gt   lt tr gt  lt td gt Contact  lt  td gt  lt td gt  lt div id  textnew  gt  lt input  type  number   maxlength  10  name  e3   gt  lt  div gt  lt  td gt  lt  tr gt   lt tr gt  lt td gt Gender  lt  td gt  lt td gt  lt input type  radio   name  r1  value  Male  checked  checked   gt Male lt input type  radio   name  r1  value  feale   gt Female lt  td gt  lt  tr gt   lt tr gt  lt td gt  lt input  id  submit  type  submit  name  t1  value  save    gt  lt  td gt  lt  tr gt   lt  table gt   lt  php   echo   lt pre gt   print r   FILES  exit    if isset   POST  t1        values   implode         POST  e1      imgarryimp array    foreach   FILES  e5    tmp name   as  key  gt  val     move uploaded file   FILES  e5    tmp name    key   images     FILES  e5    name    key                           fname     FILES  e5    name    key                         imgarryimp    fname                         echo  fname                        if strlen  fname  gt 0                                                    img    fname                                                 d  insert into form name address contact gender image values   values     POST e2      POST e3      POST r1     img             if  con- gt query  d   TRUE                      echo  Yoy Data Save Successfully                   exit                                echo  values exit                          foreach   POST  e1   as  row                  d  insert into form name address contact gender image values   values     POST e2      POST e3      POST r1     img             if  con- gt query  d   TRUE                      echo  Yoy Data Save Successfully                               exit        gt    lt  form gt    lt table gt   lt  php   t  select   from form    y  con- gt query  t   foreach   y as  q       gt   lt tr gt   lt td gt Name  lt  php echo  q  name     gt  lt  td gt   lt td gt Address  lt  php echo  q  address     gt  lt  td gt   lt td gt Contact  lt  php echo  q  contact     gt  lt  td gt   lt td gt Gender  lt  php echo  q  gender     gt  lt  td gt   lt  tr gt   lt  php    gt   lt  table gt    lt  body gt   lt  html gt

User · Answer

When you click the Button   if isset   POST  save               sql    INSERT INTO  members   id    membership id    email    first name           VALUES       POST  id           POST  membership id           POST  email           POST  firstname               if   conn- gt query  sql      TRUE            echo  New record created successfully         else           echo  Error       sql     lt br gt      conn- gt error              This will execute the Query in the variable  sql       if   conn- gt query  sql      TRUE            echo  New record created successfully         else           echo  Error       sql     lt br gt      conn- gt error

User · Answer

Try this   dbConfig php   lt  php  mysqli   new mysqli  localhost    root    pwd    yr db name        if  mysqli- gt connect error                    echo  mysqli- gt connect error                  gt    Index php   lt html gt   lt head gt  lt title gt Inserting data in database table  lt  title gt   lt  head gt   lt body gt   lt form action  control table php  method  post  gt   lt table border  1  background  red  align  center  gt   lt tr gt   lt td gt Login Name lt  td gt   lt td gt  lt input type  text  name  txtname    gt  lt  td gt   lt  tr gt   lt br gt   lt tr gt   lt td gt Password lt  td gt   lt td gt  lt input type  text  name  txtpwd    gt  lt  td gt   lt  tr gt   lt tr gt   lt td gt  amp nbsp  lt  td gt   lt td gt  lt input type  submit  name  txtbutton  value  SUBMIT    gt  lt  td gt   lt  tr gt   lt  table gt  control table php  lt  php include  config php     gt   lt  php  name  pwd         if isset   POST  txtbutton                            name     POST  txtname                 pwd     POST  txtpwd                 mysqli- gt query  insert into users name pwd  values   name     pwd              if   mysqli             echo mysqli error          else               echo  Successfully Inserted  lt br   gt            echo   lt a href  show php  gt View Result lt  a gt                               gt

[php] PHP: Inserting Values from the Form into MySQL

Examples related to php

Examples related to html

Examples related to mysql