Breaking News: Grepper is joining You.com. Read the official announcement!

php sql query to insert to msql db

Add Answer

Hi TECH answered on February 7, 2022 Popularity 9/10 Helpfulness 4/10

answer php sql query to insert to msql db

related insert php mysql

related php insert to mysql

php sql query to insert to msql db

Comment

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// Data to be inserted
$fn = "Ola";
$sn = "John";
$email = "Ola@gmail.com";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}

$sql = "INSERT INTO usertb (firstname, lastname, email)
VALUES ('".$fn."', '".$sn."', '".$email"')";

if ($conn->query($sql) === TRUE) {
  echo "New record created successfully";
} else {
  echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();
?>

Popularity 9/10 Helpfulness 4/10 Language php

Source: Grepper

Tags: insert php sql

Link to this answer
Share Copy Link

Contributed on Aug 29 2023

Hi TECH

0 Answers Avg Quality 2/10

Closely Related Answers

insert php mysql

Comment

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}

$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@example.com')";

if ($conn->query($sql) === TRUE) {
  echo "New record created successfully";
} else {
  echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();
?>

Popularity 10/10 Helpfulness 9/10 Language php

Source: Grepper

Tags: insert in

Link to this answer
Share Copy Link

Contributed on Feb 07 2022

Jolly Jellyfish

0 Answers Avg Quality 2/10

php insert to mysql

Comment

<?php

$vote_yes=$_GET['yes'];
$vote_no=$_GET['no'];
$time=time();

$servername = "localhost";
$username = "bob";
$password = "123456";
$db = "classDB";

$conn = new mysqli($servername, $username, $password, $db);

if ($conn->connect_error){
	die("Connection failed: ". $conn->connect_error);
}

$sql = "insert into votes(yes,no,time)values('$vote_yes','$vote_no','$time')"; 

if ($conn->query($sql) === TRUE) {
	echo "Votes Recorded: Yes = ".$vote_yes." No = ".$vote_no." Time = ".$time;
} else {
	echo "Error: ".$sql."<br>".$conn->error;
}

$conn->close();

?>

Popularity 10/10 Helpfulness 3/10 Language php

Source: www.elithecomputerguy.com

Tags: insert in

Link to this answer
Share Copy Link

Contributed on Jun 10 2022

Mary Rose J. Jamile

0 Answers Avg Quality 2/10

php sql query to insert to msql db

Contents

More Related Answers

php sql query to insert to msql db

Closely Related Answers

insert php mysql

php insert to mysql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.