I am trying to insert some data into a table, but want to check for duplicate entries first.
I thought I could do this using:
if (!is_object($checksaved)) {
but I cannot get it to work.
Does anyone know what I am doing wrong?
<?php
$user = $modx->getUser();
$user = $user->get('id');
$job_id = trim($_REQUEST['job_id']);
// CHECK FOR DUPLICATE
$checksaved = "SELECT * FROM `saved_jobs` WHERE `job_id` = $job_id AND `user_id` = $user";
//echo $checksaved;
$checksaved = $modx->query($checksaved);
if (!is_object($checksaved)) {
$savejob = "INSERT INTO saved_jobs (user_id,job_id) VALUES ($user,$job_id);";
//echo $savejob;
$savejob = $modx->query($savejob);
echo "<div id='okmessage'><h3>Job saved successfully</h3></div>";
}
else {
echo "<div id='alertmessage'><h3>You have already saved this job.</h3></div>";
}
Many thanks!