Hi,
I created table with name USERS.
Inside I have defined 3 items : NAME, PASSWORD, EMAIL
Is it possible to add record to this table by some script?
When I do it locally, I'm using script like this :
<?php
//Variables for the connection
$servername = "localhost";
$s_username = "root";
$s_password = "abcdef";
$my_Table = "USERS";
//Variable from the user
$NAME = "JOHN"; $PASSWORD = "abc"; $EMAIL = "john@john.com";
//Make Connection
$conn = new mysqli($servername, $s_username, $s_password, $my_Table);
//Check Connection
if (!$conn) die("Failed. ". mysqli_connect_error());
$sql = "INSERT INTO users (NAME, PASSWORD, EMAIL)
VALUES ('".$NAME."','".$PASSWORD."','".$EMAIL."')";
$result = mysqli_query($conn ,$sql);
if(!result) echo "error";
else echo "ok.";
?>
Is it possible to upload PHP like this to caspio server? Into which directory?
What about my_Table name ? What is correct filename, I mean web address for browser.
Thank You in advance for any help.
Regards,
Milos.