javascript - 如何从点击的数字中获取值(数字)

Question

我想获取点击的数字

并根据这个数从数据库中加载数据。存储数字的列命名为 id。

我有这段代码是为了显示数字(id)...

$sql = "SELECT id FROM work WHERE username='$username' order by id asc limit 10;";

                $result = mysql_query($sql);
                if ($result != 0) {


                    $num_results = mysql_num_rows($result);
                    for ($i=0;$i<$num_results;$i++) {
                        $row = mysql_fetch_array($result);
                        $id = $row['id'];
                        echo '<a href="' .kotoula(). '">' .$id. '</a>';
                    }

                }

然后我想以一种形式从这个数字中加载数据，该形式的代码是...

function kotoula() {
                    $username = $_SESSION["username"];


                    if($query = mysql_query("SELECT job_title,company,website,start_date,end_date,start_year,end_year,work_history FROM work WHERE id>'$id' AND username='$username' order by id asc limit 10") or die(mysql_error()))
                    {
                        if(mysql_num_rows($query)>=1){
                            while($row = mysql_fetch_array($query)) {
                            $job_title = $row['job_title'];
                            $company = $row['company'];
                            $website = $row['website'];
                            $start_date = $row['start_date'];
                            $end_date = $row['end_date'];
                            $start_year = $row['start_year'];
                            $end_year = $row['end_year'];
                            $work_history = $row['work_history'];
                            }
                        }                                           
                    }
                }

Answer 1

只需使用 GET 将其放入 URL 中即可。像这样的东西:

http://yoururl.com/user.php?id=12345

然后，user.php 将在 $_GET 数组上接收该值。示例:

$_GET['id'];