Jump to content

lovephp

Members
  • Posts

    530
  • Joined

  • Last visited

Everything posted by lovephp

  1. ok while inserting can i get the inserted id so that i could add the whatever inserted id to the seo url?
  2. ok im trying to make seo url im creating slug ok but how do i insert along the id of that post? doing this following is definitely wrong im sure because i get 0 instead $id = $db->lastInsertId('id'); $stmt->execute(array( ':poster' => $uid, ':title' => $title, ':mobile' => $mobile, ':email' => $email, ':seourl' => ''.$id.'/'.$seourl how on earth i can acheive that?
  3. thanks a ton bro it does what i was looking for. really appreciate your time and kindness, all of you have always been great full to me with my issues.
  4. this is exactly what i was looking for bro really appreciate it. ok so i did this <?php //database credentials error_reporting(E_ALL); $servername = "localhost"; $username = "root"; $password = ""; $per_page = 1; try { $conn = new PDO("mysql:host=$servername;dbname=pagitest", $username, $password); // set the PDO error mode to exception $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); //echo "Connected successfully"; } catch(PDOException $e) { //echo "Connection failed: " . $e->getMessage(); } ?> <form method="get"> <select name="cat"> <option value="" selected="selected" disabled="disabled">Select Cat</option> <?php $stmt = $conn->prepare('SELECT DISTINCT cat FROM test'); $stmt->execute(); $row = $stmt->fetchAll(PDO::FETCH_ASSOC); echo '<option value="All">All</option>'; foreach($row as $rows){ echo '<option value="'.$rows['cat'].'">'.$rows['cat'].'</option>'; } ?> </select> <br/> <select name="area"> <option value="" selected="selected" disabled="disabled">Select Area</option> <?php $stmt = $conn->prepare('SELECT DISTINCT area FROM test'); $stmt->execute(); $row = $stmt->fetchAll(PDO::FETCH_ASSOC); echo '<option value="All">All</option>'; foreach($row as $rows){ echo '<option value="'.$rows['area'].'">'.$rows['area'].'</option>'; } ?> </select> <br/> <select name="type"> <option value="" selected="selected" disabled="disabled">Select Type</option> <?php $stmt = $conn->prepare('SELECT DISTINCT type FROM test'); $stmt->execute(); $row = $stmt->fetchAll(PDO::FETCH_ASSOC); echo '<option value="All">All</option>'; foreach($row as $rows){ echo '<option value="'.$rows['type'].'">'.$rows['type'].'</option>'; } ?> </select> <br/> <input type="submit" name="submit" value="submit"/> </form> <br/><br/> <?php if(isset($_GET['submit'])){ $cat = $_GET['cat']; $area = $_GET['area']; $type = $_GET['type']; // define the possible search fields - this is used to produce a data driven/dynamic design, where you don't write out block after block of code that only differs in the value it operates on $search_fields = array('cat','area','type'); $and_terms = array(); // WHERE terms to be AND'ed $params = array(); // bound input parameters for a prepared query foreach($search_fields as $field) { if(isset($_GET[$field]) && $_GET[$field] != 'All') // only if the field is set and it's not 'ALL' { // add the search field to the WHERE terms $and_terms[] = "$field = :$field"; $params[] = array(":$field",$_GET[$field],PDO::PARAM_STR); } } $where_term = ''; if(!empty($and_terms)) { $where_term = "WHERE " . implode(' AND ', $and_terms); } // get the total matching rows $query = "SELECT COUNT(*) FROM test $where_term"; // note: the following logic should be in a general purpose prepared query method that you extend the PDO class with if(empty($params)) { // no bound inputs, just execute the query $stmt = $conn->query($query); } else { // there are bound inputs, produce a prepared query, bind the inputs, and execute the query $stmt = $conn->prepare($query); foreach($params as $param) { $stmt->bindValue($param[0],$param[1],$param[2]); } $stmt->execute(); } $total = $stmt->fetchColumn(); // calculate total number of pages $pages = ceil($total / $per_page); // limit the page number $page = min($pages, filter_input(INPUT_GET, 'page', FILTER_VALIDATE_INT, array( 'options' => array( 'default' => 1, 'min_range' => 1, ), ))); // calculate starting row for LIMIT $offset = ($page - 1) * $per_page; // add limit values to the array of bound parameters $params[] = array(':per_page',$per_page, PDO::PARAM_INT); $params[] = array(':offset',$offset, PDO::PARAM_INT); // query for the data $query = "SELECT * FROM test $where_term ORDER BY id DESC LIMIT :per_page OFFSET :offset"; // note: the following logic should be in a general purpose prepared query method that you extend the PDO class with if(empty($params)) { // no bound inputs, just execute the query $stmt = $conn->query($query); } else { // there are bound inputs, produce a prepared query, bind the inputs, and execute the query $stmt = $conn->prepare($query); foreach($params as $param) { $stmt->bindValue($param[0],$param[1],$param[2]); } $stmt->execute(); } $result = $stmt->fetchAll(); if(!count($result)) { // query didn't return any row(s) - this doesn't mean there isn't any matching data, just that the query for the requested LIMIT range didn't return anything (there's a race condition, where if data gets deleted between the COUNT() query and the data retrieval query, queries for data near the end can return nothing) echo '<p>Nothing found.</p>'; } else { // query matched one or more row(s), display the data foreach ($result as $row) { echo '<br/>'.$row['name'].'<br/>'.$row['number']; } } // if there are any pages, display the pagination if($pages) { echo '<div id="pagination"> <div id="pagiCount">'; $q = $_GET; // get a copy of any existing $_GET parameters - do this once before the start of your pagination links $prevlink = ''; if($page > 1) // not on the first page { $q['page'] = 1; $qs = http_build_query($q,'','&'); $prevlink = "<a href='?$qs' title='First page'>First</a> "; $q['page'] = $page - 1; $qs = http_build_query($q,'','&'); $prevlink .= "<a href='?$qs' title='Previous page'><<</a>"; } $nextlink = ''; if($page < $pages) // not on the last page { $q['page'] = $page + 1; $qs = http_build_query($q,'','&'); $nextlink = "<a href='?$qs' title='Next page'>>></a> "; $q['page'] = $pages; $qs = http_build_query($q,'','&'); $nextlink .= "<a href='?$qs' title='Last page'>Last</a></span>"; } echo "<div id='paging'><p><small>$prevlink Page $page of $pages $nextlink </small></p></div>"; echo '</div></div>'; } } ?> all looks ok but from address bar the url looks like http://localhost/jobs/pagi.php?cat=reptile&area=All&type=pro&submit=submit how do i remove the &submit=submit and also the part if(!count($result)) { // query didn't return any row(s) - this doesn't mean there isn't any matching data, just that the query for the requested LIMIT range didn't return anything (there's a race condition, where if data gets deleted between the COUNT() query and the data retrieval query, queries for data near the end can return nothing) echo '<p>Nothing found.</p>'; } else { wont show the message nothing found when there is no value and i get following error which is ( ! ) Fatal error: in C:\wamp\www\jobs\pagi.php on line 152 ( ! ) PDOException: in C:\wamp\www\jobs\pagi.php on line 152 $stmt = $conn->prepare($query); foreach($params as $param) { $stmt->bindValue($param[0],$param[1],$param[2]); } $stmt->execute(); } this is there in line 152 $stmt->execute();
  5. this bit is given to me by someone $q = $_GET; unset($q["page"]); $currentlink = strtok($_SERVER["REQUEST_URI"],"?") . "?" . http_build_query($q, "", "&"); $prevlink = $currentlink . (empty($q) ? "" : "&") . "page=" . ($page - 1); $nextlink = $currentlink . (empty($q) ? "" : "&") . "page=" . ($page + 1); $lastlink = $currentlink . (empty($q) ? "" : "&") . "page=$pages"; but im confused on how to apply it to my existing codes
  6. so i remove the elseif then? will this be right? if($name !='') { $criteria[] = "name = '".$name."'"; }
  7. something like this will work right? <a href="?page=' . ($page + 1) . '"&$title="'.$_GET'['title'].'" "> but the thing is supposing i do something like filter i select just title and name or description is blank will the pagination still work?
  8. Mates help out in this please on pagination for search results would appreciate it and also if my codes look ok or not to you guy? <?php $title = clean($_REQUEST['title']); $name = clean($_REQUEST['name']); $description = clean($_REQUEST['description']); $criteria = array(); if($title !='') { $criteria[] = "title = '".$title."'"; }elseif($title =='All') criteria[] = "title = ''"; } if($name !='') { $criteria[] = "name = '".$name."'"; }elseif($name =='All') criteria[] = "name = ''"; } if($description !='') { $criteria[] = "description = '".$description."'"; }elseif($description =='All') criteria[] = "description = ''"; } try { $total = $db->query('SELECT COUNT(*) FROM table WHERE '.implode(' AND ', $criteria).'')->fetchColumn(); global $per_page; $pages = ceil($total / $per_page); $page = min($pages, filter_input(INPUT_GET, 'page', FILTER_VALIDATE_INT, array( 'options' => array( 'default' => 1, 'min_range' => 1, ), ))); $offset = ($page - 1) * $per_page; $start = $offset + 1; $end = min(($offset + $per_page), $total); $stmt = $db->prepare('SELECT * FROM table WHERE '.implode(' AND ', $criteria).' ORDER BY id DESC LIMIT :per_page OFFSET :offset'); $stmt->bindParam(':per_page', $per_page, PDO::PARAM_INT); $stmt->bindParam(':offset', $offset, PDO::PARAM_INT); $stmt->execute(); if ($stmt->rowCount() > 0) { $stmt->setFetchMode(PDO::FETCH_ASSOC); $iterator = new IteratorIterator($stmt); foreach ($iterator as $row) { echo $row['id']; } echo '<div id="pagination"> <div id="pagiCount">'; $prevlink = ($page > 1) ? '<span id="prev"><a href="?page=1" title="First page">First</a></span> <span id="prev"><a href="?page=' . ($page - 1) . '" title="Previous page"><<</a></span>' : ''; $nextlink = ($page < $pages) ? '<span id="next"><a href="?page=' . ($page + 1) . '" title="Next page">>></a></span> <span id="next"><a href="?page=' . $pages . '" title="Last page">Last</a></span>' : ''; echo '<div id="paging"><p><small>', $prevlink, ' Page ', $page, ' of ', $pages, '', $nextlink, '</small></p></div>'; echo '</div></div>'; } else { echo '<p>Nothing found.</p>'; } } catch (Exception $e) { echo '<p>Nothing found.</p>'; } ?> thanks alot
  9. i get you so for every fields i add new tables right?
  10. bro that link u posted its already fixed no issues with it now
  11. so what you suggest i just leave the field as it is without any validation?
  12. no no i will try to explain again 1. field 2. field 3. field by default if user adds nothing in those 3 fields form should throw no error but if user filled 2. field 3. field and forgot 1. field only then error shows you forgot to enter title
  13. ok this code below what i am trying to achieve is say a user fills up everything but forgot the jobtitle1 only then error message shows else if rest there is no value then data gets posted if($rjobtitle1 == '' || $rjobcompany1 != '' || $rjobcity1 != '' || $rjobfrom1 != '' || $rjobto1 != ''){ $error[] = 'Job title is required in <b>Experience</b> field 1.'; } but the error im facing now is even after i add data to jobtitle1 field i still get error message
  14. i keep getting error like this when i submit form SQLSTATE[23000]: Integrity constraint violation: 1048 Le champ 'r_maritalstatus' ne peut ĂȘtre vide (null) and if i select a value in r_maritalstatus then error shows for other field here is this code if(!isset($error)){ try { $stmt = $db->prepare('INSERT INTO resumes (r_name,r_email,r_mobile,r_address,r_dob,r_maritalstatus,r_nationality,r_religion,r_sex,r_objective,r_languagesknown,r_hobbies,r_expcategory,r_exptype,r_exptitle1,r_expcompany1,r_expcity1,r_expfrom1,r_expto1,r_expdescription1,r_exptitle2,r_expcompany2,r_expcity2,r_expfrom2,r_expto2,r_expdescription2,r_exptitle3,r_expcompany3,r_expcity3,r_expfrom3,r_expto3,r_expdescription3,r_exptitle4,r_expcompany4,r_expcity4,r_expfrom4,r_expto4,r_expdescription4,r_exptitle5,r_expcompany5,r_expcity5,r_expfrom5,r_expto5,r_expdescription5,r_eduinstname1,r_edudegree1,r_edustudyfield1,r_educity1,r_edupassed1,r_eduinstname2,r_edudegree2,r_edustudyfield2,r_educity2,r_edupassed2,r_eduinstname3,r_edudegree3,r_edustudyfield3,r_educity3,r_edupassed3,r_eduinstname4,r_edudegree4,r_edustudyfield4,r_educity4,r_edupassed4,r_eduinstname5,r_edudegree5,r_edustudyfield5,r_educity5,r_edupassed5,r_skill1,r_skillexp1,r_skill2,r_skillexp2,r_skill3,r_skillexp3,r_skill4,r_skillexp4,r_skill5,r_skillexp5) VALUES (:r_name, :r_email, :r_mobile, :r_address, :r_dob, :r_maritalstatus, :r_nationality, :r_religion, :r_sex, :r_objective, :r_languagesknown, :r_hobbies, :r_expcategory, :r_exptype, :r_exptitle1, :r_expcompany1, :r_expcity1, :r_expfrom1, :r_expto1, :r_expdescription1, :r_exptitle2, :r_expcompany2, :r_expcity2, :r_expfrom2, :r_expto2, :r_expdescription2, :r_exptitle3, :r_expcompany3, :r_expcity3, :r_expfrom3, :r_expto3, :r_expdescription3, :r_exptitle4, :r_expcompany4, :r_expcity4, :r_expfrom4, :r_expto4, :r_expdescription4, :r_exptitle5, :r_expcompany5, :r_expcity5, :r_expfrom5, :r_expto5, :r_expdescription5, :r_eduinstname1, :r_edudegree1, :r_edustudyfield1, :r_educity1, :r_edupassed1, :r_eduinstname2, :r_edudegree2, :r_edustudyfield2, :r_educity2, :r_edupassed2, :r_eduinstname3, :r_edudegree3, :r_edustudyfield3, :r_educity3, :r_edupassed3, :r_eduinstname4, :r_edudegree4, :r_edustudyfield4, :r_educity4, :r_edupassed4, :r_eduinstname5, :r_edudegree5, :r_edustudyfield5, :r_educity5, :r_edupassed5, :r_skill1, :r_skillexp1, :r_skill2, :r_skillexp2, :r_skill3, :r_skillexp3, :r_skill4, :r_skillexp4, :r_skill5, :r_skillexp5)'); $stmt->execute(array( ':r_name' => $rname, ':r_email' => $remail, ':r_mobile' => $rmobile, ':r_address' => $raddress, ':r_dob' => $rdob, ':r_sex' => $rsex, ':r_maritalstatus' => $rmaritalstatus, ':r_nationality' => $rnationality, ':r_religion' => $rreligion, ':r_objective' => $robjective, ':r_languagesknown' => $rlanguagesknown, ':r_hobbies' => $rhobbies, ':r_expcategory' => $rjobcategory, ':r_exptype' => $rjobtype, ':r_exptitle1' => $rjobtitle1, ':r_expcompany1' => $rjobcompany1, ':r_expcity1' => $rjobcity1, ':r_expfrom1' => $rjobfrom1, ':r_expto1' => $rjobto1, ':r_expdescription1' => $rjobdescription1, ':r_exptitle2' => $rjobtitle2, ':r_expcompany2' => $rjobcompany2, ':r_expcity2' => $rjobcity2, ':r_expfrom2' => $rjobfrom2, ':r_expto2' => $rjobto2, ':r_expdescription2' => $rjobdescription2, ':r_exptitle3' => $rjobtitle3, ':r_expcompany3' => $rjobcompany3, ':r_expcity3' => $rjobcity3, ':r_expfrom3' => $rjobfrom3, ':r_expto3' => $rjobto3, ':r_expdescription3' => $rjobdescription3, ':r_exptitle4' => $rjobtitle4, ':r_expcompany4' => $rjobcompany4, ':r_expcity4' => $rjobcity4, ':r_expfrom4' => $rjobfrom4, ':r_expto4' => $rjobto4, ':r_expdescription4' => $rjobdescription4, ':r_exptitle5' => $rjobtitle5, ':r_expcompany5' => $rjobcompany5, ':r_expcity5' => $rjobcity5, ':r_expfrom5' => $rjobfrom5, ':r_expto5' => $rjobto5, ':r_expdescription5' => $rjobdescription5, ':r_eduinstname1' => $reduinst1, ':r_edudegree1' => $redudegree1, ':r_edustudyfield1' => $redustudyfield1, ':r_educity1' => $reducity1, ':r_edupassed1' => $reduyear1, ':r_eduinstname2' => $reduinst2, ':r_edudegree2' => $redudegree2, ':r_edustudyfield2' => $redustudyfield2, ':r_educity2' => $reducity2, ':r_edupassed2' => $reduyear2, ':r_eduinstname3' => $reduinst3, ':r_edudegree3' => $redudegree3, ':r_edustudyfield3' => $redustudyfield3, ':r_educity3' => $reducity3, ':r_edupassed3' => $reduyear3, ':r_eduinstname4' => $reduinst4, ':r_edudegree4' => $redudegree4, ':r_edustudyfield4' => $redustudyfield4, ':r_educity4' => $reducity4, ':r_edupassed4' => $reduyear4, ':r_eduinstname5' => $reduinst5, ':r_edudegree5' => $redudegree5, ':r_edustudyfield5' => $redustudyfield5, ':r_educity5' => $reducity5, ':r_edupassed5' => $reduyear5, ':r_skill1' => $rskill1, ':r_skillexp1' => $rskillexp1, ':r_skill2' => $rskill2, ':r_skillexp2' => $rskillexp2, ':r_skill3' => $rskill3, ':r_skillexp3' => $rskillexp3, ':r_skill4' => $rskill4, ':r_skillexp4' => $rskillexp4, ':r_skill5' => $rskill5, ':r_skillexp5' => $rskillexp5 )); } catch(PDOException $e) { $error[] = $e->getMessage(); } } echo print_r($_POST); }
  15. sure give me sometime ill get back to bug u guys
  16. what is wrong in here that when i try to run this online i get just one image and rest of the images not being fetch also responsiveness is not working online but it works perfectly on my localhost using wamp <?php //signup.php include 'adm/connect.php'; $pid = $_REQUEST['id']; $sql = "SELECT * FROM topics WHERE topic_id = " . mysql_real_escape_string($pid); $result = mysql_query($sql); while($row = mysql_fetch_assoc($result)) { $top = stripslashes($row['topic_subject']); } ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>TOPIC | <?php echo $top; ?> - site.com</title> <link rel="stylesheet" href="css/responsee.css"> </head> <body style="font-family:Arial, Verdana;background-color:#fff;"> <!-- Caption Style --> <style> .captionOrange, .captionBlack { color: #fff; font-size: 20px; line-height: 30px; text-align: center; border-radius: 4px; } .captionOrange { background: #EB5100; background-color: rgba(235, 81, 0, 0.6); } .captionBlack { font-size:16px; background: #000; background-color: rgba(0, 0, 0, 0.4); } a.captionOrange, A.captionOrange:active, A.captionOrange:visited { color: #ffffff; text-decoration: none; } a.captionOrange:hover { color: #eb5100; text-decoration: underline; background-color: #eeeeee; background-color: rgba(238, 238, 238, 0.7); } .bricon { background: url(img/browser-icons.png); } </style> <script type="text/javascript" src="js-slide/jquery-1.9.1.min.js"></script> <script type="text/javascript" src="js-slide/jssor.js"></script> <script type="text/javascript" src="js-slide/jssor.slider.js"></script> <script> jQuery(document).ready(function ($) { var options = { $AutoPlay: true, $AutoPlaySteps: 1, $AutoPlayInterval: 8000, $PauseOnHover: 1, $ArrowKeyNavigation: true, $SlideDuration: 500, $MinDragOffsetToSlide: 20, $SlideSpacing: 0, $DisplayPieces: 1, $ParkingPosition: 0, $UISearchMode: 1, $PlayOrientation: 1, $DragOrientation: 3, $ArrowNavigatorOptions: { $Class: $JssorArrowNavigator$, $ChanceToShow: 1, $AutoCenter: 2, $Steps: 1 }, $ThumbnailNavigatorOptions: { $Class: $JssorThumbnailNavigator$, $ChanceToShow: 2, $ActionMode: 1, $AutoCenter: 3, $Lanes: 1, $SpacingY: 3, $DisplayPieces: 9, $ParkingPosition: 260, $Orientation: 1, $DisableDrag: false } }; var jssor_slider2 = new $JssorSlider$("slider2_container", options); function ScaleSlider() { var parentWidth = jssor_slider2.$Elmt.parentNode.clientWidth; if (parentWidth) jssor_slider2.$ScaleWidth(Math.min(parentWidth, 600)); else window.setTimeout(ScaleSlider, 30); } ScaleSlider(); $(window).bind("load", ScaleSlider); $(window).bind("resize", ScaleSlider); $(window).bind("orientationchange", ScaleSlider); }); </script> <div id="slider2_container" style="position: relative; top: 0px; left: 0px; width: 600px; height: 380px; overflow: hidden; "> <div u="loading" style="position: absolute; top: 0px; left: 0px;"> <div style="filter: alpha(opacity=70); opacity:0.7; position: absolute; display: block; background-color: #000000; top: 0px; left: 0px;width: 100%;height:100%;"> </div> <div style="position: absolute; display: block; background: url(img/loading.gif) no-repeat center center; top: 0px; left: 0px;width: 100%;height:100%;"> </div> </div> <div u="slides" style="cursor: move; position: absolute; right: 0px; top: 0px; width: 600px; height: 300px; overflow: hidden;"> <?php $qry = "SELECT post_img FROM posts WHERE post_topic = '" . mysql_real_escape_string($pid)."' ORDER BY post_id ASC"; $result = mysql_query($qry); while($row = mysql_fetch_array($result)) { $remove_symbols = array('../'); $img = str_replace($remove_symbols, " ", $row['post_img']); echo ' <div> <img src="'.$img.'" alt="Post Img" class="topicimg"> <img u="thumb" src="'.$img.'" /> </div> '; } ?> </div> <style> .jssora02l, .jssora02r, .jssora02ldn, .jssora02rdn { position: absolute; cursor: pointer; display: block; background: url(img/a02.png) no-repeat; overflow:hidden; } .jssora02l { background-position: -3px -33px; } .jssora02r { background-position: -63px -33px; } .jssora02l:hover { background-position: -123px -33px; } .jssora02r:hover { background-position: -183px -33px; } .jssora02ldn { background-position: -243px -33px; } .jssora02rdn { background-position: -303px -33px; } </style> <span u="arrowleft" class="jssora02l" style="width: 55px; height: 55px; top: 123px; left: 8px;"> </span> <span u="arrowright" class="jssora02r" style="width: 55px; height: 55px; top: 123px; right: 8px"> </span> <div u="thumbnavigator" class="jssort03" style="position: absolute; width: 600px; height: 50px; left:0px; bottom: 0px;"> <div style=" background-color: #000; filter:alpha(opacity=30); opacity:.3; width: 100%; height:100%;"></div> <style> .jssort03 .w, .jssort03 .pav:hover .w { position: absolute; width: 60px; height: 30px; border: white 1px dashed; } * html .jssort03 .w { width /**/: 62px; height /**/: 32px; } .jssort03 .pdn .w, .jssort03 .pav .w { border-style: solid; } .jssort03 .c { width: 62px; height: 32px; filter: alpha(opacity=45); opacity: .45; transition: opacity .6s; -moz-transition: opacity .6s; -webkit-transition: opacity .6s; -o-transition: opacity .6s; } .jssort03 .p:hover .c, .jssort03 .pav .c { filter: alpha(opacity=0); opacity: 0; } .jssort03 .p:hover .c { transition: none; -moz-transition: none; -webkit-transition: none; -o-transition: none; } </style> <div u="slides" style="cursor: move;"> <div u="prototype" class="p" style="POSITION: absolute; WIDTH: 62px; HEIGHT: 32px; TOP: 0; LEFT: 0;"> <div class=w><div u="thumbnailtemplate" style=" WIDTH: 100%; HEIGHT: 100%; border: none;position:absolute; TOP: 0; LEFT: 0;"></div></div> <div class=c style="POSITION: absolute; BACKGROUND-COLOR: #000; TOP: 0; LEFT: 0"> </div> </div> </div> </div> </div> </body> </html>
  17. Hehe no i didn't mean anyone writing it for me. Ill write the codes but you guys atleast help me where i do wrong was what i mean.
  18. Yes you are right i did not think of it that way. So how do i create cronjob i have no idea that was why i was hesitating on using it. And how do i do the query to send notification which was posted on today's date not old. Help w out on this please
  19. I was thinking od doing it on config file by creating a function which would all the time run?
  20. Bro i was thinking like Function sendAlerts(){ The queries here } And i include the sendAlerts(); in config file so it will always be running won't it?
  21. I get what you are saying, what i was looking for is like i got tables like jobs, resumes and what i wanted to do is in resume if user selected accounting category then any new job posting where category is accounting by 12:00 pm every day all the new jobs gets sent to users email and if category was any then all jobs be it any category all gets sent to those users. So how i would do the sql query and then also select all users from members table and email it to them. I haven't done like this before a little guidance would really be helpful. Thanks
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.