Galaxy Express
http://www.galex.lt/cv-list/
Export date: Sun Mar 24 1:52:44 2019 / +0000 GMT

CV List


[insert_php]

$con = mysqli_connect("localhost", "galex_wp", "6s9pq2G2", "galex_wp");

if ($con->connect_errno) {
die("Something went wrong.");
}
/*
$ads = $con->prepare("
SELECT DISTINCT LinkToImage,
CASE WHEN LEFT(Link,7) = 'http://' OR LEFT(Link,8) = 'https://' THEN Link
ELSE CONCAT('http://', Link)
END AS Link
FROM Advertisements
ORDER BY RAND()
LIMIT 1
");
$ads->execute();

$ads->bind_result($linkToImage,$link);

while ($ads->fetch()) {
echo '
Advertisement

';
}
echo '
';*/
echo '

SEAFARERS


';
$RankApplied = $_POST["RankApplied"];
$VesselsType = $_POST["VesselsType"];

$UserID = get_current_user_id();

if(isset($UserID)) {

$users = $con->prepare("
SELECT DISTINCT CV_Details.UserId,
CONCAT(FirstName, ' ', LastName) AS FullName,
FirstName,
RankApplied,
VesselsType,
CV_Ranks.Name,
Nationality,
DateAvailability
FROM CV_Details
LEFT JOIN CV_Ranks ON CV_Details.RankApplied = CV_Ranks.Id
WHERE FirstName <> ''
AND (RankApplied = '$RankApplied' OR '$RankApplied' = 0)
AND (VesselsType = '$VesselsType' OR '$VesselsType' = '')
AND Vis = 0
");
$users->execute();

$users->bind_result($Id, $FName, $FirstName, $RankApplied, $VesselsType, $RankName, $Nationality, $DateAvailability);

} else {
echo "There is no User ID detected, try to refresh browser.";
}

echo '

';
echo '
';
echo '';
echo '














































';
echo '

';

echo '';

echo '

';
[/insert_php]
[insert_php]
if ($UserID == 13) {
echo "";
}
[/insert_php][insert_php]
while ($users->fetch()) {
echo ""; if ($UserID == 13) { echo "";
} else {
echo "";
}
echo "";
echo "";
if ($UserID == 13) {
echo "";
}
if ($UserID == 13) {
echo "";
}
else {
echo "";
}
echo "";
}
[/insert_php]



















Name Rank Nationality Minimum Available Date Preview
$FName $FirstName $RankName $Nationality $DateAvailability View 1 View




Links:
  1. /resume/1/preview.php?Id=$Id
Post date: 2016-03-16 11:43:49
Post date GMT: 2016-03-16 09:43:49

Post modified date: 2018-12-29 12:58:21
Post modified date GMT: 2018-12-29 10:58:21

Export date: Sun Mar 24 1:52:44 2019 / +0000 GMT
This page was exported from Galaxy Express [ http://www.galex.lt ]
Export of Post and Page has been powered by [ Universal Post Manager ] plugin from www.ProfProjects.com