Метод 1: использование функции MySQL MD5() в инструкции INSERT.
INSERT INTO your_table_name (username, password)
VALUES ('JohnDoe', MD5('password123'));
Метод 2: использование подготовленных операторов PHP и MySQLi.
<?php
$mysqli = new mysqli('localhost', 'username', 'password', 'database_name');
$username = 'JohnDoe';
$password = md5('password123');
$stmt = $mysqli->prepare("INSERT INTO your_table_name (username, password) VALUES (?, ?)");
$stmt->bind_param('ss', $username, $password);
$stmt->execute();
$stmt->close();
$mysqli->close();
?>
Метод 3. Использование Python и библиотеки pymysql.
import pymysql
import hashlib
connection = pymysql.connect(host='localhost',
user='username',
password='password',
db='database_name')
username = 'JohnDoe'
password = hashlib.md5('password123'.encode()).hexdigest()
cursor = connection.cursor()
query = "INSERT INTO your_table_name (username, password) VALUES (%s, %s)"
cursor.execute(query, (username, password))
connection.commit()
cursor.close()
connection.close()
Метод 4. Использование Node.js и библиотеки mysql.
const mysql = require('mysql');
const crypto = require('crypto');
const connection = mysql.createConnection({
host: 'localhost',
user: 'username',
password: 'password',
database: 'database_name'
});
const username = 'JohnDoe';
const password = crypto.createHash('md5').update('password123').digest('hex');
const query = 'INSERT INTO your_table_name (username, password) VALUES (?, ?)';
connection.query(query, [username, password], function(error, results, fields) {
if (error) throw error;
console.log('Record inserted successfully');
});
connection.end();