function connectToDatabase()
{
$conn = mysql_connect($this->host, $this->username, $this->password);
if (!$conn) {
die("Cannot connect to the database");
} else {
$this->myconn = $conn;
// echo "Connection established";
}
return $this->myconn;
}
function selectDatabase()
{
mysql_select_db($this->database);
//use php inbuild functions for select database
if (mysql_error()) {
echo "Cannot find the database " . $this->database;
}
// echo "Database selected..";
}
function closeConnection()
{
mysql_close($this->myconn);
echo "Connection closed";
}
}
$connec = new createConnection();
$connec->connectToDatabase();
//for database connectivity
$connec->selectDatabase();
// foe db selection
<?php
session_start();
require 'connection.php';
$conn = new createConnection();
$conn->connectToDatabase();
$conn->selectDatabase();
$employerId = 2;
//This is the directory where images will be saved
$target = "images/logos/";
$target = $target . basename($_FILES['companyLogo']['name']);
$pic = $_FILES['companyLogo']['name'];
$sql = "UPDATE employer_agent_company SET FirstName = '{$_POST['fname']}', LastName = '{$_POST['lname']}', Address = '{$_POST['address']}', Company_Agent_Logo = '{$pic}', MobilePhone = '{$_POST['mobPhone']}', WorkPhone = '{$_POST['workPhone']}', EmailForApplication = '{$_POST['email']}', Company_Agent_URL = '{$_POST['companyUrl']}', EMPLOYER_TYPE_ID = '{$_POST['empType']}', AGENT_COMPANY_NAME = '{$_POST['agentComName']}' WHERE EMPLOYER_ID = {$employerId}";
var_dump($sql);
$res = $conn->queryDatabase($sql);
if ($res === TRUE) {
echo "Congratulation on successfully updated profile.";
} else {
echo "Could Not update your profile, please try again.";
}
//Writes the photo to the server
if (move_uploaded_file($_FILES['companyLogo']['tmp_name'], $target)) {
//Tells you if its all ok
echo "The file " . basename($_FILES['companyLogo']['name']) . " has been uploaded, and your information has been added to the directory";
} else {
//Gives and error if its not
echo "Sorry, there was a problem uploading your file.";
}
$conn->closeConnection();
<?php include 'common/connection.php'; $connection0 = new createConnection(); //i created a new object $connection0->connectToDatabase(); // connected to the database echo "<br />"; // putting a html break $connection0->selectDatabase(); echo "<br />"; $connection0->closeConnection(); // closed connection
