如何将随机值插入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)); }