This page was exported from Galaxy Express [ http://www.galex.lt ]
Export date: Sun Mar 24 1:53:54 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 View

 

 


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

Powered by [ Universal Post Manager ] plugin. MS Word saving format developed by gVectors Team www.gVectors.com