Prestashop - Insert customer variables into another database when customer register
$10-30 USD
货到付款
"This is the first of many mini-jobs needed for a Prestashop installation.
I will pay from $10 to $30 per each mini-job upon agreement with the freelancer and depending on the difficulty and time spent,
For this one, Bids over 10$ will be automatically declined"
1- I need to insert the following data into another mySQL database (in the same server) when a customer register in Prestashop:
INSERT INTO `users` (`id`, `name`, `email`, `pass`, `votes`, `isadmin`, `banned`)
VALUES (customer_ID, '$customer_name', '$customer_name', '$customer_name', 20, 0, 0);
I have been able to do it so far in classes/[login to view URL] but without using customer variables:
<?php
$servername1 = "localhost";
$username1 = "testuser";
$password1 = "testpswd";
$dbname1 = "testdb";
// Create connection
$conn1 = mysqli_connect($servername1, $username1, $password1, $dbname1);
// Check connection
if (!$conn1) {
die("Connection failed: " . mysqli_connect_error());
}
$sql1 = "INSERT INTO `users` (`id`, `name`, `email`, `pass`, `votes`, `isadmin`, `banned`)
VALUES (1001, 'Test Name', 'test@[login to view URL]', 'testpsw', 20, 0, 0);";
$result1 = mysqli_query($conn1, $sql1);
?>
项目ID： #18424080
关于项目
授予：
Hey am an expert in pretashop and php.I've read your requirement regarding database value not [login to view URL] can be done within few [login to view URL] let me know.
有7名威客正在参与此工作的竞标，均价$28/小时
Hello, Hope you're doing great !! I have 5+ years of excellent experience in website development and designing.I have excellent experience in Prestashop development.I can insert you value you data in different da 更多
hello dear, I'm interested to work on this project. I'm Monalisa, with 6+ years experience .. please give me an opportunity to work with you. could you please add me to your chat box? waiting for you 更多
Your problems is very simple. I will do it for you as simple as possible. You don't need to modify your code to insert records to an another DB.
