PHP table values

Question

I have a question and I will try to explain the best way that I can

I have a table that show me names of accounts and each one of that accounts has it own information.

and I'm getting that information like this

On the page "verpersonagem.php" I have this: $idaccount = $_GET['accountId']; but the url comes like this ../verpersonagem.php?account= Why it's not getting the value?

Thanks in advance

samo0ha · Accepted Answer · 2017-12-10 14:04:18Z

1

you don't have yo use all this echo statement try this

<?php
    while ($row = mysqli_fetch_row($result))
    {
    echo '<tr>
            <th><a href="verpersonagem.php?account='. $row[0] .'"> '. $row[0] .' </a></th>
            <td>'. $row[2] .' </td>
            <td>'. $row[1] .'</td>
            <td>'. $row[3] .'</td>
            <td>'. $row[4] .'</td>
        </tr>';
    }
?>

edited Dec 10, 2017 at 14:04

answered Dec 10, 2017 at 1:41

samo0ha

3,8462 gold badges28 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

ShwSvn Over a year ago

Okay thank you, I will change it And about my question?

samo0ha Over a year ago

is there something i miss in your question ?

ShwSvn Over a year ago

how can I get the account name to from that page to another one clicking on the name of the account

samo0ha Over a year ago

in the other account you will do this if(!empty($_GET['account'])){ $accountId = $_GET['account']; } $query = "SELECT * FROM tablename WHERE accountID = '$accountId'"; $row = mysqli_query($link, $query); and complete the rest as above

ShwSvn Over a year ago

I will change the original question for my code now, if you can please check it

|

maurice bruijn · Accepted Answer · 2017-12-10 01:20:35Z

1

You should insert the href into the Table its TD instead of TH

Use a for loop instead and say count(rows)

Then $i < $rows and href=example.php?id=$i

Then use $_GET['id'] And do a database query which gets all the info about the id

answered Dec 10, 2017 at 1:20

maurice bruijn

813 bronze badges

4 Comments

ShwSvn Over a year ago

Can you explain better please?

maurice bruijn Over a year ago

Make a for loop in php then call the table with the tabelhead called Person then add TD with a (<a href='example.php?name=test$i'>) then in the example.php: $_GET['name']; and store that in a variable then you can do database queries with the variable

maurice bruijn Over a year ago

<?php // query to database that get the amount of users for($i = 0; $i < count(/* amount of users */; $i++) { echo '<tr> <th>users</th> </tr> <tr> <td><a href="example.php?name=test$i">Name $i</a></td> </tr> '; } ?> Example.php <?php $user = $_GET['name']; // now use $user to get all info about this user and display it on the page ?>

ShwSvn Over a year ago

I'm sorry, I tried but I couldn't make it work The url stays like this "verpersonagem.php?ID="

Collectives™ on Stack Overflow

PHP table values

2 Answers 2

7 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related