public function setId($new_id)
{
$connection = new createConnection();
//i created a new object
$connection->connectToDatabase();
// connected to the database
$this->id = $new_id;
}
public static function connectToDatabase()
{
$conn = new mysqli(self::$host, self::$username, self::$password, self::$database);
if ($conn->connect_error) {
trigger_error('Database connection failed: ' . $conn->connect_error, E_USER_ERROR);
} else {
self::$myconn = $conn;
//echo "Connection established";
}
return self::$myconn;
}
function doRegister($firstName, $lastName, $emailid, $pass)
{
$first_name = $firstName;
//$_POST['input_fname'];
$last_name = $lastName;
// $_POST['input_lname'];
$pwd = $pass;
//$_POST['input_password'];
$email = $emailid;
//$_POST['input_email'];
$errorMessage = '';
createConnection::connectToDatabase();
$sql = "SELECT email FROM tbl_login WHERE email = '{$email}'";
$result = createConnection::dbQuery($sql);
if (createConnection::dbNumRows($result) == 1) {
$errorMessage = 'Username is already exist, please try another email.';
return false;
//$errorMessage;
} else {
$insert_id = 0;
//Insert values in Login Table
$sql = "INSERT INTO tbl_login (email, password, is_active, added_date, role)\n\t\t\t\t\tVALUES ('{$email}', PASSWORD('{$pwd}'), true, now(), 'USER')";
createConnection::dbQuery($sql);
$insert_id = createConnection::dbInsertId();
//Insert values in Users Table
$sql = "INSERT INTO tbl_users (login_id, first_name, last_name, added_date)\n\t\t\t \t\tVALUES ('{$insert_id}','{$first_name}','{$last_name}', now())";
createConnection::dbQuery($sql);
//Insert values in Address Table
$sql = "INSERT INTO tbl_address (user_id) \n\t\t\t \t\tVALUES ({$insert_id})";
createConnection::dbQuery($sql);
//now send email
//email it now.
$subject = "Account Registration";
$to = $email;
$msg_body = "Dear Customer,<br/><br/>\n\t\t\tThis is to inform you that your Account # {$email} is register successfully with Demo Project and currently in Inactive state. We will soon contact you once it get activate.<br/><br/>In case you need any further clarification for the same, please do get in touch with your Home Branch.<br/><br/>\n\t\t\tRegards,<br/>Admin, Demo Project";
$mail_data = array('to' => $to, 'sub' => $subject, 'msg' => 'register', 'body' => $msg_body);
//send_email($mail_data);
//header('Location: ../thankyou.php');
//exit;
return true;
}
}
<?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
set_include_path(dirname(__FILE__) . "/../");
require_once '../dbconfig/config.php';
require_once '../library/Account.php';
createConnection::connectToDatabase();
$account = new Account();
if (isset($_REQUEST['email']) && isset($_REQUEST['password']) && isset($_REQUEST['remember'])) {
$email = createConnection::realEscapeString($_REQUEST['email']);
$password = createConnection::realEscapeString($_REQUEST['password']);
$remember = $_REQUEST['remember'];
$result = $account->doLogin($email, $password, $remember);
header('Content-Type: application/json');
if ($result["status"] == true) {
$arrayName = array('status' => $result["status"], 'name' => $result["name"], 'email' => $result["email"]);
echo json_encode($arrayName);
} else {
echo json_encode(array('status' => $result["status"], 'error' => $result["error"]));
}
//echo json_encode($result);
// $json = json_encode($result);
// $parsed_json = json_decode($json, true);
// if($parsed_json['status'])
// {
// echo $parsed_json['name'].", ".$parsed_json['email'].", ".$parsed_json['status'].", ".$parsed_json['id'];
// }
// else
// {
// echo $parsed_json['status'].", ".$parsed_json['error'];
// }
}
<?php
$ajax = (isset($_SERVER['HTTP_X_REQUESTED_WITH']) and strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest');
if ($ajax) {
include '../controller/createConnection.php';
$connection = new createConnection();
$conexion = $connection->connectToDatabase();
//$con = $connection ->selectDatabase($conexion); //creamos la conexion
}
$sql_get_users = "SELECT id, nombre, nickname, edad, id_categoria FROM users";
$consulta_users = $connection->_select_query($sql_get_users);
$elements = array();
//print_r($connection->result);
$cnt = 0;
for ($i = 0; $i < $connection->num_registros; $i++) {
$id = $connection->result[$i]['id'];
$nombre = $connection->result[$i]['nombre'];
$nickname = $connection->result[$i]['nickname'];
$edad = $connection->result[$i]['edad'];
$categoria = $connection->result[$i]['id_categoria'];
$aux = array('Id' => '"' . $id . '"', 'Nombre' => '"' . $nombre . '"', 'Nick' => '"' . $nickname . '"', 'edad' => '"' . $edad . '"', 'id_categoria' => '"' . $categoria . '"');
array_push($elements, $aux);
unset($aux);
//echo "mi array: ";var_dump($elements);
$cnt += 1;
}
/*
$rs_get_users = mysqli_query($conexion, $sql_get_users);
if($rs_get_users){
$num_lineas = mysql_num_rows($rs_get_users);
$elements = array();
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
echo ' ' . '<div class="modal fade" id="newUs" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">' . ' <div class="modal-dialog" role="document">' . ' <div class="modal-content" style="height: 400px;">' . ' <div class="modal-header">' . ' <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>' . ' <h4 class="modal-title" id="myModalLabel">Nuevo usuario</h4>' . ' </div>' . ' <div class="modal-body">' . ' <form id="nuevoUser" action="#">' . ' <div class="form-group">' . ' <label for="nombre">Nombre</label>' . ' <input type="text" class="form-control" name="nombre" id="nombre" placeholder="Nombre usuario">' . ' </div>' . '' . ' <div class="form-group">' . ' <label for="nombre">Apodo usuario</label>' . ' <input type="text" class="form-control" name="nickname" id="apodo" placeholder="Apodo usuario">' . ' </div>' . '' . ' <div class="form-group">' . ' <label for="nombre">Edad usuario</label>' . ' <input type="number" class="form-control" name="edad" id="edad" placeholder="Edad usuario">' . ' </div>' . '' . ' <div class="form-group">' . ' <label for="nombre">Categoria usuario</label>' . ' <select class="form-control" name="id_categoria">';
include '/controller/createConnection.php';
$conexion = new createConnection();
$conexion->connectToDatabase();
$sql_get_categ = "SELECT id, name FROM categoria";
$conexion->_select_query($sql_get_categ);
for ($i = 0; $i < $conexion->num_registros; $i++) {
echo '<option value="' . $conexion->result[$i]["id"] . '">' . $conexion->result[$i]["name"] . '</option>';
}
echo ' </select>' . ' </div>' . ' <div class="form-group">' . ' <button id="sendNewUser" class="button button--winona button--border-thin button--round-s" data-text="Crear" style="margin-top: 0px;"><span>Crear</span></button>' . ' </div>' . ' </form>' . ' </div>' . ' </div>' . ' </div>' . '</div>';
/*
include '/controller/modal.php';
$id = "edita_user";
$h = '<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>';
$h .= '<h4 class="modal-title" id="myModalLabel">Editar usuario</h4>';
$b = '<p>cuerpo del editor de usuario</p>';
$f = '<button type="button" class="btn btn-default" data-dismiss="modal">Cerrar</button>';
$f .= '<button type="button" class="btn btn-primary">Guardar cambios</button>';
$modal = new modal($id, $h, $b, $f);
*/
?>
<div class="modal fade bs-example-modal-lg" id="editUs" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<h5>Editar usuario</h5>
</div>
<div class="modal-body">
<div class="row">
<?php
$ajax = (isset($_SERVER['HTTP_X_REQUESTED_WITH']) and strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest');
if ($ajax) {
include '../controller/createConnection.php';
$connection = new createConnection();
$conexion = $connection->connectToDatabase();
//$con = $connection ->selectDatabase($conexion); //creamos la conexion
}
if (isset($_POST["campos"])) {
$vars = explode("&", $_POST["campos"]);
$names = array();
$values = array();
for ($i = 0; $i < COUNT($vars); $i++) {
$campo = $vars[$i];
$valores_campo = explode("=", $campo);
array_push($names, $valores_campo[0]);
array_push($values, $valores_campo[1]);
}
$connection->valores_add = $values;
$connection->rows = $names;
$table = "users";
echo "valores: ";
var_dump($connection->valores_add);
echo "rows: ";
var_dump($connection->rows);
$sql_get_campos = "SHOW COLUMNS FROM cproject_db.users";
//echo "campo rows: ";var_dump($connection->rows);
$added = $connection->_insert_query($table);
}
if ($ajax) {
<script src="javascripts/jobListEdit.js" type="text/javascript"></script>
</head>
<body>
<h3>List of all advertised and active jobs by you</h3>
<h4>For viewing or editing any job's decription, please click on that secific job row.</h4>
<?php
if (!empty($_GET['message'])) {
$message = $_GET['message'];
echo $message;
}
?>
<table border="2px">
<tr><th>Job Title</th><th>Job Description</th><th>Work Type</th><th>Location</th><th>Category</th><th>Date of Advertisement</th><th>End date of advertisement</th><th>Experience Level</th><th>Edit Job Option</th></tr>
<?php
$conn = new createConnection();
$conn->connectToDatabase();
$conn->selectDatabase();
$employerId = 2;
$sql = "SELECT * from job where EMPLOYER_ID = {$employerId}";
var_dump($sql);
$res = $conn->queryDatabase($sql);
if ($res) {
$num_rows = mysqli_num_rows($res);
for ($i = 0; $i < $num_rows; $i++) {
$row = mysqli_fetch_array($res);
$jobId = $row['JobID'];
$jobTitle = $row['JobTitle'];
$jobDesc = $row['JobDescription'];
$workType = $row['WorkTypeID'];
$district = $row['DistrictID'];
unset($RegionID, $RegionName);
$id = $row['RegionID'];
$desc = $row['RegionName'];
echo '<option value="' . $id . '" name="' . $id . '">' . $desc . '</option>';
}
$conn1->closeConnection();
?>
</select>
<select id="district" name="district">
<option value="">Please select district</option>
</select></p></td></tr>
<tr><td><p><label for="category"> <span id="astrick">*</span> Which Category:</label></td>
<td><?php
$conn1 = new createConnection();
// created a new object
$conn1->connectToDatabase();
$conn1->selectDatabase();
$result = $conn1->queryDatabase("select CategoryID, CategoryName from job_category");
// printf("Select returned %d rows.\n", $result->num_rows);
?>
<select id="category" name="category" <?php
if (isset($missing)) {
echo 'value="' . htmlentities($_POST['category']) . '"';
}
?>
>
<option value="">Select Category</option>
<?php
while ($row = $result->fetch_assoc()) {
<?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
<tr><td><p>
<input type="hidden" name="size" value="350000">
<label for="companyLogo">Company/Agent Logo:</label></td>
<td><input name="companyLogo" type="file" id="companyLogo" class="grayField" />
</p></td></tr>
<tr><td><p><label for="companyUrl">Company/Agent URL:</label></td>
<td><input name="companyUrl" type="text" id="companyUrl" class="grayField" value="<?php
echo $companyUrl;
?>
" /></p></td></tr>
<tr><td><p><label for="empType"> <span id="astrick">*</span> Employer Type:</label></td>
<td><?php
$conn1 = new createConnection();
// created a new object
$conn1->connectToDatabase();
$conn1->selectDatabase();
$result = $conn1->queryDatabase("select EMPLOYER_TYPEID, EMPLOYER_TYPE_DESCRIPTION from employer_type");
printf("Select returned %d rows.\n", $result->num_rows);
?>
<select id="empType" name="empType" class="grayField" value="<?php
echo $employerType;
?>
" >
<option value="">Select employer type</option>
<?php
// echo "$result->EMPLOYER_TYPEID";
//echo "$result->EMPLOYER_TYPE_DESCRIPTION";
while ($row = $result->fetch_assoc()) {
<input type="hidden" name="employer_id" value="<?php
echo $employer_id;
?>
">
<input type="hidden" name="seeker_email" value="<?php
echo $seeker_email;
?>
">
<input type="submit" value="SEND" name="submit" />
</form>
<br /><br />
<?php
$conn = new createConnection();
$conn->connectToDatabase();
$conn->selectDatabase();
$sql = "SELECT SeekerID from seeker_appliedjobs where JobID = {$JodID}";
var_dump($sql);
$result = $conn->queryDatabase($sql);
$num = mysql_numrows($result);
$seeker_idx = 1;
if ($num) {
echo "<table>";
echo "<tr>";
echo "<th>Index</th>";
echo "<td>Name</td>";
echo "<td>Email</td>";
echo "<td>View Detail</td>";
echo "<td>View Resume</td>";
