每次执行按钮操作时，如何在DB表中插入值 [英] How do I insert a value into DB table when every time button action is performed

问题描述

我正在开发一个项目，当点击一个按钮时，它应生成一个OTP并将生成的值保存在sql数据库中。

Hii am working on a project in which when a button is clicked it should generate an OTP and saves the generated value in the sql database.

<?php

$string = 'abcdefghijklmnopqrstuvwxyz0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ';
$string_shuffled = str_shuffle($string);

$half = substr($string_shuffled, 1, 7);

echo $half ;

?>

我的HTML用于在login.php中生成OTP的按钮的代码：

My HTML code for button to generate OTP in login.php :

<input class="button" name="generate" id="generate" tabindex="5" value="Generate Password" type="submit">

单击上面的按钮时我的php动作：

My php action when the above button is clicked :

if(isset($_POST['generate']))
    {
           $string = 'abcdefghijklmnopqrstuvwxyz0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ';
           $string_shuffled = str_shuffle($string);

           $half = substr($string_shuffled, 1, 7);

           $query = "INSERT INTO `san_login`.`user_login` (`password`)   VALUES ('".$half."')";
           }

推荐答案

string = ' abcdefghijklmnopqrstuvwxyz0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ';

string = 'abcdefghijklmnopqrstuvwxyz0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ';

string_shuffled = str_shuffle（

string_shuffled = str_shuffle(

string）;

string);

这篇关于每次执行按钮操作时，如何在DB表中插入值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！