Hfrhyu

Neighboring nodes in the network

In Romance of the Three Kingdoms why do people still use bamboo sticks when papers are already invented?

What exploit are these user agents trying to use?

A reference to a well-known characterization of scattered compact spaces

Is it unprofessional to ask if a job posting on GlassDoor is real?

How much of data wrangling is a data scientist's job?

How do I find out when a node was added to an availability group?

Can I use a neutral wire from another outlet to repair a broken neutral?

How to draw the figure with four pentagons?

Infinite Abelian subgroup of infinite non Abelian group example

Can a rocket refuel on Mars from water?

Can a virus destroy the BIOS of a modern computer?

Python: return float 1.0 as int 1 but float 1.5 as float 1.5

How can I prevent hyper evolved versions of regular creatures from wiping out their cousins?

Brothers & sisters

Can one be a co-translator of a book, if he does not know the language that the book is translated into?

1960's book about a plague that kills all white people

Why do I get two different answers for this counting problem?

Forgetting the musical notes while performing in concert

Why does Kotter return in Welcome Back Kotter

Emailing HOD to enhance faculty application

Is it legal for company to use my work email to pretend I still work there?

I would say: "You are another teacher", but she is a woman and I am a man

Anagram holiday

Query and display MySQL DB data from HTML

storing images in mysql from WebGIS applicationsparsing an osm-file with PHP simpleXML :: getting a few more tagsSubmit form information from a leaflet popup to MySQL tableTake data (points) from MySQL to Leaflet Map using PHP and AjaxReduce query time when using both MySQL and PostgreSQL with PostGISPgrouting PHP don't work with Openlayers and GeoExtSpatialite: 'no such function: GeomFromText' errorMySQL GeoJSON query for polygons format errorSpatial functions with MySQL, XAMPP, and WordpressAutomatically refresh Leaflet Markers from MySQL

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I want to link MySQL DB to the HTML and get the data according to the query below.

SELECT * FROM feature1 WHERE place = 'feature2'

php seems one of the way to do this, since I am one day old with php don't have much knowledge. I wrote the code below, but when run it gives me an error with no solid output. Is the code correct?

I want to query the DB using the above query and display data!!

<?php
$db = mysqli_connect('localhost','user','password','DB_name')
or die('Error connecting to MySQL server.');

> $query = "SELECT * FROM feature1";


mysqli_query($db, $query) or die('Error querying database..');
$result = mysqli_query($db, $query);
$row = mysqli_fetch_array($result);
while ($rows = mysql_fetch_array($query)) { 
 $name = $rows['Name'];
 $address = $rows['Address'];
 $email = $rows['Email']

 echo "$name<br>$address<br>$email<br>$subject<br>$comment<br><br>"; 
?>

javascript php html mysql

share|improve this question

edited 2 days ago

Vince

14.8k32849

asked Apr 1 at 16:20

AngelineAngeline

1

New contributor

Angeline is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  if using php you need to pull the data out a database and turn it into a html friendly format (xml/json) like this > stackoverflow.com/questions/5112282/…
  
  – Mapperz♦
  Apr 1 at 16:38
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes will try that thanks.
  
  – Angeline
  yesterday
  

  
  
  
  

add a comment | 

0

I want to link MySQL DB to the HTML and get the data according to the query below.

SELECT * FROM feature1 WHERE place = 'feature2'

php seems one of the way to do this, since I am one day old with php don't have much knowledge. I wrote the code below, but when run it gives me an error with no solid output. Is the code correct?

I want to query the DB using the above query and display data!!

<?php
$db = mysqli_connect('localhost','user','password','DB_name')
or die('Error connecting to MySQL server.');

> $query = "SELECT * FROM feature1";


mysqli_query($db, $query) or die('Error querying database..');
$result = mysqli_query($db, $query);
$row = mysqli_fetch_array($result);
while ($rows = mysql_fetch_array($query)) { 
 $name = $rows['Name'];
 $address = $rows['Address'];
 $email = $rows['Email']

 echo "$name<br>$address<br>$email<br>$subject<br>$comment<br><br>"; 
?>

javascript php html mysql

share|improve this question

edited 2 days ago

Vince

14.8k32849

asked Apr 1 at 16:20

AngelineAngeline

1

New contributor

Angeline is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  if using php you need to pull the data out a database and turn it into a html friendly format (xml/json) like this > stackoverflow.com/questions/5112282/…
  
  – Mapperz♦
  Apr 1 at 16:38
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes will try that thanks.
  
  – Angeline
  yesterday
  

  
  
  
  

add a comment | 

I want to link MySQL DB to the HTML and get the data according to the query below.

SELECT * FROM feature1 WHERE place = 'feature2'

php seems one of the way to do this, since I am one day old with php don't have much knowledge. I wrote the code below, but when run it gives me an error with no solid output. Is the code correct?

I want to query the DB using the above query and display data!!

<?php
$db = mysqli_connect('localhost','user','password','DB_name')
or die('Error connecting to MySQL server.');

> $query = "SELECT * FROM feature1";


mysqli_query($db, $query) or die('Error querying database..');
$result = mysqli_query($db, $query);
$row = mysqli_fetch_array($result);
while ($rows = mysql_fetch_array($query)) { 
 $name = $rows['Name'];
 $address = $rows['Address'];
 $email = $rows['Email']

 echo "$name<br>$address<br>$email<br>$subject<br>$comment<br><br>"; 
?>

javascript php html mysql

share|improve this question

edited 2 days ago

Vince

14.8k32849

asked Apr 1 at 16:20

AngelineAngeline

1

New contributor

Angeline is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

SELECT * FROM feature1 WHERE place = 'feature2'

<?php
$db = mysqli_connect('localhost','user','password','DB_name')
or die('Error connecting to MySQL server.');

> $query = "SELECT * FROM feature1";


mysqli_query($db, $query) or die('Error querying database..');
$result = mysqli_query($db, $query);
$row = mysqli_fetch_array($result);
while ($rows = mysql_fetch_array($query)) { 
 $name = $rows['Name'];
 $address = $rows['Address'];
 $email = $rows['Email']

 echo "$name<br>$address<br>$email<br>$subject<br>$comment<br><br>"; 
?>

share|improve this question

edited 2 days ago

Vince

14.8k32849

asked Apr 1 at 16:20

AngelineAngeline

1

New contributor

Angeline is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 2 days ago

Vince

14.8k32849

asked Apr 1 at 16:20

AngelineAngeline

1

New contributor

Angeline is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited 2 days ago

Vince

14.8k32849

edited 2 days ago

Vince

14.8k32849

asked Apr 1 at 16:20

AngelineAngeline

1

New contributor

Angeline is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked Apr 1 at 16:20

AngelineAngeline

1