Jump to content

Search the Community

Showing results for tags 'php'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Welcome to PHP Freaks
    • Announcements
    • Introductions
  • PHP Coding
    • PHP Coding Help
    • Regex Help
    • Third Party Scripts
    • FAQ/Code Snippet Repository
  • SQL / Database
    • MySQL Help
    • PostgreSQL
    • Microsoft SQL - MSSQL
    • Other RDBMS and SQL dialects
  • Client Side
    • HTML Help
    • CSS Help
    • Javascript Help
    • Other
  • Applications and Frameworks
    • Applications
    • Frameworks
    • Other Libraries
  • Web Server Administration
    • PHP Installation and Configuration
    • Linux
    • Apache HTTP Server
    • Microsoft IIS
    • Other Web Server Software
  • Other
    • Application Design
    • Other Programming Languages
    • Editor Help (Dreamweaver, Zend, etc)
    • Website Critique
    • Beta Test Your Stuff!
  • Freelance, Contracts, Employment, etc.
    • Services Offered
    • Job Offerings
  • General Discussion
    • PHPFreaks.com Website Feedback
    • Miscellaneous

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests


Age


Donation Link

Found 2,407 results

  1. shan2batman

    notifications system not working

    Hi, guys i’m trying to create a notification alert for private message section in my project. The problem is everytime when the sender is sending message the notification bar shows new msg’s in sender profile and not in receivers profile. I don’t know where i’m going wrong so can any of you experts solve it. i’ll post the code here The private message page code: The db from where the queries are called from: CREATE TABLE IF NOT EXISTS `private_message` ( `pm_id` int(255) NOT NULL AUTO_INCREMENT, `r_seen` enum('0','1') NOT NULL, `receiver` varchar(255) NOT NULL, `sender` varchar(255) NOT NULL, `sent_time` datetime NOT NULL, `subject` varchar(255) NOT NULL, `message` text NOT NULL, `sdelete` enum('0','1') NOT NULL, `rdelete` enum('0','1') NOT NULL, `parent` varchar(255) NOT NULL, `has_replies` enum('0','1') NOT NULL, `rread` enum('0','1') NOT NULL, `sread` enum('0','1') NOT NULL, `receiver_uid` int(255) NOT NULL, `sender_uid` int(255) NOT NULL, `os_id` int(255) DEFAULT NULL, UNIQUE KEY `pm_id_2` (`pm_id`), KEY `pm_id` (`pm_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=95 ; The private message page code: <?php //error_reporting(0); include 'includes/header.php'; if (!isset($_SESSION['app'])) { header("location: index.php?usernotfound?id=017"); } $updateid=""; $title=""; $data=""; $sess_id=(int)$_SESSION['id']; $sess_uname = htmlentities($_SESSION['uname']); $session_uname = stripslashes($sess_uname); $f_uname0 = htmlentities($_GET['u']); $f_uname = stripslashes($f_uname0); $sql = "select * from user where uname=:uname and activated='1' limit 1"; $stmt = $conn->prepare($sql); $stmt->bindparam(":uname", $f_uname); $stmt->execute(); $row = $stmt->fetchAll(PDO::FETCH_ASSOC); $_SESSION['f_pm']=$f_uname; $f_uid=$row[0]['user_id']; $fname_s = $row[0]['fname']; $lname_s = $row[0]['lname']; $uname_s = $row[0]['uname']; $pmid= htmlentities($_GET['pmid']); if(isset($pmid)){ $updatedelete="update private_message set sread='1', r_seen='1' where pm_id=:pmid "; $stmt_r=$conn->prepare($updatedelete); //$stmt->bindValue(":originator",$originator); $stmt_r->bindValue(":pmid",$pmid); $stmt_r->execute(); } $is_friend=FALSE; $ownerblockviewer=FALSE; $viewerblockowner=FALSE; $isowner="no"; if($f_uid==(int)$_SESSION['id']&&isset($_SESSION['app'])){ $isowner="yes"; } if ($f_uname != $session_uname &&$_SESSION['app']==TRUE) { $freind_check = "select friend_id from friends where friend_one_uid=:session and friend_two_uid=:f_name and accepted='1' or friend_one_uid=:f_name and friend_two_uid=:session and accepted='1' limit 1"; $stmt = $conn->prepare($freind_check); $stmt->bindparam(":session", $sess_id); $stmt->bindparam(":f_name", $f_uid); $stmt->execute(); $isfriend=$stmt->rowCount(); if ($isfriend>0) { $is_friend = TRUE; } $blockcheck0 = "select blocked_id from blockedusers where blocker_uid=:f_name and blockee_uid=:session limit 1"; $stmt1 = $conn->prepare($blockcheck0); $stmt1->bindValue(":session", $sess_id); $stmt1->bindValue(":f_name", $f_uid); $stmt1->execute(); $owner= $stmt1->rowCount(); if ( $stmt1->rowCount()>0) { $ownerblockviewer = TRUE; } $blockcheck2 = "select blocked_id from blockedusers where blocker_uid=:session and blockee_uid=:f_name limit 1"; $stmt2 = $conn->prepare($blockcheck2); $stmt2->bindparam(":session", $sess_id); $stmt2->bindparam(":f_name", $f_uid); $stmt2->execute(); $viewer=$stmt2->rowCount(); if ($stmt2->rowCount() > 0) { $viewerblockowner = TRUE; } } $pm_ui=""; ?> <div class="container-fluid"> <br><div class="row"> </div><br> <div class="row"> <div class="col-sm-2 col-md-3 col-xs-4"> <div class="friend_pm"> <?php include 'notification/friend_pm.php'; ?> </div> </div> <div class="col-lg-8 col-xs-8 col-md-9"> <?php #if visitor to profile is friend and is not the owner, can send private message. #build ui carry the profile id, visitorname,pm subject and comments. if($is_friend==TRUE && $isowner=="no"){ $sql1="select * from private_message where(receiver=:u and sender=:sess and rdelete='0') " . "or " . "(sender=:u and receiver=:sess and sdelete='0' ) order by sent_time desc "; $stmt1=$conn->prepare($sql1); $stmt1->bindValue(":u",$f_uname); $stmt1->bindValue(":sess",$_SESSION['uname']); $stmt1->execute(); $fetch=$stmt1->fetchAll(PDO::FETCH_ASSOC); foreach ( $fetch as $row1) $pmid=$row1['pm_id']; $pm_ui='<hr><br><br>' . '<a class="btn mark-all mark_all_as_read" value="mark_all" originator="'. htmlentities($_SESSION['uname']).'" id="'.$pmid.'">Mark All as read</a><br>' . '<textarea id="pmtext" class="pm_message input-custom2" placeholder="Send a message"></textarea>' . '<br>' . '<button class="btn btn-warning pm_btn" attr="'.$row1['sender'].'" id="'.$f_uname.'" value="'.$pmid.'" type="new_pm" name="'.$session_uname.'">' . 'Send</button>'; } ?> <div id="status_ui"> <?php echo "<br><br><br><br><br><br><div class='jumbotron scroll-custom'>" . "<div class='pm_post'>"; include "notification/pm_inbox.php"; echo "</div></div>"; ?> <?php if($is_friend==TRUE&& $isowner=="no"){ echo $pm_ui; } ?> </div> <div class="col-sm-2 hidden-xs hidden-md"> </div> </div> </div> <script type="text/javascript"> var spinner="<img src='img/spinner.gif'>"; $(".pm_btn").click(function(){ var f_uname=$(this).attr('id'); var action=$(this).attr('type'); var s_uname=$(this).attr('name'); var pm_message=$(".pm_message").val(); var os_id=$(this).attr("value"); if(pm_message==""){alert("Please write something to send"); }else{ $.post("parser/pm_system.php", {"f_uname":f_uname,"action":action,"sess_uname":s_uname,"pm_message":pm_message,"os_id":os_id}, function(data){ $(".pm_message").val(""); // alert(data); // $(".jumbotron").prepend("<small>Reply from:-"+s_uname+" right now </small><br><p>"+pm_message+"</p>"); //lets the script scroll down to the bottom of the chat class automatically $(".scroll-custom").scrollTop($(".scroll-custom")[0].scrollHeight); });} }); $(".mark_as_read").click(function(){ var action=$(this).attr("value"); var id=$(this).attr("id"); var originator=$(this).attr("originator"); $.post("parser/pm_system.php", {"action":action,"pmid":id,"originator":originator}, function(data){ alert(data); }); }); $(".mark-all").click(function(){ var action=$(this).attr("value"); var id=$(this).attr("id"); var originator=$(this).attr("originator"); //alert(action+""+id+""+); $.post("parser/pm_system.php", {"action":action,"pmid":id,"originator":originator}, function(data){ alert(data); }); }); //logic for search box $(".search").keyup(function(){ var input=$(".search").val(); var length=input.length; $("#result").html(spinner).show(); var check=$(".checkbox-search").prop('checked'); if(check!=true){ $.post("search.php",({"(un|fn|ln)":input}),function(result){ $("#result").html(result).show(); }); }else if(check==true){ var input=$(".search").val(); $("#result").html(spinner).show(); $.post("search_group.php",({"group_name":input}),function(result){ $("#result").html(result).show(); }); } }); $(document).click(function(){ $("#result").hide(); }); function load_stuff(){ $(".pm_post").load("notification/pm_inbox.php"); } //loads friends who have sent messages function load_names(){ $(".friend_pm").load("notification/friend_pm.php"); } setInterval(function(){ load_stuff(); load_names(); },3000); $(document).click(function(){ $("#result").hide(); }); $("button.friend-add-btn").click(function(){ var id=$(this).attr('id'); var name=$(this).attr('name'); $(".spinner-friend-add"+id).html(spinner).show(); $.post( "parser/friend_sys.php", ({"user": name,"friend_one_uid":id}), function (data) { alert(data); $(".spinner-friend-add"+id).html(spinner).hide(); $(".friend_fade_"+id).fadeOut(); } ); }); $('[data-toggle="popover"]').popover(); //logic to accept fried request $(document).on("click", "button.accept_btn" ,function(){ var accept_id=$(this).attr('id'); var sess=$(this).attr('sess'); var name=$(this).attr('name'); $(".show-spinner").html(spinner).show(); $.post("notification/friend_req_accept.php",({"reqid":accept_id,"friend_two_uid":sess,"friend_two":name}),function(data){ $(".show-spinner").hide(); alert(data); }); }); //logic to reject friend request $(document).on("click", "button.reject_btn" ,function(){ var accept_id=$(this).attr('id'); $(".show-spinner").html(spinner).show(); $.post("notification/friend_req_reject.php",({"reqid":accept_id}),function(data){ $(".show-spinner").hide(); alert(data); }); }); //logic for sending friend requests // $("button.friend_btn").click(function () { $(document).on("click", "button.friend_btn",function(){ alert("see"); $(".friend").html(spinner).show(); var user_f = $(this).attr('user'); var id = $(this).attr('sess'); var name=$(this).attr('name'); $.post( "parser/friend_sys.php", ({"user": user_f,"friend_one_uid":id}), function (data) { alert(data); $(".friend").html(spinner).hide(); } ); //$(".friend").html(spinner).fadeOut(250); }); //logic to like this person button. $(document).on("click", "button.like_person_btn",function(){ $(".friend").html(spinner).show(); var user_f = $(this).attr('user'); var userid=$(this).attr('userid'); var id = $(this).attr('sess'); var name=$(this).attr('name'); $.post( "parser/like_this_person_parser.php", ({"user": user_f,"like_person_one_uid":id,"like_person_two_uid":userid}), function (data) { alert(data); $(".friend").html(spinner).hide(); } ); //$(".friend").html(spinner).fadeOut(250); }); //logic for blocking friends $(document).on("click", "button.block_btn",function(){ $(".show-spinner").html(spinner).show(); var user_f = $(this).attr('user'); $.post( "parser/block_system.php", ({"user": user_f}), function (data) { alert(data); } ); $(".show-spinner").html(spinner).fadeOut(250); }); $(document).on("click", "button.unfreind_btn",function(){ $(".show-spinner").html(spinner).show(); var user_f = $(this).attr('user'); $.post( "parser/unfriend_sys.php", {"user": user_f}, function (data) { alert(data); } ); $(".show-spinner").html(spinner).fadeOut(250); }); //logic for unblocking users whom were blocked $(document).on("click", "button.unblock_btn",function(){ $(".show-spinner").html(spinner).show(); var user_f = $(this).attr('user'); $.post( "parser/unblock_sys.php", ({"user": user_f}), function (data) { alert("You have unblocked this user"); $("button.unblock_btn").hide(); $("button.block_btn").show(); } ); $(".show-spinner").html(spinner).fadeOut(250); }); //to load notifications dynamically i used the set interval method. function load_notifications(thisview=''){ var theData = { view: thisview } $.ajax({ url: "notification/new_friends.php", method: "POST", data:theData, dataType:"json", success: function(data){ // alert(data); $(".drop-menu").html(data.notification); if(data.unseen_notification>0){ $(".badge1").html(data.unseen_notification); }else{ //alert(data); $(".drop-menu").html("No Notifications"); $(".badge1").html(data.unseen_notification);} } }); }; function notification(thisview=''){ var theData= { view: thisview } $.ajax({ url:"notification/ajax_notifications.php", method: "POST", data:theData, dataType: "json", success: function(data){ $(".notify-menu").html(data.notifications); if(data.unseen_notifications>0){ $(".badge3").html(data.unseen_notifications); } } }); } function notification_pm(thisview=''){ var theData= { view: thisview } var f_uname=$(".badge_pm").attr("type"); var sender=$(".badge_pm").attr("attr"); var sess=$(".badge_pm").attr("name"); var rcvr =$(".badge_pm").attr("id"); $.ajax({ url:"notification/ajax-pm-notification.php", method: "POST", data:{"theData":theData, "f_uname": f_uname}, dataType: "html", success: function(data){ if(data>0){ // alert(data); $(".badge_pm").html("New Msg's"); }else{ // alert(data); $(".badge_pm").html("No Msg's"); } } }); } //clicking on notification icon in header does this $(document).on("click", ".count_notification", function(){ var id=''; $.post("notification/count_notifications.php", {id:id}, function(data){ }); }); //load_notifications(); $(document).on("click",".count_friend", function(){ load_notifications('yes'); }); //loads every 2 seconds for chat setInterval(function(){ load_notifications(); notification(); notification_pm(); },5000); </script> </body> </html> the ajax notification page: <?php include '../includes/dbconfig.inc.php'; $f_uname= htmlentities($_POST['f_uname']); $mark="select parent,r_seen,rread,sread,receiver,sender from private_message where (receiver=:sess1 or sender=:sess2) and (r_seen='1' or r_seen='0') and (sread='1' or sread='0')"; $stmt_m=$conn->prepare($mark); $stmt_m->bindValue(":sess1", $_SESSION['uname']); $stmt_m->bindValue(":sess2", $_SESSION['uname']); //$stmt_m->bindValue(":f_uname", $f_uname); $stmt_m->execute(); $column=$stmt_m->fetch(); if ($column['r_seen']=='0'&&$column['parent']==$_SESSION['uname']) { echo'1'; // print_r($column); } elseif ($column['r_seen']=='1'&&$column['parent']==$_SESSION['uname']) { echo '0'; // echo 'old'; }elseif ($column['r_seen']=='0'&&$column['parent']!=$_SESSION['uname']) { echo '1'; //echo'new'; }elseif ($column['r_seen']=='1'&&$column['parent']!=$_SESSION['uname']) { echo '0'; // echo'new11'; } else { echo '0'; //print_r($f_uname); } logic for notifications in header: $mark="select rread,sread,receiver,sender from private_message where (receiver=:sess or sender=:sess) and has_replies='1' and rread='1' and sread='0'"; $stmt_m=$conn->prepare($mark); $stmt_m->bindValue(":sess", $_SESSION['uname']); //$stmt_m->bindValue(":f_uname", $f_uname); $stmt_m->execute(); $column=$stmt_m->fetch(); if($column['receiver']==$_SESSION['uname']&&$column['rread']>0&&$column['sread']==0) { if ($column['sender']!=$_SESSION['uname']) { print_r($column); $pm_n="<span class='badge_pm label label-pill label-success' type='".$f_uname."'>New Msg's</span><a href='private_message.php?u=".$_SESSION['uname']."'><img src='img/logo/message-white.png' alt='private_message'></a>"; } else { $pm_n="<span class='badge_pm label label-pill label-success' type='".$f_uname."'></span><a href='private_message.php?u=".$_SESSION['uname']."'><img src='img/logo/message-black.png' alt='private_message_alert'></a>"; } }elseif ($column['sender']==$_SESSION['uname']&&$column['rread']==1&&$column['sread']==0) { if ($column['receiver']!=$_SESSION['uname']) { $pm_n="<span class='badge_pm label label-pill label-success' type='".$f_uname."'></span><a href='private_message.php?u=".$_SESSION['uname']."'><img src='img/logo/message-black.png' alt='private_message_alert'></a>"; } else { print_r($f_uname); $pm_n="<span class='badge_pm label label-pill label-success' type='".$f_uname."'>New Msg's</span><a href='private_message.php?u=".$_SESSION['uname']."'><img src='img/logo/message-white.png' alt='private_message'></a>"; } }else { $pm_n="<span class='badge_pm label label-pill label-success' type='".$f_uname."'></span><a href='private_message.php?u=".$_SESSION['uname']."'><img src='img/logo/message-black.png' alt='private_message_alert'></a>"; }
  2. This brings up my complete novice question: How make a page go somewhere specific other than the top when it refreshes?
  3. Hi Been struggling to find a way to automatically go to the top of the page after the php contact form is executed, when the success message is displayed. Probhlem I have is that the form is quite long and when it is filled in the success or failure message is not fully seen as it displays at the top. Thanks Code below: <div class="row"> <div class="col-md-6"> <div class="offset-anchor" id="contact-sent"></div> <?php if (isset($arrResult)) { if($arrResult['response'] == 'success') { ?> <div class="alert alert-success" id="contactSuccess"> <strong>Success!</strong> Your message has been sent to us. </div> <?php } else if($arrResult['response'] == 'error') { ?> <div class="alert alert-danger" id="contactError"> <strong>Error!</strong> There was an error sending your message. (<?php echo $arrResult['error'];?>) </div> <?php } else if($arrResult['response'] == 'captchaError') { ?> <div class="alert alert-danger" id="contactError"> <strong>Error!</strong> Verificantion failed. </div> <?php } } ?>
  4. I'm working with a relationship table: id (AI), user_id, friend_id, status, type. The current behavior is that the Logged In user can send friendship requests to X user but if there is already a friendship request coming from the X user to the Logged In user; the logged in user instead of sending a new request to X user, he/she should accept the one that is already in the database(which is coming from the X-user). Here is an image of what I'm talking about(in the image, the status column displays 'accepted' but try to imagine it as it was 'pending', please) : So I currently have a function for adding friends for the current Logged-In user and it goes like this: public function follow($username){ // Check Login if(!$this->session->userdata('user_id')){ // Redirect to page redirect('users/login'); } // Get item $item = $this->User_model->get_username($username); // Already friends? $friendship = $this->User_model->the_relationship($item->id); if ($friendship->status == 'accepted' || $friendship->status == 'pending') { // Create Message $this->session->set_flashdata('error', 'You are already following this user.'); // Redirect to pages redirect('users/profile/'.$item->username); // BEGINNING OF - HERE IS WHERE THE PROBLEM IS } elseif($friendship->status == 'pending'){ // Get item $item = $this->User_model->get_username($username); // Page Data $data = array( 'user_id' => $item->id, 'friend_id' => $this->session->userdata('user_id'), 'status' => 'accepted', ); $this->User_model->updateFriendship($item->id, $data); /// END OF - HERE IS WHERE THE PROBLEM IS } else { // Get item $item = $this->User_model->get_username($username); // Page Data $data = array( 'user_id' => $this->session->userdata('user_id'), 'friend_id' => $item->id, 'status' => 'pending', 'type' => 'friendship', ); $this->Relationship_model->add($data); // Activity Array $data = array( 'resource_id' => $this->db->insert_id(), 'type' => 'friendship', 'action' => 'sent', 'user_id' => $this->session->userdata('user_id'), 'message' => '(' . $this->session->userdata('username') . ') sent a friend request to ('.$item->username.') ', ); // Insert Activity $this->Activity_model->add($data); // Set Message $this->session->set_flashdata('success', 'Friend request has been sent'); // Redirect redirect('users/profile/'.$item->username); } } and here are the two functions in the model which check the current status of the relationship between the current logged in user and the X user; the second function should update the status of the friendship if there is already one: LEGEND: $this->relationship: ci_relationship table $this->type: friendship type // Relationship for single public function the_relationship($id){ $this->db->select('*'); $this->db->from($this->relationship); $this->db->where('user_id', $this->session->userdata('user_id')); $this->db->where('friend_id', $id); $this->db->where('type', $this->type); $query = $this->db->get(); if($query->num_rows() >= 1){ return $query->row(); } else { return false; } } // Update Friendship Status public function updateFriendship($id, $data){ $this->db->where('user_id', $id); $this->db->where('friend_id', $this->session->userdata('user_id')); //$this->db->where('status', 'pending'); $this->db->where('type', $this->type); $this->db->update($this->relationship, $data); } I hope I could make myself clear. Thanks in advance.
  5. Hi I have a table that is filled with values already and now i want to add another column associate_id How can i update the columns with a random number? What i have is giving all the columns same number thanks $associates_id = mt_rand(10000, 99999); $stmt = $pdo->prepare("UPDATE associates SET associates_id= $associates_id "); $stmt->execute(); $affected_rows = $stmt->rowCount(); if ($affected_rows){ echo "DONE"; }else{ echo "NOT DONE"; }
  6. Hi, I am just getting a blank page and I am unable to figure out why such a simple concept is not working. Any help would be greatly appreciated. <?php //Error Check ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); try { $conn = new PDO("mysqli:host=$servername;dbname=$dbname", $username, $password); // set the PDO error mode to exception $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $statement = $conn->prepare("UPDATE test SET title= ? WHERE id= ?"); $statement->bind_param('si', $title,$id); $statement->execute(); if ($statement->affected_rows >0) { echo "Record updated successfully"; } else { echo "Error updating record: " . $conn->error; } $statement->close(); ?>
  7. Hi all, I currently have a table listed, with one of the rows being hyperlinked and linking to an input form, should be autopopulated from the code (ID or other unique identifier) of the row, however, when clicking the link the form does not load. I will insert relevant code to this thread and if anyone would be able to shed some light on this that would be great. NOTE: SQL code has already been tested using PHPMyAdmin and works fine. Although, it may need changed to help with this issue - I'm not quite sure. Please see screenshots for relevant code.
  8. I think I have this covered but want some feedback. When I receive a file I secure it by checking these values in $_FILES name: must be a valid filesystem file name (if I'm going to use it). I never did find a library out there that would validate filesystem parameters (names, paths). I just use a regular expression to look for things I know are illegal. name: length must not exceed filesystem limit plus path size: check for zero and max size type: validate against a list of allowed types (Wondering if someone could subvert the type here and cause trouble. Is there way to look inside a file and verify 'type'?) tmp_name: nothing to check error: should be zero Got it all? Thank you.
  9. elentz

    file name change help

    I am looking for a way to take a "default" file and create copies of the default file and rename with the entries in a list in a text file. I will have about 100 entries in the list. Fishing for ideas. Thanks
  10. I need to use rsync to keep a list of files synced with a server. I will have many "clients". On the clients I want to create a webpage where the user can operate a button and run the rsync command. I have the rsync and ssh setup with passwordless login using a RSA key The rsync command I can run from a command line or using cron. All that I have found to do this in php is this: <?php $copy = 'rsync -chavzP RcyEJtB2@xxx.xxx.yyy.yyy:/home/PhoneFirmware/ /var/www/html/cqfirmware/'; shell_exec ($copy); ?> I am open to any other way of doing this. Thanks for any ideas
  11. Mr-Chidi

    redirect selection

    Hi. Pls I have a form that contains countries. Let say i want to do something else if a country in among the countries in my list and something else if not included. how can i archive this simply without doing multiple ifs. eg direct listed countries to page A else direct to page B Thanks
  12. talmik

    Code for Year Count

    Hello all This bit of code is supposed to count the number of years between a creation date and the current date then place that number of years in the database. I seem to be missing something or have done something wrong. Can anyone see where it all went wrong?
  13. lilmer

    Dynamic URL

    I am new to Laravel, I have registration form which set an extension on the URL on the database table for each user. Example. I am using Laravel 5.6. Anyone can suggest what is the best way to get check if the URL exist on the database and it will proceed. As I now I try to set the Model and make a condition on the config/routes.php to check if the extension from database, but I know it is not the best solution.
  14. I have a table full of mac addresses in this format 80828704B0EE I need a method to run a query that will output this format 80:82:87:04:B0:EE I either need to insert the result of the some query that is formatting the existing mac addresses to another field or use a query to format the mac addresses on the fly. I need to create a csv file from this query. I have all that code it is just making the query to format it the way I need it. Here is a query I found that does the trick except that I get two columns, the original and the formatted one. How can I remove the mac column that this outputs? SELECT mac, concat(left(mac,2), ":",substring(mac,3,2), ":" , substring(mac,5,2), ":",substring(mac,7,2), ":",substring(mac,9,2), ":", right(mac,2)) as mac_formatted FROM phones Thanks
  15. I have a page that I use to scan (with a barcode scanner) a series of barcodes for mac addresses. The page is this code <form action="insert.php" method="post" id="phoneEntry"> <fieldset> <legend><h3>Phone MAC Entry:</h3></legend> <label for="phoneEntry_dealerName">Select Dealer</label> <select name="id" id="phoneEntry_dealerName">'; while ($dealer = $dealers->fetch_assoc()) echo ' <option value="', $dealer['id'], '">', $dealer['dealername'], '</option>'; echo ' </select> <label for="macEntry_hostedLocation">Enter the Location IP:</label> <input type="text" name="location"><br> <label for="macEntry_address">Input the MAC address:</label> <textarea name="mac" id="macEntry_address"> </textarea> <button>Save</button> </fieldset> </form>'; I scan into the text area and the MAC is much like this : 80828704B0EE I scanned in 14 different barcodes and in the database they were all shortened on the back bu 4 digits. Here is the insert.php code: Scanning the same barcode it is formatted and of the correct length in notepad+ $dealerid= "$_POST[id]"; $location= "$_POST[location]"; include('/var/www/html/hosted/index.html'); require('/var/www/html/hosted/utils/connect.php'); $stmt1 = $link->prepare(' INSERT INTO phones ( dealerid, location, mac ) VALUES ( ?, ?, ? ) '); $macList = preg_split('/[\s,]+/', $_POST['mac']); $stmt1->bind_param('iss', $dealerid, $location, $mac); foreach ($macList as $mac) $stmt1->execute(); So I am thinking that the issue is somewhere in the preg_split but I don't see it. I also need to save the same MAC address into the same table (different field) in this format 80:82:87:04:B0:EE I need to eventually run a report on both formats of each MAC entry. Thanks for any insight anyone might be able to give.
  16. Mr-Chidi

    PHP Gallery

    Hi all, I don't know if there's a gallery for this already or the right place to ask the question. User uploads multiple images. Images are store in a different folder and a unique name stored on the database. All images have a unique group for referencing purpose . When a user clicks on a link in his table he can view all images pertaining to a group. How can i go about that? What i want to achieve is for example SELECT ALL FROM IMAGE_TABLE WHERE USERNAME = USERNAME AND GROUP_ID = GROUP_ID Thanks
  17. What configuration, code or service is needed to hide root directories from a hosting. When I access it, do not show me what PHP classes I'm in. If so, hide folders but keep making use of the chain of classes that have a relationship.
  18. EmmanuelCorrea

    Resource id#51

    Good day community. With a doubt that I could not find a solution. I'm trying to log in, I have my user and my password registered (so the user does exist), but at the time of entering, he only sends me a Resource id # 51, I clarify that this is under a server, I have my bd too hosted on host, all right. Also, I do this function in localhost and I login correctly. I came across this "error" or result already when it was on the host of the server to which I do not know what is due. This is my code. $sql = sprintf("SELECT * FROM usuario WHERE usuario = '%s' AND contrasena = '%s' ", mysql_real_escape_string($usuario), mysql_real_escape_string($contrasena)); $query=mysql_query($sql); //echo mysql_errno().":".mysql_error(); echo $query; $verificar=mysql_num_rows($query); echo $verificar; if($verificar==1){ //El logueo es exitoso y se crea la sesion if($valores = mysql_fetch_assoc($query)){ if($valores['puesto'] == 'A'){ $_SESSION['usuario'] = $usuario; //header("HTTP/1.1 302 Moved Temporarily"); //header("Location: ../indexMenu.php"); }else if($valores['puesto'] == 'B'){ $_SESSION['alumno'] = $usuario; header("HTTP/1.1 302 Moved Temporarily"); header("Location: ../../../alumnos/php/indexMenu.php"); } }else{ echo 'No se ha podido iniciar sesion, por favor vuelva a intentarlo.'; }
  19. EmmanuelCorrea

    Resource id #51

    Buen día comunidad. Con una duda que no he podido encontrar una solución. Estoy intentando hacer un logueo, tengo mi usuario y mi contraseña dada de alta (osea que el usuario si existe), pero al momento de ingresar solamente me manda un Resource id #51, aclaro que esto es bajo un servidor, tengo mi bd tambien alojada en host, todo correcto. También que hago esta función en localhost y me hace el login correctamente. Me tope con este "error" o resultado ya cuando se encontraba en el host del servidor a lo cual no se a que se deba. Este es mi código. $sql = sprintf("SELECT * FROM usuario WHERE usuario = '%s' AND contrasena = '%s' ", mysql_real_escape_string($usuario), mysql_real_escape_string($contrasena)); $query=mysql_query($sql); //echo mysql_errno().":".mysql_error(); echo $query; $verificar=mysql_num_rows($query); echo $verificar; if($verificar==1){ //El logueo es exitoso y se crea la sesion if($valores = mysql_fetch_assoc($query)){ if($valores['puesto'] == 'A'){ $_SESSION['usuario'] = $usuario; //header("HTTP/1.1 302 Moved Temporarily"); //header("Location: ../indexMenu.php"); }else if($valores['puesto'] == 'B'){ $_SESSION['alumno'] = $usuario; header("HTTP/1.1 302 Moved Temporarily"); header("Location: ../../../alumnos/php/indexMenu.php"); } }else{ echo 'No se ha podido iniciar sesion, por favor vuelva a intentarlo.'; } Espero puedan ayudarme, ya que es mi proyecto de Titulación!
  20. Hi everyone, The following code is aimed to show "aaa aaa" as default value for input box in a form: <?php //xxx.php $db = mysqli_connect('localhost', '', '', ''); ?> <!DOCTYPE html> <html> <body> <form method="POST" action="xxx.php"> <input type="text" name="id" class="id_input" value=<?php echo 'aaa aaa';?>> </form> </body> </html>
  21. This is my array. It has stored images data. [other-image] => Array ( [img] => Array ( [0] => 1526973657.jpg [1] => 1526973661.jpg [2] => 1526973665.jpg ) [path] => Array ( [0] => ../post-upload/1/ [1] => ../post-upload/1/ [2] => ../post-upload/1/ ) [type] => Array ( [0] => 1 [1] => 1 [2] => 1 ) [thumb] => Array ( [0] => thumb_1526973661.jpg [1] => thumb_1526973665.jpg [2] => thumb_1526973668.jpg ) ) Now I want to delete an image and it's all related data from sub arrays. (path, type, thumb data) This is how I tried it in php: $delkey = $_POST['key']; if(in_array($delkey, $_SESSION['other-image']['img'])){ $imgkey = array_search($delkey, $_SESSION['other-image']['img']); if($imgkey) unset($_SESSION['other-image']['img'][$imgkey]); //file path $fp = UPLOAD_DIR.$nextId."/".$delkey; unlink($fp); } As I did, its only deleting element form 'img' array, but I want to delete related data from other arrays too. Can anybody tell me how to do this? Thank you.
  22. sigmahokies

    Valdiation

    Hi everyone, I am trying to have "require" label on form. If someone did not select the option on list, then "require" label will appear in form after submit. Seem my code isn't work. what did I do wrong? <?php$buzz = $buzz2 = ""; if ($_SERVER['REQUEST_METHOD'] == "POST") { if (empty($_POST['select'])) { $buzz = "<h2><color color='red'> >- </color></h2>"; $buzz2 = "<h2><color='red'> -< </color></h2>"; }} ?><!DOCTYPE html><html lang="en"><head> <meta charset="UTF-8"> <title>XXXXXX</title> <link href="default.css" rel="stylesheet" type="text/css"></head><body><fieldset><h1>XXXXXXX</h1> <table> <form action="login.php" method="post"> <select name="select"> <?php echo $buzz ?><option value="" >Please select the level</option><?php echo $buzz2 ?> <option value="Administrator">Administrator</option> <option value="License">License</option> <option value="Scorer">Scorer</option> </select> <caption>Please login to enter the site below:</caption> <tr><td>Username:</td><td class="td"><input type="text" name="user"></td></tr> <tr><td>Password:</td><td class="td"><input type="password" name="password"></td></tr> <tr><td colspan="2"><input type="submit" name="submitted" value="Login"></td></tr> </form> </table></fieldset></body></html> Thanks for helping Gary Taylor
  23. KillGorack

    Filter array by KEY

    I would like to create an array from the one below that can sort of filter using date ranges; For example, make an array that contains data using date <= 2018-05-09 without a loop. A loop is an option just wondering if you can filter by keys somehow. Array ( [2018-04-23 21:31:40] => -1.174 [2018-04-24 15:43:59] => -1.015 [2018-04-26 00:14:10] => -0.37 [2018-04-30 18:41:51] => -1.042 [2018-05-01 20:08:40] => -0.72 [2018-05-02 22:11:52] => -0.107 [2018-05-07 18:40:12] => -0.298 [2018-05-09 16:35:38] => -0.36 [2018-05-10 01:14:27] => 0.408 [2018-05-14 20:49:54] => 1.549 )
  24. Hi all, I need your help. I am working on a function to add the day value that start from 0 to 6. I want to count it up the value for each day so I can connect to each url for each day, but on my code it will only show the value as 0 for each day. Here is the code: <?php $channels = json_decode(file_get_contents('channels.json'), true); $day = 0; function get_shows($channel_id, DateTime $dt, $duration=1440, $skip_finished = true) { $url = 'http://example.comapi/GS?cid=' . $channel_id . '&offset=+00.00&day=' .$day++; echo $url; $day++; } if(!isset($_GET['id']) || !isset($channels[$_GET['id']])) { } else { // today + 6 following days for($day=0; $day<=6; $day++) { // display date echo '<h3>', $dt->format('Y-m-d (l)'), '</h3>'; // display shows foreach(get_shows($channel_id, $dt, $duration) as $show) { } $dt->add(new DateInterval('P1D')); $dt->setTime(0, 0, 0); } } ?> Output: Here is what I want to achieve: Can you please show me an example how I can add the value up for each day that start from 0 to 6 when I am calling on get_show function??
×

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.