<?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;