Fetching data from MySQL database using PHP Displaying it in a form for editing

Question

I m a newbie to this and wrote the code below to fetch user data from a MySQL Database and display it in a form for editing and saving  Problem is  it does not work  Any help will be appreciated    lt html gt       lt head gt           lt title gt  Delegate edit form lt  title gt       lt  head gt       lt body gt          Delegate update form   lt p gt               lt  php              usernm      root                passwd                      host        localhost                database    swift                   Name   POST  Name                   Username   POST  User name                   Password   POST  Password                 mysql connect  host  usernm  passwd                mysql select db  database                 sql       SELECT   FROM usermaster WHERE User name   Username                 result   mysql query  sql  or die mysql error                 while   row      mysql fetch array  result                                   Name        row  Name                     Username    row  User name                     Password    row  User password                                gt           lt form action  Delegate update php  method  post  gt              Name              lt input type  text  name   Name  value    lt  php echo  row   Name      gt   size 10 gt              Username              lt input type  text  name   Username  value    lt  php echo  row   Username      gt   size 10 gt              Password              lt input type  text  name   Password  value    lt  php echo  row   Password      gt   size 17 gt               lt input type  submit  name   submit  value  Update  gt           lt  form gt       lt  body gt   lt  html gt

User · Answer

please try these    lt form action  Delegate update php  method  post  gt  Name  lt input type  text  name   Name  value    lt  php echo  row  Name      gt   size 10 gt  Username  lt input type  text  name   User name  value    lt  php echo  row  User name      gt   size 10 gt  Password  lt input type  text  name   User password  value    lt  php echo  row  User password      gt   size 17 gt   lt input type  submit  name   submit  value  Update  gt   lt  form gt

User · Answer

Play around this piece of code  Focus on the concept  edit where necessary so that it can    lt html gt   lt head gt       lt title gt  Delegate edit form lt  title gt   lt  head gt   lt body gt      Delegate update form   lt  p gt        lt meta name  viewport  content  width device-width  initial-scale 1 0  gt        lt link rel  shortcut icon  href  images favicon ico  type  image x-icon    gt         lt link href  http   fonts googleapis com css family Droid Serif Ubuntu  rel  stylesheet  type  text css  gt        lt link rel  stylesheet  href  css normalize css  gt       lt link rel  stylesheet  href  js flexslider flexslider css    gt       lt link rel  stylesheet  href  css basic-style css  gt           lt script src  js libs modernizr-2 6 2 min js  gt  lt  script gt        lt  head gt        lt body id  home  gt            lt header class  wrapper clearfix  gt                  lt nav id  topnav  role  navigation  gt                   lt div class  menu-toggle  gt Menu lt  div gt                   lt ul class  srt-menu  id  menu-main-navigation  gt                       lt li gt  lt a href  Swift Landing html  gt Home page lt  a gt  lt  li gt            lt  header gt           lt  section gt            lt style gt              form label                   display  inline-block                  width  100px                  font-weight  bold                         lt  style gt           lt  ul gt            lt  php         session start             usernm  root            passwd              host  localhost            database  swift             Username   SESSION  myssession               mysql connect  host  usernm  passwd            mysql select db  database             sql    SELECT   FROM usermaster WHERE User name   Username             result   mysql query   sql  or die  mysql error              while   row   mysql fetch array   result               gt            lt form action  Delegate update php  method  post  gt              Name              lt input type  text  name  Namex  value   lt  php echo  row   Name      gt    size 10 gt              Username              lt input type  text  name  Username  value   lt  php echo  row   User name      gt    size 10 gt              Password              lt input type  text  name  Password  value   lt  php echo  row   User password      gt   size 17 gt               lt input type  submit  name  submit  value  Update  gt           lt  form gt           lt  php                     gt           lt  p gt       lt  body gt   lt  html gt

User · Answer

lt form action  Delegate update php  method  post  gt    Name    lt input type  text  name   Name  value    lt  php echo  row  Name      gt   size 10 gt    Username    lt input type  text  name   Username  value    lt  php echo  row  Username      gt   size 10 gt    Password    lt input type  text  name   Password  value    lt  php echo  row  Password      gt   size 17 gt     lt input type  submit  name   submit  value  Update  gt   lt  form gt    look into this

User · Answer

lt form action  Delegate update php  method  post  gt  Name  lt input type  text  name   Name  value    lt  php echo  row  Name      gt   size 10 gt  Username  lt input type  text  name   Username  value    lt  php echo  row  Username      gt   size 10 gt  Password  lt input type  text  name   Password  value    lt  php echo  row  Password      gt   size 17 gt   lt input type  submit  name   submit  value  Update  gt   lt  form gt    You didnt closed your opening Form in the first place  plus your code is very very messy  I wont go into the  use pdo or mysqli statements  instead of mysql  thats for you to find out on yourself  Also you have a php tag open and close below it  not sure what is needed there  Something else is that your code refers to an external page  which you didnt post  so if something isnt working there  might be handy to post it too    Please also note that you had spaces between your  row array variables in the form  You have to link those up together by removing the space  see edited section from me   PHP isn t forgiving when it comes to those mistakes   Then your HTML  I took the liberty to correct that too   lt html gt       lt head gt           lt title gt  Delegate edit form lt  title gt       lt  head gt        lt body gt             lt p gt Delegate update form lt  p gt   lt  php  usernm  root    passwd      host  localhost    database  swift    mysql connect  host  usernm  passwd    mysql select db  database     sql    SELECT   FROM usermaster WHERE User name     Username         Please look at this too   result   mysql query  sql  or die  mysql error        dont put spaces in between it  else your code wont recognize it the query that needs to be executed while   row   mysql fetch array  result           here too  you put a space between it      Name  row  Name         Username  row  User name         Password  row  User password            gt    Also  try to be specific   It doesnt work  doesnt help us much  a specific error type is commonly helpful  plus any indication what the code should do  well  it was kinda obvious here  since its a login register edit here  but for larger chunks of code it should always be explained   Anyway  welcome to Stack Overflow

User · Answer

lt  php  include  cdb php    show mysqli query   conn  SELECT  FROM  reg       while  row1  mysqli fetch array  show                          id  row1  id                     Name   row1  name                     email    row1  email                     username    row1  username                     password   row1  password                     birthm    row1  bmonth                     birthd   row1  bday                     birthy   row1  byear                     gernder    row1  gender                     phone   row1  phone                     image  row1  image          gt     lt html gt   lt head gt  lt title gt hey lt  head gt  lt  title gt  lt  head gt    lt body gt    lt form gt   lt table border  -2  bgcolor  pink  style  width  12px  height  100px    gt        lt th gt      id lt input type  text  name    style  width  30px   value    lt  php echo  row1  id      gt     gt   lt  th gt    lt br gt   lt br gt        lt th gt    name  lt input type  text  name     style  width  60px   value    lt  php echo  row1  Name      gt    gt   lt  th gt    lt th gt   email lt input type  text  name    style  width  60px   value    lt  php echo  row1  email      gt     gt   lt  th gt   lt th gt      username lt input type  hidden  name    style  width  60px    value    lt  php echo  username  email      gt    gt   lt  th gt   lt th gt      password lt input type  hidden  name    style  width  60px    value    lt  php echo  row1  password      gt   gt   lt  ths gt    lt th gt      birthday month lt input type  text  name    style  width  60px    value    lt  php echo  row1  birthm      gt   gt   lt  th gt   lt th gt     birthday day lt input type  text  name    style  width  60px    value    lt  php echo  row1  birthd      gt   gt   lt  th gt   lt th gt         birthday year lt input type  text  name    style  width  60px   value    lt  php echo  row1  birthy      gt    gt   lt  th gt   lt th gt      gender lt input type  text  name    style  width  60px   value    lt  php echo  row1  gender      gt   gt   lt  th gt   lt th gt      phone number lt input type  text  name    style  width  60px   value    lt  php echo  row1  phone      gt   gt   lt  th gt   lt th gt       lt th gt       image lt input type  text  name    style  width  60px    value    lt  php echo  row1  image      gt   gt   lt  th gt    lt th gt    lt font color  pink  gt   lt a href  update php  gt update lt  a gt  lt  font gt    lt  th gt   lt  table gt    lt  body gt   lt  form gt   lt  body gt   lt  html gt

[php] Fetching data from MySQL database using PHP, Displaying it in a form for editing

Examples related to php

Examples related to mysql

Examples related to forms