<?php
include "template/template.php";
$recordresult = mysql_query("select * from internship where status = 1 AND (friendly_url is NULL OR friendly_url = '') ORDER BY id") or die(mysql_error());
while ($row = mysql_fetch_array($recordresult)) {
# get friendly url from title
$new_friendly_url = $vl_url_string = friendly_seo_string($row['internship_title']);
$counter = 1;
$intial_friendly_url = $new_friendly_url;
# while we not found unique friendly url
while (mysqli_num_rows(mysql_query("SELECT * FROM internship WHERE friendly_url = '{$new_friendly_url}' "))) {
# if friendly url is already used by other article
# -> increase counter until we find free url
$counter++;
# we reapeat this until url-2 url-3 url-4..... until we find not used url for articles
$new_friendly_url = "{$intial_friendly_url}-{$counter}";
}
# END while
# once we found friendly url we set it to articles table,
# then we can use it to build our frinedly url
echo "UPDATE internship SET friendly_url = '{$new_friendly_url}' WHERE id = {$row['id']}";
echo "<br />";
//$updqry = "UPDATE internship SET friendly_url = ? WHERE id = ?";
// if (!($stmt = $mysqli->prepare($updqry))){
// echo "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error;
// }
// $stmt->bind_param('si', $new_friendly_url, $rowid);
//
// if (!$stmt->execute()) {
// echo "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
// }
// echo "<br />file name11:" . $newname;
$function->image_size($_FILES['photo_path']['name'], $_FILES['photo_path']['tmp_name'], 250, 250, $newname, 300);
$update_query = mysql_query("UPDATE `providers` SET `photo_path` = '{$name_extension}' WHERE `id` = {$provider}");
// if this is a university, insert the record in university table
if (isset($_POST['is_university']) && $_POST['is_university'] == "1") {
$ins_university_qry = "INSERT INTO universities (university_name, logo, wiki_link, about_university, provider_id) VALUES ('{$new_provider}', CONCAT('providers/','{$name_extension}'), '{$wiki_link}', '{$about_provider}', {$provider})";
$university_insert = mysql_query($ins_university_qry);
}
}
}
}
//photo uploading end here
}
}
}
$new_friendly_url = friendly_seo_string($internship_title);
$counter = 1;
$intial_friendly_url = $new_friendly_url;
# while we not found unique friendly url
while (mysqli_num_rows(mysql_query("SELECT * FROM internship WHERE friendly_url = '{$new_friendly_url}' "))) {
# if friendly url is already used by other article
# -> increase counter until we find free url
$counter++;
# we reapeat this until url-2 url-3 url-4..... until we find not used url for articles
$new_friendly_url = "{$intial_friendly_url}-{$counter}";
}
# END while
$insert_query = "INSERT INTO `internship` (`internship_title`, `internship_subject`, `deadline`, `provider`,`note`,`email_official`, `payment_type`, `amount`,`duration`, `app_link`,`work_permit`, `posted_date`, `status`,`ain_status`, `last_updation`,`can_be_taken`, created_by, friendly_url, iframelinkstatus, `reminder_date`,`deadline_type`,`countries`) VALUES ('{$internship_title}', '{$internship_subject}', '{$deadline}', '{$provider}','{$note}','{$email_id}', '{$payment_type}', '{$amount}','{$duration}', '{$app_link}','{$work_permit}', '{$post_date}', '1','1', '{$post_date}','{$can_be_taken}', '{$_SESSION['admin_userid']}', '{$new_friendly_url}', '{$isworkinglink}', '{$reminder}', '{$deadline_type}','{$countries}')";
//echo $insert_query; exit;
$result = mysql_query($insert_query);
if ($result) {
$university_chk_row = mysql_query($university_chk_qry);
if (mysql_num_rows($university_chk_row)) {
$university_chk_res = mysql_fetch_array($university_chk_row);
if ($university_chk_res['university_name'] != "") {
$isuniversityexists = 1;
}
}
if ($isuniversityexists == 0) {
$ins_university_qry = "INSERT INTO universities (university_name, logo, wiki_link, about_university, provider_id, full_address, address_line1, address_line2, address_country, address_fullcountry, address_state, address_zipcode) VALUES ('{$new_provider}', CONCAT('providers/','{$name_extension}'), '{$p_wiki_link}', '{$p_about_provider}', {$provider_id}, '{$p_full_address}', '{$p_address_line1}', '{$p_address_line2}', '{$p_address_country}', '{$p_address_country_full}', '{$p_state_address}', '{$p_address_zipcode}' )";
$university_insert = mysql_query($ins_university_qry);
}
}
}
}
}
$new_friendly_url = friendly_seo_string($scholar_title);
$counter = 1;
$intial_friendly_url = $new_friendly_url;
# while we not found unique friendly url
while (mysql_num_rows(mysql_query("SELECT * FROM scholarship WHERE friendly_url = '{$new_friendly_url}' "))) {
# if friendly url is already used by other article
# -> increase counter until we find free url
$counter++;
# we reapeat this until url-2 url-3 url-4..... until we find not used url for articles
$new_friendly_url = "{$intial_friendly_url}-{$counter}";
}
# END while
if ($save_new_provider_flag == 1) {
$scholar_provider = $provider_id;
} else {
$scholar_provider = $org_provider_id;