how would i fix my insert function so it prints result in one id not three seperate ones using php and sql code: First name:

how would i fix my insert function so it prints result in one id not three seperate ones using php and sql

code:

' ); define( 'DB_USER', '' ); define( 'DB_PASSWORD', '' ); define( 'DB_HOST', 'localhost' );

function DeletePersonEntry($id) { $conn = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); // Check connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } $del = "DELETE FROM people WHERE id = '$id' "; $result = $conn->query($del); mysqli_close($conn); }

function Insertfirstname($firstname){

// Create connection $conn = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); // Check connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); }

$insert = "INSERT INTO people SET firstname = '$firstname' "; $result = $conn->query($insert); mysqli_close($conn); }

function Insertlastname($lastname) { $conn = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); // Check connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } $insert = "INSERT INTO people SET lastname = '$lastname' "; $result = $conn->query($insert); mysqli_close($conn); } function Inserttelephone($telephonenumber) { $conn = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); // Check connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } $insert = "INSERT INTO people SET telephonenumber = '$telephonenumber' "; $result = $conn->query($insert); mysqli_close($conn); }

function showPeople() { // Create connection $conn = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); // Check connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); }

$sql = "SELECT id, firstname, lastname, telephonenumber FROM people"; $result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) { // output data of each row while($row = mysqli_fetch_assoc($result)) { // $delurl = "[delete]"; echo "id: " . $row["id"]. " - First name: " . $row["firstname"]. " Last name: " . $row["lastname"]. " Telephone number: " . $row["telephonenumber"]. " $delurl "; } } else { echo "0 results"; }

mysqli_close($conn); }

?>

First name:

Last name: Telephone number:

if($_GET['firstname'] != ''){ Insertfirstname($_GET['firstname']); } if($_GET['lastname'] != '') { Insertlastname($_GET['lastname']); } if($_GET['telephonenumber'] != '') { Inserttelephone($_GET['telephonenumber']); } if($_GET['cmd'] == 'delete') { $id = $_GET['id']; DeletePersonEntry($id); }

showPeople(); ?>