Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,150,474 members, 7,808,706 topics. Date: Thursday, 25 April 2024 at 03:45 PM

Please Webmasters, Read this. Pls - Webmasters - Nairaland

Nairaland Forum / Science/Technology / Webmasters / Please Webmasters, Read this. Pls (1212 Views)

Please Webmasters Read This / Please Webmasters I Need A Little Help With Making Money From My Site. / Please Webmasters, Read And Respond. I Am Confused (2) (3) (4)

(1) (Reply) (Go Down)

Please Webmasters, Read this. Pls by barackosama(m): 8:11pm On Nov 29, 2012
Please Webmasters, can anyone Kindly Teach Me how to Call Database Tables in Script?

Asin, if i want to Call this table ''b_user'' let me just say that is where my site Members are Stored. How can i display the List of Members?
Re: Please Webmasters, Read this. Pls by akintun: 9:52pm On Nov 29, 2012
If it is a php script, there are many ways u can do it. I'm typing from my iPad, so I won't be able to show u everything, and it depends on hw u want to arrange it.
<?
First connect to ur database

$sql = mysql_query("select * FROM members ORDER BY ..............);
while ($row = mysql_fetch_array($sql))
{
$b_user = $ row["b_user"];


}
?>
You can then echo $b_user anywhere on your HTML page.
You can also first declare an empty variable in d php, then latter assign your page layout to dat variable.
Re: Please Webmasters, Read this. Pls by cmespeak: 12:25pm On Nov 30, 2012
//ASSUMING U DEAL WITH PHP, U COULD EVEN GOOGLE THIS,DATS HOW MOST US US LEARN'T

<?php

//connect to database

require("connect.php"wink;


//now = table name


$sql="SELECT * FROM now";

$result=mysql_query($sql);



while($rows=mysql_fetch_array($result))

{ // Start looping table row

$id = $rows['id'];
$comment = $rows['comment'];
$name = $rows['name'];
$date= $rows['date'];
$name = ucwords($name);


//display table


echo <<<_END

<table width="740" border="0">
<tr>
<td width="713" height="24" colspan="2" align="left" valign="top" class="produt">$name</td>
</tr>
<tr>
<td width="713" height="24" colspan="2" align="left" valign="top" class="twwo">$date</td>
</tr>
<tr>
<td colspan="2" align="left" valign="top" class="bode">"$comment"</td>
</tr>
<tr>
<td height="16" colspan="2" align="left" valign="bottom"><hr align="left" width="100" height="10"/></td>
</tr>

</table>

_END;



}




?>
Re: Please Webmasters, Read this. Pls by barackosama(m): 4:15am On Dec 11, 2012
cmespeak: //ASSUMING U DEAL WITH PHP, U COULD EVEN GOOGLE THIS,DATS HOW MOST US US LEARN'T

<?php

//connect to database

require("connect.php"wink;


//now = table name


$sql="SELECT * FROM now";

$result=mysql_query($sql);



while($rows=mysql_fetch_array($result))

{ // Start looping table row

$id = $rows['id'];
$comment = $rows['comment'];
$name = $rows['name'];
$date= $rows['date'];
$name = ucwords($name);


//display table


echo <<<_END

<table width="740" border="0">
<tr>
<td width="713" height="24" colspan="2" align="left" valign="top" class="produt">$name</td>
</tr>
<tr>
<td width="713" height="24" colspan="2" align="left" valign="top" class="twwo">$date</td>
</tr>
<tr>
<td colspan="2" align="left" valign="top" class="bode">"$comment"</td>
</tr>
<tr>
<td height="16" colspan="2" align="left" valign="bottom"><hr align="left" width="100" height="10"/></td>
</tr>

</table>

_END;



}




?>

Thank you Brothers, i now Understand. Thanks Once again for taking your Time! smiley

(1) (Reply)

Ten African Internet Millionaires To Watch / Help / My Web App: NoPay - A Search Engine For Free Things Like Airtime, Data, Etc

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 15
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.