Learn VBA & Macros in 1 Week!

PHP - How To Send To My Database What Other Person Order ..

Full Excel VBA Course - Beginner to Expert

How To Send To My Database What Other Person Order ..	View Content

<?php

include_once('db.php');

$users = array();

$users_data = $db -> prepare('SELECT id, username FROM users');

$users_data -> execute();

while($fetched = $users_data->fetch()) {

$users[$fetchedt['id']] = array (

'id' => $fetched['id'],

'username' => $fetched['name']

);

}

echo json_encode($leaders);

i get

{"1":{"id":1,"username":"jeremia"},"2":{"id":2,"username":"Ernest"}}

Edited March 24 by mahenda

Similar Tutorials

View Content

So completely new here.

I've created a database that has 4 fields full_name, company, email and serial_no with 2 sample records.

I would like to create a form with those fields, so the data I enter into the form when I press submit it goes into the database.

Config File:

<?php
$mysqli = new mysqli('localhost', 'username', 'pass', 'database_name');
    if($mysqli->connect_error)
        {
        echo $mysqli->connect_error;
        }
    ?>

Index.php

<html lang="en">
<head>
<meta charset="UTF-8">
<title>Add Record Form</title>
</head>
<body>
<form action="insert.php" method="post">
    <p>
        <label for="Fullname">Fullname:</label>
        <input type="text" name="full_name" id="Fullname">
    </p>
	<p>
        <label for="Company">Company:</label>
        <input type="text" name="Company" id="Company">
    </p>
	<p>
        <label for="emailAddress">Email Address:</label>
        <input type="text" name="email" id="emailAddress">
    </p>
    <p>
        <label for="Serial">Serial:</label>
        <input type="text" name="Serial" id="Serial">
    </p>
    
    <input type="submit" value="Submit">
</form>
</body>
</html>

Insert.php

<?php
/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$link = mysqli_connect("localhost", "username", "pass", "database_name");
 
// Check connection
if($link === false){
    die("ERROR: Could not connect. " . mysqli_connect_error());
}
 
// Escape user inputs for security
$full_name = mysqli_real_escape_string($link, $_REQUEST['full_name']);
$company = mysqli_real_escape_string($link, $_REQUEST['company']);
$email = mysqli_real_escape_string($link, $_REQUEST['email']);
$serial_no = mysqli_real_escape_string($link, $_REQUEST['serial_no']);
 
// Attempt insert query execution
$sql = "INSERT INTO licjwe(full_name, company, email, serial_no) VALUES ('$full_name', '$company', '$email', '$serial_no')";
if(mysqli_query($link, $sql)){
    echo "Records added successfully.";
} else{
    echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
 
// Close connection
mysqli_close($link);
?>

This is the error I am getting:

ERROR: Could not able to execute INSERT INTO database_name(full_name, company, email, serial_no) VALUES ('test', '', 'email@home.com', ''). Table 'table_name' doesn't exist

How To Send To My Database What Other Person Order ..

Similar Tutorials

How To Send An Activation Email To A New Registered Person

How Do I Disaply A Person Name From The Database.

Order Database Results In Php

Sort Order Not Inserting Into Database

I Want To Send Data From My Local Server Database Table To Different Database With The Same Table

How To Send To My Database

How Can I Send & Or &amp; To Database?

Change Database Sort Order With Select Box

Send To Database Error

Using A Dropdown Menu To Order A List Taken From A Database With Pagination

Php Insert In Mysql Database Table In Random Order?

How To Send Multiple Variables Into Database?

Create Form Send To Database

Send Html Mail To Emailaddresses From Database

Jeditable - Send Data Back To Database

Send Email On Database Insert Trigger

Send Multiple E-mail Messages Using Mysql Database

Php Dropdown List - Send Information Selected To Database

Send Message To All Email Addresses In Database Table

Getting User Information Into Database And Send Activation Email Script Here!

How Can I Send & Or & To Database?