38 lines
1.3 KiB
PHP
38 lines
1.3 KiB
PHP
|
<?php
|
||
|
|
$servername = "localhost";
|
||
|
|
$username = "root";
|
||
|
|
$password = "";
|
||
|
|
$dbname = "drrudra_db";
|
||
|
|
|
||
|
|
// Create connection
|
||
|
|
$conn = new mysqli($servername, $username, $password, $dbname);
|
||
|
|
// Check connection
|
||
|
|
if ($conn->connect_error) {
|
||
|
|
die("Connection failed: " . $conn->connect_error);
|
||
|
|
}
|
||
|
|
|
||
|
|
$company_name =$_POST['name'];
|
||
|
|
$company_email = $_POST['email'];
|
||
|
|
$company_code= $_POST['code'];
|
||
|
|
$company_address= $_POST['address'];
|
||
|
|
$company_con_name= $_POST['contact_name'];
|
||
|
|
$company_phone= $_POST['phone'];
|
||
|
|
$company_website= $_POST['website'];
|
||
|
|
$company_logo= $_POST['logo'];
|
||
|
|
|
||
|
|
|
||
|
|
$sql="update company_profile set company_name='$company_name',company_code='$company_code',address='$company_address',
|
||
|
|
primary_contact_name='$company_con_name',primary_phone='$company_phone',company_logo='$company_logo',primary_email='$company_email'";
|
||
|
|
|
||
|
|
|
||
|
|
//$sql = "INSERT INTO company_profile(company_name, company_code, address,primary_contact_name,primary_phone, primary_email,company_website, company_logo)
|
||
|
|
//VALUES ('".$company_name."', '".$company_email."', '".$company_code."', '".$company_address."', '".$company_con_name."', '".$company_phone."', '".$company_website."', '".$company_logo."')";
|
||
|
|
echo $sql;
|
||
|
|
if ($conn->query($sql) == TRUE) {
|
||
|
|
echo "New record created successfully";
|
||
|
|
} else {
|
||
|
|
echo "Error: " . $sql . "<br>" . $conn->error;
|
||
|
|
}
|
||
|
|
|
||
|
|
?>
|
||
|
|
|