我需要找到每个名字有多少个字符并从高到低排列。此代码将使用数据表打印 id 名字和姓氏,我想显示每个具有相应名字的单独表中的字符数。
<!DOCTYPE html>
<html>
<head>
<title></title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/v/dt/dt-1.10.15/datatables.min.css"/>
<script type="text/javascript" src="https://cdn.datatables.net/1.10.15/js/jquery.dataTables.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/1.10.15/js/dataTables.jqueryui.min.js"></script>
</head>
<body>
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "name";
$conn = new mysqli($servername, $username, $password, $dbname);
if(mysqli_connect_errno($conn))
{
echo 'Failed to connect to database: '.mysqli_connect_error();
}
else{}
$sql="SELECT * FROM nametable";
$result=mysqli_query($conn, $sql);
if ($result->num_rows > 0) {
echo "<table width=50% class='dataTable'><thead><tr><th>id</th><th>Firstname</th><th>Lastname</th></tr></thead><tbody>";
while($row = $result->fetch_assoc()) {
echo "<tr><td>".$row["id"]."</td><td>".$row["firstName"]."</td><td>".$row["lastName"]."</td></tr>";
}
echo "</tbody></table>";
}
?>
<script>
$(document).ready(function() {
$(".dataTable").DataTable({
"lengthMenu": [[10, 25, 50, 100, -1], [10, 25, 50, 100, "All"]],
"pagingType": "numbers"
} );
} );
</script>
<?php
$sql1="SELECT firstName, LEN(firstName) as LengthOfFirstName FROM nametable";
$result2=mysqli_query($conn, $sql1);
if ($result2->num_rows > 0){
while ($row2 = $result2->fetch_assoc()){
echo $row2 ."<br>";
}
}
?>
</body>
</html>
您似乎在寻找strlen
,它返回输入字符串的长度:
strlen($row['firstName']);
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句