Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Getting value from MySql database on to HTML Page

Author  Topic 

jchouk
Starting Member

2 Posts

Posted - 2013-11-24 : 09:24:53
I am trying to display a price from a table I created in MySQL to a web page. I have created a php form to open and select the home. The data base is simple with a table called homes fields home - size and 4 price fields one being mobile which I am showing here. My problem is figuring out how to get the information to show up on my index.php page. Below is the code I am using, I would appreciate any assistance.

php for opening database and file. data2.php
<?php
require('mysqli_connect.php');
$q = "SELECT * FROM homes WHERE home='solera'";
$result = @mysqli_query ($dbcon, $q);
echo '$result.$row['mobile']';

html on page to request it on designs.html
<div class="homes">
<div class="home"><img src="../images/homes/Solera.jpg" alt="Solera Home"/><br>
The Solera $<script src="data2.php">></script></div>
......

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2013-11-24 : 09:46:27
please post your MySQL question over at http://www.dbforums.com/mysql/

SQLTeam is on MS SQL Server


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

jchouk
Starting Member

2 Posts

Posted - 2013-11-24 : 10:10:33
OK Thanks
Go to Top of Page
   

- Advertisement -