You are viewing our Forum Archives. To view or take place in current topics click here.
PhP MySQL help please
Posted:
PhP MySQL help pleasePosted:
Status: Offline
Joined: Nov 28, 20149Year Member
Posts: 21
Reputation Power: 0
I'm basically trying to get PhP to display all of the contents of the table in by website. Here's the code, I know that the passwords e.c.t are all correct, so it's not that.
<?php
$dbhost = '******';
$dbuser = 'root';
$dbpass = '*******';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}
$sql = 'SELECT * FROM online';
mysql_select_db('****');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not get data: ' . mysql_error());
}
while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
{
echo "online :{$row['name']} <br>".
}
echo "Fetched data successfully\n";
mysql_close($conn);
?>
<?php
$dbhost = '******';
$dbuser = 'root';
$dbpass = '*******';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}
$sql = 'SELECT * FROM online';
mysql_select_db('****');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not get data: ' . mysql_error());
}
while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
{
echo "online :{$row['name']} <br>".
}
echo "Fetched data successfully\n";
mysql_close($conn);
?>
#2. Posted:
Status: Offline
Joined: Mar 04, 201014Year Member
Posts: 2,891
Reputation Power: 150
Status: Offline
Joined: Mar 04, 201014Year Member
Posts: 2,891
Reputation Power: 150
First and foremost, don't use mysql_* functions. Instead, use PDO.
This works and is in PDO:
Picture of DB Structure and it working (don't know why you would need this, just thought I'd throw it in there)
Enjoy.
This works and is in PDO:
<?php
$con = mysql_connect('localhost', 'root', '');
@mysql_select_db('test') or die( "Unable to select database");
$db = new PDO('mysql:host=' . 'localhost' . ';dbname=' . 'test', 'root', '');
$sql = $db->query("SELECT * FROM `bullshit`");
while($q = $sql->fetch(PDO::FETCH_ASSOC)) {
echo $q['ID'].'-'.$q['name'].'-'.$q['desc1'].'-'.$q['desc2'].'<br>';
}
?>
Picture of DB Structure and it working (don't know why you would need this, just thought I'd throw it in there)
Enjoy.
- 1useful
- 0not useful
#3. Posted:
Status: Offline
Joined: Mar 21, 200915Year Member
Posts: 471
Reputation Power: 20
Status: Offline
Joined: Mar 21, 200915Year Member
Posts: 471
Reputation Power: 20
instead of using a wildcard to select all the columns in a table explicitly call them
like
<code>
<?php
$dbhost = '******';
$dbuser = 'root';
$dbpass = '*******';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}
$sql = "SELECT first, last, age, DOB from online";
mysql_select_db('****');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not get data: ' . mysql_error());
}
while($row = mysql_fetch_assoc($retval))
{
echo "online :{$row['first']} <br />";
}
echo "Fetched data successfully\n";
mysql_close($conn);
?>
</code>
like
<code>
<?php
$dbhost = '******';
$dbuser = 'root';
$dbpass = '*******';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}
$sql = "SELECT first, last, age, DOB from online";
mysql_select_db('****');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not get data: ' . mysql_error());
}
while($row = mysql_fetch_assoc($retval))
{
echo "online :{$row['first']} <br />";
}
echo "Fetched data successfully\n";
mysql_close($conn);
?>
</code>
- 0useful
- 0not useful
#4. Posted:
Status: Offline
Joined: Nov 28, 20149Year Member
Posts: 21
Reputation Power: 0
So, when I've updated it and load it in the browser, here's what I get
"; } echo "Fetched data successfully\n"; mysql_close($conn); ?>
"; } echo "Fetched data successfully\n"; mysql_close($conn); ?>
- 0useful
- 0not useful
#5. Posted:
Status: Offline
Joined: May 02, 201212Year Member
Posts: 1,129
Reputation Power: 34
Status: Offline
Joined: May 02, 201212Year Member
Posts: 1,129
Reputation Power: 34
Endermite wrote So, when I've updated it and load it in the browser, here's what I get
"; } echo "Fetched data successfully\n"; mysql_close($conn); ?>
Try this:
echo "online :".$row['first']."<br />";
See if this fixes it where on the browser it only returns "Fetched data successfully" and not " "; } echo "Fetched data successfully\n"; mysql_close($conn); ?> "
- 0useful
- 0not useful
You are viewing our Forum Archives. To view or take place in current topics click here.