php mysql query not echoing in html with tags

Question

lt  php require  db php     gt    lt  php if  isset   POST  search        limit     POST  limit     country     POST  country     state     POST  state     city     POST  city     data   mysqli query  link  SELECT   FROM proxies WHERE country      country   AND state      state   AND city      city   LIMIT   limit     while   assoc   mysqli fetch assoc  data     proxy    assoc  proxy    echo   lt  lt  DOCTYPE html PUBLIC  -  W3C  DTD XHTML 1 0 Transitional  EN   http   www w3 org TR xhtml1 DTD xhtml1-transitional dtd  gt   lt html xmlns  http   www w3 org 1999 xhtml  gt   lt head gt   lt title gt Sock5Proxies lt  title gt   lt meta http-equiv  Content-Type  content  text html charset utf-8    gt   lt link href    style css  rel  stylesheet  type  text css    gt   lt link href    buttons css  rel  stylesheet  type  text css    gt   lt  head gt   lt center gt   lt h1 gt Sock5Proxies lt  h1 gt   lt  center gt   lt body gt   lt div id  wrapper  gt       lt div id  header  gt           lt ul id  nav  gt              lt li class  active  gt  lt a href  index html  gt  lt span gt  lt  span gt Home lt  a gt  lt  li gt               lt li gt  lt a href  leads html  gt  lt span gt  lt  span gt Leads lt  a gt  lt  li gt               lt li gt  lt a href  payout php  gt  lt span gt  lt  span gt Pay out lt  a gt  lt  li gt               lt li gt  lt a href  contact html  gt  lt span gt  lt  span gt Contact lt  a gt  lt  li gt               lt li gt  lt a href  logout php  gt  lt span gt  lt  span gt Logout lt  a gt  lt  li gt           lt  ul gt       lt  div gt       lt div id  content  gt           lt div id  center  gt               lt table cellpadding  0  cellspacing  0  style  width 690px  gt                   lt thead gt                       lt tr gt                           lt th width  75  class  first  gt Proxy lt  th gt                           lt th width  50  class  last  gt Status lt  th gt                       lt  tr gt                   lt  thead gt                   lt tbody gt                       lt tr class  rowB  gt                           lt td class  first  gt   lt  php echo  proxy   gt   lt  td gt                           lt td class  last  gt Check lt  td gt                       lt  tr gt                   lt  tbody gt               lt  table gt           lt  div gt       lt  div gt       lt  center gt       lt  center gt       lt div id  footer  gt  lt  div gt       lt span id  about  gt Version 1 0 lt  span gt   lt  div gt    lt  body gt   lt  html gt          gt   lt html gt   lt form action    method  POST  gt   lt input type  text  name  limit  placeholder  10   gt  lt br gt   lt input type  text  name  country  placeholder  Country   gt  lt br gt   lt input type  text  name  state  placeholder  State   gt  lt br gt   lt input type  text  name  city  placeholder  City   gt  lt br gt   lt input type  submit  name  search  value  Search    gt  lt br gt   lt  form gt   lt  html gt    I m receiving no errors now on line 47  this is supposed to be printing out my query  it works without the html  amp  styling  before you ask yes the theme does work  as of style css

User · Answer

lt td class  first  gt   lt  php echo  proxy   gt   lt  td gt  is inside a literal string that you are echoing   End the string  or concatenate it correctly    lt td class  first  gt      proxy     lt  td gt

User · Answer

I can spot a few different problems with this  However  in the interest of time  try this chunk of code instead    lt  php require  db php     gt    lt  php if  isset   POST  search            limit     POST  limit         country     POST  country         state     POST  state         city     POST  city         data   mysqli query           link           SELECT   FROM proxies WHERE country      country   AND state      state   AND city      city   LIMIT   limit              while   assoc   mysqli fetch assoc  data              proxy    assoc  proxy              gt               lt  DOCTYPE html PUBLIC  -  W3C  DTD XHTML 1 0 Transitional  EN                   http   www w3 org TR xhtml1 DTD xhtml1-transitional dtd  gt               lt html xmlns  http   www w3 org 1999 xhtml  gt                   lt head gt                       lt title gt Sock5Proxies lt  title gt                       lt meta http-equiv  Content-Type  content  text html charset utf-8    gt                       lt link href    style css  rel  stylesheet  type  text css    gt                       lt link href    buttons css  rel  stylesheet  type  text css    gt                   lt  head gt                   lt body gt                       lt center gt                           lt h1 gt Sock5Proxies lt  h1 gt                       lt  center gt                       lt div id  wrapper  gt                           lt div id  header  gt                               lt ul id  nav  gt                                   lt li class  active  gt  lt a href  index html  gt  lt span gt  lt  span gt Home lt  a gt  lt  li gt                                   lt li gt  lt a href  leads html  gt  lt span gt  lt  span gt Leads lt  a gt  lt  li gt                                   lt li gt  lt a href  payout php  gt  lt span gt  lt  span gt Pay out lt  a gt  lt  li gt                                   lt li gt  lt a href  contact html  gt  lt span gt  lt  span gt Contact lt  a gt  lt  li gt                                   lt li gt  lt a href  logout php  gt  lt span gt  lt  span gt Logout lt  a gt  lt  li gt                               lt  ul gt                           lt  div gt                           lt div id  content  gt                               lt div id  center  gt                                   lt table cellpadding  0  cellspacing  0  style  width 690px  gt                                       lt thead gt                                       lt tr gt                                           lt th width  75  class  first  gt Proxy lt  th gt                                           lt th width  50  class  last  gt Status lt  th gt                                       lt  tr gt                                       lt  thead gt                                       lt tbody gt                                       lt tr class  rowB  gt                                           lt td class  first  gt   lt  php echo  proxy   gt   lt  td gt                                           lt td class  last  gt Check lt  td gt                                       lt  tr gt                                       lt  tbody gt                                   lt  table gt                               lt  div gt                           lt  div gt                           lt div id  footer  gt  lt  div gt                           lt span id  about  gt Version 1 0 lt  span gt                       lt  div gt                   lt  body gt               lt  html gt           lt  php           gt   lt html gt   lt form action    method  POST  gt       lt input type  text  name  limit  placeholder  10    gt  lt br gt       lt input type  text  name  country  placeholder  Country    gt  lt br gt       lt input type  text  name  state  placeholder  State    gt  lt br gt       lt input type  text  name  city  placeholder  City    gt  lt br gt       lt input type  submit  name  search  value  Search    gt  lt br gt   lt  form gt   lt  html gt

User · Answer

You need to append your variables to the echoed string  For example   echo  This is a string    PHPvariable   and this is more string

User · Answer

Change  lt  php echo  proxy   gt  to      proxy       You use  lt  php when you re outputting HTML by leaving PHP mode with   gt   When you using echo  you have to use concatenation  or wrap your string in double quotes and use interpolation

[php] php & mysql query not echoing in html with tags?

Examples related to php