如何将随机值插入SQL Server表?

问题描述:

这是我的代码和tablename:table1

数据库:tesync



i尝试使用php代码生成随机数,我得到了但我怎么能得到





插入到sql数据库中



我尝试了什么:



this is my code and tablename:table1
database:tesync

i tried the php code for generating random numbers and i get that but how can i get


the inserted that into sql database

What I have tried:

<?php
$connection = mysqli_connect('localhost', 'root', '');
if (!$connection){
    die("Database Connection Failed" . mysqli_error($connection));
}
$select_db = mysqli_select_db($connection, 'tesync');
if (!$select_db){
    die("Database Selection Failed" . mysqli_error($connection));
}


for ($i=1;$i<=100;$i++)
{

$randomNumber= rand(1111111111,9999999999);

 echo $randomNumber.'<br>';
}
 ?>

连接 = mysqli_connect(' localhost' ' root'' '跨度>);
if (!
connection = mysqli_connect('localhost', 'root', ''); if (!


connection){
die( 数据库连接失败 .mysqli_error(
connection){ die("Database Connection Failed" . mysqli_error(


connection));
}
connection)); }