PHP

arraysubmit.php

<?php

include('connect.php');



if(isset($_POST['save'])){

	

	

	$company_name = $_POST['company_name'];

	$brand_name = $_POST['brand_name'];

	//insert checkbox values

	

	$cars = implode(',',$_POST['car_name']);

	

	//insert data into database

	$sql="INSERT INTO cars(company_name,brand_name,car_name)VALUES('$company_name','$brand_name','$cars')";

	$stmt=$con->prepare($sql);

	$stmt->execute();

	echo '<div class="alert alert-success">Submitted Successfully</div>';

	

	//insertion complete

	

}	



//get the cars

	$stmt2 = $con->prepare("select * from cars");

	$stmt2->execute();

	$cars = $stmt2->fetchAll(PDO::FETCH_ASSOC);

?>