Solved [PHP+SQL] Looking for a script

[Kavvson]

Im searching for a script that will display all characters from a account. Stand alone code please. I know it will be like that



// New edit

	<?PHP

 $get = $mysqli->query ("SELECT `name` FROM `players` WHERE `account_id` = `".$accountresult['name']."`");
 
 foreach($get as $character){		
 
echo "".$character['name']."";
}
 
?>

and dont work

 

[Xampy]

Did you declare what $mysqli is?

 

[Kavvson]

$mysqli = new mysqli( 'localhost', 'root', '', 'test' );

Yes

$accountresult = $mysqli->query( 'SELECT * FROM `players` LEFT JOIN `accounts` ON `accounts`.`id` = `players`.`account_id` WHERE `players`.`name` = \''.$mysqli->real_escape_string( $_GET['editcharacter'] ).'\';' )->fetch_assoc( );  
  

     $get = $mysqli->query("SELECT `players`.`name`, `players`.`id` FROM `players` WHERE `players`.`account_id` = ".$accountresult['name']."");   
          
       foreach($get as $player)   
       {   
         echo " ".$player['name']." ";
       }

Dont work

 

[Xampy]

try:

<?PHP
	$mysqli = new mysqli('localhost', 'root', 'pass', 'db'); 
	$accountresult = $mysqli->query('SELECT * FROM `players` LEFT JOIN `accounts` ON `accounts`.`id` = `players`.`account_id` WHERE `players`.`name` = "'.$mysqli->real_escape_string( $_GET['editcharacter'] ).'";' )->fetch_assoc( );
	$get = $mysqli->query("SELECT `name` FROM `players` WHERE `account_id` = ".$accountresult['account_id']."");
	while($character = $get->fetch_object()) {
		echo "".$character->name."<br/>";
	}
 
?>

 

[Kavvson]

@ up sorry now it works

 $get = $mysqli->query("SELECT `name` FROM `players` WHERE `account_id` = ".$accountresult['account_id']."");
    while($character = $get->fetch_object()) {
        echo "".$character->name."<br/>";
    }

all is ok thanks rep


------------------------------------------------------------

Btw. Xampy is it possible to connect a tooltip?

<div id="character">
<a title="
	<?PHP $tab = array(
	 'Name' => 'name',
     'Level' => 'level',
     'Experience' => 'experience',
     'Vocation' => 'vocation',
     'Page Access' => 'maglevel',
	 'Promotion' => 'promotion',
	 'Sex' => 'sex',
     'Guild Nick' => 'guildnick',
     'Health' => 'health',
     'Healthmax' => 'healthmax',
     'Mana' => 'mana',
     'Manamax' => 'manamax',
	 'Soul' => 'soul',
     'Capability' => 'cap');
    
    foreach($tab as $key => $value)
    {
        echo $key.' : '.$result[$value].'<br />';
    }
	?>" href="#"><?PHP ECHO $result['name']; ?></a>

</div>

with the script

 $get = $mysqli->query("SELECT `name` FROM `players` WHERE `account_id` = ".$accountresult['account_id']."");
    while($character = $get->fetch_object()) {
        echo "".$character->name."<br/>";
    }

 

[Xampy]

Try this first, please. It should work.

 

[Xampy]

@ up sorry now it works
Btw. Xampy is it possible to connect a tooltip?

<div id="character">
<a title="
	<?PHP $tab = array(
	 'Name' => 'name',
     'Level' => 'level',
     'Experience' => 'experience',
     'Vocation' => 'vocation',
     'Page Access' => 'maglevel',
	 'Promotion' => 'promotion',
	 'Sex' => 'sex',
     'Guild Nick' => 'guildnick',
     'Health' => 'health',
     'Healthmax' => 'healthmax',
     'Mana' => 'mana',
     'Manamax' => 'manamax',
	 'Soul' => 'soul',
     'Capability' => 'cap');
    
    foreach($tab as $key => $value)
    {
        echo $key.' : '.$result[$value].'<br />';
    }
	?>" href="#"><?PHP ECHO $result['name']; ?></a>

</div>

with the script

 $get = $mysqli->query("SELECT `name` FROM `players` WHERE `account_id` = ".$accountresult['account_id']."");
    while($character = $get->fetch_object()) {
        echo "".$character->name."<br/>";
    }

Yes, all is possible in this world xD.

 

[Kavvson]

Could you try it? I assume you do it better then I Btw could you add in your

 <?PHP
   
  $get = $mysqli->query("SELECT `name` FROM `players` WHERE `account_id` = ".$accountresult['account_id']."");
    while($character = $get->fetch_object()) {
        echo "".$character->name."<br/>";
    }
?>

Sth like that

".$character->name." ($player lvl)


@ i tried the tooltip its a bit hard i get much display errors;P but its possible.
What about the ".$character->name." ($player lvl)

 

[Xampy]

Here it is (improved):

<?PHP
	$mysqli = new mysqli('localhost', 'root', 'password', 'database'); 
	$accountresult = $mysqli->query('SELECT * FROM `players` LEFT JOIN `accounts` ON `accounts`.`id` = `players`.`account_id` WHERE `players`.`name` = "'.$mysqli->real_escape_string( $_GET['editcharacter'] ).'";' )->fetch_assoc( );
	$get = $mysqli->query("SELECT * FROM `players` WHERE `account_id` = ".$accountresult['account_id']."");
	if($get == TRUE) {
		while($character = $get->fetch_object()) {
			echo "".$character->name." (".$character->level.")<br/>";
		}
	}
	else
		echo '<b>This character does not exist:</b> <font color="red">'.$_GET['editcharacter'].'</font>';
 
?>

 

[Kavvson]

Thanks and tooltip can u figure it out?

 

[Xampy]

Can you explain to me that?

 

[Kavvson]

So you have your script : that shows chars in 1 account. I have a tooltip that looks like this


and the output is :

This is my example how could it be its totally not correct just see how could it be

   $get = $mysqli->query("SELECT * FROM `players` WHERE `account_id` = ".$accountresult['account_id']."");

<a title="
    <?PHP $tab = array(
     'Name' => 'name',
     'Level' => 'level',
     'Experience' => 'experience',
     'Vocation' => 'vocation',
     'Page Access' => 'maglevel',
     'Promotion' => 'promotion',
     'Sex' => 'sex',
     'Guild Nick' => 'guildnick',
     'Health' => 'health',
     'Healthmax' => 'healthmax',
     'Mana' => 'mana',
     'Manamax' => 'manamax',
     'Soul' => 'soul',
     'Capability' => 'cap');
    
    foreach($tab as $key => $value)
    {
        echo $key.' : '.$result[$value].'<br />';
        
    }
    
    ?>" href="#">
    
    while($character = $get->fetch_object()) {
            echo "".$character->name." (".$character->level.")<br/>";
        }
</a>

 

[Xampy]

Try:

<?PHP
	$mysqli = new mysqli('localhost', 'root', 'password', 'database'); 
	$accountresult = $mysqli->query('SELECT * FROM `players` LEFT JOIN `accounts` ON `accounts`.`id` = `players`.`account_id` WHERE `players`.`name` = "'.$mysqli->real_escape_string( $_GET['editcharacter'] ).'";' )->fetch_assoc( );
	$get = $mysqli->query("SELECT * FROM `players` WHERE `account_id` = ".$accountresult['account_id']."");

	while($character = $get->fetch_object()) {
	echo '<a title="';
	$tab = array(
     'Name' => 'name',
     'Level' => 'level',
     'Experience' => 'experience',
     'Vocation' => 'vocation',
     'Page Access' => 'maglevel',
     'Promotion' => 'promotion',
     'Sex' => 'sex',
     'Guild Nick' => 'guildnick',
     'Health' => 'health',
     'Healthmax' => 'healthmax',
     'Mana' => 'mana',
     'Manamax' => 'manamax',
     'Soul' => 'soul',
     'Capability' => 'cap');
    
		foreach($tab as $key => $value)
		{
			echo $key.': '.$character->$value.'<br/>';
		}
		echo "\" href=\"#\">".$character->name."</a><br/>";
	}
?>

 

[Kavvson]

Excellent job! Thats what i wanted. This topic is done for now. Try http://otland.net/f16/jquery-tabs-101859/.

Regards

 

[Xampy]

No please!!! No more job!!!!!!!!!!! XDD I'll look on it in a while.

 

[Nefs]

OMG, nice job Xampy