Jump to content

Search the Community

Showing results for tags 'mysql'.



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 803 results

  1. Hi guys, Whats the best way of sending mails from multiple table? This is what i did, but i feel there should be a better way of doing it cos sometime it delivers and sometimes it doesn't (don't know why though). Thanks $subj="New Sign up Notification"; $header="MIME-Version: 1.0" . "\r\n"; $header .="Content-type:text/html;charset=UTF-8" . "\r\n"; $header .="From: GOODGUYS<noreply@yoyo.com>"; //TABLE 1 $t1 = "table1"; $stmt = $pdo->query(" SELECT t1_email, t1_name FROM $t1 "); while($rows = $stmt->fetch(PDO::FETCH_ASSOC)){ $t1_name = $rows['t1_name']; $t1_email = $rows['t1_email']; $t1_msg =" <html> <body> <h3>Subject: News</h3> <p> Hi $t1_name, <br> This is a message to you blah blah blah </p> <p> Thank you.<br> </p> </body> </html> "; mail($t1_email,$subj,$t1_msg,$header); } //TABLE 2 $t2 = "table2"; $stmt = $pdo->query(" SELECT t2_email, t2_name FROM $t2 "); while($rows = $stmt->fetch(PDO::FETCH_ASSOC)){ $t2_name = $rows['t2_name']; $t2_email = $rows['t2_email']; $t2_msg =" <html> <body> <h3>Subject: News</h3> <p> Hi $t2_name, <br> This is a message to you blah blah blah </p> <p> Thank you.<br> </p> </body> </html> "; mail($t2_email,$subj,$t2_msg,$header); } //TABLE 3 $t3 = "table3"; $stmt = $pdo->query(" SELECT t3_email, t3_name FROM $t3 "); while($rows = $stmt->fetch(PDO::FETCH_ASSOC)){ $t3_name = $rows['t3_name']; $t3_email = $rows['t3_email']; $t2_msg =" <html> <body> <h3>Subject: News</h3> <p> Hi $t3_name, <br> This is a message to you blah blah blah </p> <p> Thank you.<br> </p> </body> </html> "; mail($t3_email,$subj,$t3_msg,$header); }
  2. ttsprez

    Query Statement Help

    I'm having an issue with a query statement pulling info: This link carries customers to a "document gateway" where they are required to enter a reference code. https://pdforms.losttitleconnection.net/TX Title App Gate.php Use this Reference Code for test purpose: QKEX49MKDE On submit the PHP code is to take the reference code from the Post function of the gateway form and convert it to a variable $refcode This variable is then used in the query statement to pull 'name' and 'data' from the form_data table and use it to replace form field names with data in an html template. Then it is to present the new form in a pdf format to the browser for download or printing. I'm using the dompdf library to do this, but for now, am only using a short query test code to ensure I'm pulling the correct data by having the code display results. Currently, on submit, the browser is presenting the following: SELECT name,data FROM thetitl1_livesite754.form_data WHERE form_id IN(SELECT id FROM thetitl1_livesite754.forms WHERE reference_code = '') The following is the code as it appears in my PHP file. Help to get this figured out would be greatly appreciated. <?php //create a connection to MySQL require 'dogs.php'; //query for reference_code from 'forms' table $refcode = filter_input(INPUT_POST,'reference_code'); $mysqli = new mysqli($server, $username, $password, $dbase); $query = "SELECT name,data FROM thetitl1_livesite754.form_data WHERE form_id IN(SELECT id FROM thetitl1_livesite754.forms WHERE reference_code = '" . $refcode . "')"; die($query); $results = $mysqli->query($query); $new_form = file_get_contents("TX_Title_App.html"); //Replaces form_fields in html temp with "data" if ($results) { //below is the line referenced in error message above while ($row = mysqli_fetch_fields($results)) { echo $row["name"] . ":" . $row["data"] . "<br>"; $new_form = str_replace($row["name"], $row["data"], $new_form); } } ?>
  3. 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>"; }
  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 all ! The following query gave no error earlier in version 5.6 SELECT mr.xid, fd.fname, fd.lname, fd.cell, fd.email, a.country_id, a.state_id, a.city_id, a.pin_id, sd.center_No, count(sd.fid) total, sum(case when sd.member_center_status='R' then 1 else 0 end) Acticount FROM master_recruitment as mr JOIN user_details as fd ON fd.user_id = mr.xid JOIN addresses as a ON a.fid = mr.xid JOIN member_details as sd ON sd.fid = mr.xid WHERE mr.mid = 6 GROUP by sd.fid, sd.center_No LIMIT 1, 10; gives the error : Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mytestdb.a.country_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by; in version 5.7 of mysql. I have googled but could not really understand the reason the problem is occuring. Please help Thanks.
  7. Hi there. I got a table named `area` that has a POLYGON field. There are some rows with specified area in table. Now i want to check if a point ("59.5594597, 36.3556769" for example) is within the polygons or not. searched a lot and none works. my polygon has 102 points in case of need. Thanks.
  8. 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?
  9. Hi All, I have 4 tables each with only 2 columns (except for one that has 3) and they all have in common a date/time field. I am trying to export all 4 tables together as one CSV file and to have the records matched together where they have the same date/time. My tables are structured like so (which originally came from 4 individual CSV files): So as an exported CSV I would want the matching records (based on the date/time) to be part of the same record like so: Time, heartrateValue, Intensity, minutesleepValue, minutesleepLogId, steps 3/01/2018 0:01, 45, 0, 1, 17396451215, 0 3/01/2018 0:02, 45, 0, 1, 17396451215, 0 etc. A secondary issue is changing the date format to D/MM/YYYY from M/DD/YYYY. However, if I can get this CSV file export I can probably just loop through it in PHP and fix up the date format. Thank you kindly for your assistance
  10. 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
  11. 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.
  12. I-AM-OBODO

    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
  13. 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.'; }
  14. 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!
  15. I have a mySQL database with some of the tables and fields being: CLIENT - clientid, client MATTERS - matterid, clientid, refno, nickname MATTERJUNACTIONS - matterid, notes, fee, actiondate EXPENSES - expensid, matterid, expensedate, amount A client can have many matters and each matter can have many actions and a number of expenses. I want to produce a report which has a separate row for each action or expense together with matter and client details. The report column headers would be: clientid | client | refno | nickname | actiondate | note | fee | expensedate | amount | I have a query: SELECT client.clientid, client.client, matters.refno, matters.nickname, matterjuncactions. actiondate, matterjuncactions.notes, matterjuncactions.fee FROM client INNER JOIN matters ON client.clientid=matters.clientid LEFT JOIN matterjuncactions ON matters.matterid=matterjuncactions.matterid LEFT JOIN expenses ON matters.matterid=expenses.matterid WHERE client.clientid = 238 This produces a report with a number of rows but doesn't separate the rows with expenses on a different row to the actions. I get something like: 238 | ABC Ltd | 1245 | matternickname | 2018/4/1 | this is the action note | 50 | 2018/4/15 | 25 | Rather than 238 | ABC Ltd | 1245 | matternickname | 2018/4/1 | this is the action note | | | | 238 | ABC Ltd | 1245 | matternickname | | | 50 | 2018/4/15 | 25 | What am I doing wrong?
  16. I am trying to insert data from my mother language (Sinhala) into my mysql table. But MySQL displays my chracters as question marks. This is how I test it: CREATE DATABASE sinhala_test; USE kindheart; ALTER DATABASE sinhala_test CHARACTER SET utf8 COLLATE utf8_general_ci CREATE TABLE IF NOT EXISTS `category` ( `category_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name_si` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL, `description_si` TEXT COLLATE utf8_unicode_ci NOT NULL, `last_update` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`category_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; INSERT INTO `category` VALUES (1,'පොත් පත් සහ පාසල් උපකරණ','නවතම පොත් පත් අවශ්‍යතා ඇතුළු සියළුම පාසැල් හා අධ්‍යාපන මෙවලම්.',NOW()); This is what can I get from MySQL command line: mysql> select * from category\G *************************** 1. row *************************** category_id: 1 name_si: ???? ??? ?? ????? ????? description_si: ???? ??????? ??????? ????????. ????/????????? ????? ?????? ?????? ?? ???????? ??????. last_update: 2018-05-20 11:11:20 Can anybody tell me how can I fix this problem? NOTE: When inserting from phpMyAdmin its correctly work.
  17. I am retrieving data from multiple joined tables that contain around 3,500 rows each. I am only showing limited results but the load time is the same. Like it takes 5 seconds to load the page. I don't want this same issue to continue if I am predicting over 1,000,000 rows from these tables. So what's the best way to fix this? Here is my query. $get_members = $db->prepare("SELECT users.*, approvals.*, sponsors.* FROM approvals LEFT JOIN users ON approvals.user_id = users.user_id LEFT JOIN sponsors ON approvals.user_id = sponsors.sponsored_user WHERE user_id > :user_id ORDER BY user_id DESC LIMIT 20"); $get_members->bindValue(':user_id', 0); $get_members->execute(); $result_members = $get_members->fetchAll(PDO::FETCH_ASSOC); if(count($result_members) > 0) { foreach($result_members as $row) { // show results here } } else { echo 'none'; } if(count($result_members) < 20) {} else { // show-more button here }
  18. I have two tables. Table-1 is Campaigns and Table-2 is Earnings. I simply want to list the Campaigns from high to low earnings or vice versa. But I don't know how to do that since it's two separate tables. Here are the two queries I have. The query shows that the Campaigns will be listed by their campaign_id. I want to be able to order them by their earnings. How do I do that with these two queries? $find_campaign = $db->prepare("SELECT * FROM campaigns WHERE status = :status ORDER BY campaign_id DESC LIMIT 10"); $find_campaign->bindValue(':status', 1); $find_campaign->execute(); $result_find_campaign = $find_campaign->fetchAll(PDO::FETCH_ASSOC); if(count($result_find_campaign) > 0) { foreach($result_find_campaign as $row) { $campaign_id = trim($row['campaign_id']); $campaign_goal = trim($row['campaign_goal']); $get_raised = $db->prepare("SELECT deposit FROM earnings WHERE campaign_id = :campaign_id"); $get_raised->bindParam(':campaign_id', $campaign_id); $get_raised->execute(); $result_raised = $get_raised->fetchAll(PDO::FETCH_ASSOC); if(count($result_raised) > 0) { $ub = 0; foreach($result_raised as $key=>$row) { $campaign_raised = trim($row['deposit']); } } else { $campaign_raised = 0; } //show campaign html here } }
  19. i'am trying to get the users rank so i can display their rank in a div.. i.e you are 30 out of 400 users at getting sales. So far i ve managed to get the order of the users but thats it: i count the date_mades as sales made to get the totals. SELECT usr_id, count(date_made) as dater, @curRank := @curRank + 1 AS rank FROM firsts group BY usr_id order by dater desc gives me : usr_id dater rank 1 20 NULL 16 3 NULL 3 2 NULL 5 1 NULL 9 1 NULL 22 1 NULL 25 1 NULL i found this answer (Attached snippet) but i just get red crosses all over the statement when i try and run it: does anyone else get errors just pasting this into their phpmyadmin? is it a parser problem or syntax? SELECT pid, name, age, rank FROM (SELECT pid, name, age, @curRank := IF(@prevRank = age, @curRank, @incRank) AS rank, @incRank := @incRank + 1, @prevRank := age FROM players p, ( SELECT @curRank :=0, @prevRank := NULL, @incRank := 1 ) r ORDER BY age) s
  20. I'm trying to build some data in an excel report through PHP but I'm still having trouble getting the array structure and foreach loops the way I need them. Basically, I'm pulling a select on Mysql, matching it to a select in DB2 ( I need values from each) and then I need to loop the results and perform some calculations and then relate it back to the highest level array for the report. My first query pulls records like this: sku_id | customer_id | locations | group_id | frame | cover | color | start_date 1 5400 2 1 1051 1150 99 2018-02-09 1 5401 3 1 1051 1150 99 2018-02-09 Based on those results I pull a query on DB2 that gets every record since that start_date where those customers ordered that same sku_id so I'm getting multiple records for the sku_id/customercombo. That query returns something like this: customer | frame | cover | color | date | TotalQTY 5400 1051 1150 99 2018-02-09 5 5400 1051 1150 99 2018-02-19 2 5400 1051 1150 99 2018-03-09 5 5401 1051 1150 99 2018-02-11 1 5401 1051 1150 99 2018-02-15 7 5401 1051 1150 99 2018-02-25 5 The queries work and my arrays are printing with the proper data, but I need some guidance on structuring these right. I'm matching the SKU up by attributes like cover, color and frame. I need to look first at each sku_id from the first query, execute the 2nd and then look at each customer to get their total quantity of that sku. So based on the example above I would need to get a total quantity of 12 for customer # 5400 and 13 for customer #5401, both for sku 1. My end goal is to get the total quantity of sku on a per dealer basis, so with the example above, my report would look like this: SKU | GROUP | TotalQTY ----------------------------------------- 1 1 25 My array structure looks right as far as my first foreach (foreach sku, perform the query, which returns an array for each record per customer). I'm not sure how to do the foreach on the customer so that I can work on a per customer basis and get the total quantity of that sku per customer. I feel like I would need to say for each dealerRslt as Customer, total all totalQTY Here's the portion of the script in question: $skuQuery = " SELECT sku_id, customer_id, locations, s.sku_group_id as groupID, s.frame as frame, s.cover1 as cover, s.color1 as color, start_date - interval 7 day as start_date from products p inner join skus s on p.sku_id = s.id where curdate() between p.start_date and p.expire_date group by sku_id, customer_id"; $skuRslt = mysqli_query($conn,$skuQuery); while($skuRow = mysqli_fetch_assoc($skuRslt)){ $skuResult[] = $skuRow; $dealerQuery = " SELECT customer, frame, cover, color, cast(Left(date, 4)||'-'||substring(date,5,2)||'-'||substring(date, 7,2) as date) as start_date, sum(orqtyc) as TotalQTY from table1 where customer = {$skuRow['dealer_id']} AND frame = {$skuRow['frame']} AND color = {$skuRow['color']} AND cover = {$skuRow['cover']} AND date >= " . str_replace('-', '', $skuRow['start_date']) . " group by customer, frame,cover,color,date "; $dealerRslt = odbc_exec($DB2Conn, $dealerQuery); foreach($skuResult as $skuRow){ while($dealerRow = odbc_fetch_array($dealerRslt)){ $dealerResult[] = $dealerRow; print_r($dealerResult); } } }
  21. I'm trying to restructure my arrays so that I can get the desired output in one final array that will be used to fill a csv, eventually spreadsheet. My first msyql query and the resulting array give me this structure: array( [0] => Array ( [sku_id] => 1 [dealer_id] => 1976 [locations] => 1 [groupID] => 1 [frame] => 1051 [cover] => 1150 [color] => 99 [start_date] => 2018-03- ) [1] => Array ( [sku_id] => 1 [dealer_id] => 5400 [locations] => 1 [groupID] => 1 [frame] => 1051 [cover] => 1150 [color] => 99 [start_date] => 2017-04- ) [2] => Array ( [sku_id] => 1 [dealer_id] => 11316 [locations] => 1 [groupID] => 1 [frame] => 1051 [cover] => 1150 [color] => 99 [start_date] => 2017-02- ) ) So I get 3 records, each for the same product (sku_id) but a different customer(dealer_id). Then I match this data up in a similar table in DB2 to get quantity for each order of the sku_id. That 2nd query/array shows this: Array ( [0] => Array ( [CSTNOC] => 1976 [TOTALQTY] => 2 ) [1] => Array ( [CSTNOC] => 5400 [TOTALQTY] => 5 ) [2] => Array ( [CSTNOC] => 11316 [TOTALQTY] => 14 ) ) However, this is what I'm trying to achieve. In the below example, sku_id, groupID and location would come directly from the first query. Days is the number of days between start_date (from query 1) and curDate(). Qty is orqtyc from query 2 and Average is a calculation based on locations, days and qty. Each row is based on a different customer, so even though the below example is for one sku, the rows signify a different customer with different locations, qty, etc. SKU_id | groupID | locations (n) | Days (x) | Qty(q) | Average (x/(q/n)) -------------------------------------------------------------------------------- 123 1 3 120 15 24 123 1 2 12 6 4 The Report or CSV would then only show one line item for the above: SKU | Group | Average Days | Total units sold 123 | 1 | 28 | 21 Basically, for every sku I'm getting those records and then I need to do those calculations by row, and get a total of those values for each sku. The report will only have one line item per sku. I have everything I need to get there, but how can I structure a final array to get my desired outputs like above? FULL SCRIPT: $skuQuery = " SELECT sku_id, dealer_id, locations, s.sku_group_id as groupID, s.frame as frame, s.cover1 as cover, s.color1 as color, start_date - interval 7 day as start_date from products p inner join skus s on p.sku_id = s.id where curdate() between p.start_date and p.expire_date group by sku_id, dealer_id limit 3"; $skuRslt = mysqli_query($conn,$skuQuery); while($skuRow = mysqli_fetch_assoc($skuRslt)){ $skuResult[] = $skuRow; $dealerQuery = " SELECT cstnoc, sum(orqtyc) as TotalQTY from table where cstnoc = {$skuRow['dealer_id']} AND framec = {$skuRow['frame']} AND colr1c = {$skuRow['color']} AND covr1c = {$skuRow['cover']} AND extd2d >= " . str_replace('-', '', $skuRow['start_date']) . " group by cstnoc, framec "; $dealerRslt = odbc_exec($DB2Conn, $dealerQuery); foreach($skuResult as $skuRow){ while($dealerRow = odbc_fetch_array($dealerRslt)){ $dealerResult[] = $dealerRow; } } print_r($dealerResult); }
  22. I'm trying to alter a db2 query in my php script and it's not executing properly when doing so. In the last line of my WHERE clause for the DB2 select, I'm using this: AND date(substr(extd2d,1,4)||'-'||substr(EXTD2d,5,2)||'-'||substr(EXTD2d,7,2)) >= {$row['start_date']} but getting an error that >= is not a valid comparison operand. However, if I remove {$row['start_date']} and use current_date or current_date - 100 DAY, it works perfectly. To clarify, the value for 'start_date' in mysql is DATE data type and the value 'extd2d' in db2 is a packed field value that holds a date (20180202), so I'm converting it to try and match the YYYY-MM-DD format. Why can't I get this to work as it is? $sql = " SELECT sku_id, dealer_id, locations, s.sku_group_id as groupID, s.frame as frame, s.cover1 as cover, s.color1 as color, start_date - interval 7 day as start_date from placements p inner join skus s on p.sku_id = s.id where curdate() between p.start_date and p.expire_date group by sku_id, dealer_id limit 100"; $result = mysqli_query($conn,$sql); while($row = mysqli_fetch_assoc($result)) { $resultData[] = $row; $sql2 = " SELECT framec, covr1c, colr1c, date(substr(extd2d,1,4)||'-'||substr(EXTD2d,5,2)||'-'||substr(EXTD2d,7,2)) as start_date, sum(orqtyc) as TotalQTY from table1 where cstnoc = {$row['dealer_id']} AND framec = {$row['frame']} AND colr1c = {$row['color']} AND covr1c = {$row['cover']} AND date(substr(extd2d,1,4)||'-'||substr(EXTD2d,5,2)||'-'||substr(EXTD2d,7,2)) >= {$row['start_date']} /*This is the line in question*/ group by framec,covr1c,colr1c,extd2d "; $result2 = odbc_exec($DB2Conn, $sql2); while($row2 = odbc_fetch_array($result2)){ $db2Result[] = $row2; } } print_r($resultData); print_r($db2Result);
  23. jamesclues

    PHP Parse error: syntax error

    getting following error message [30-Mar-2018 17:14:34 UTC] PHP Parse error: syntax error, unexpected end of file in /home/hotels/public_html/3.php on line 122 . Spent 2 hours trying to make this work anyone got any ideas maybe i am just tired and not seeing what the problem is i have made sure all my connections are closed off. <!DOCTYPE HTML> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>Base Hotel - Standard Room</title> <link rel="stylesheet" href="system/css/global.css"> <link class="colour" rel="stylesheet" href="system/css/colour-blue.css"> <link class="pattern" rel="stylesheet" href="system/css/pattern-china.css"> <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css"> </head> <?php include 'header.php'; ?> <?php include 'conn.php'; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); //Query $sql = "SELECT * FROM Hotels WHERE hotelid = '1' LIMIT 1;"; $result = mysqli_query ($conn, $sql); while($row = mysqli_fetch_array($result)) { $string = $facilities; $delimiters = Array(","); $facilitiessplit = explode($delimiters,$string); //Whatever you want to do for each row... echo " <div id='container'> <header> <div id='header'> <div class='h1'> <h1><span> ".$row[hotelname]." </span> <span class='tagline'> ".$row[address]." </span></h1> </div> </div> </header> <!-- Header | END --> <!-- Content | START --> <main> <div class='centre'> <div id='left'> <!-- Slideshow | START --> <div id='slideshow'> <div class='slider'> <div class='item'><img alt='' src='".$row[hotelimg1]."' width='770' height='500' /></div> <div class='item'><img alt='' src='".$row[hotelimg2]."' width='770' height='500' /></div> <div class='item'><img alt='' src='".$row[hotelimg3]."' width='770' height='500' /></div> <div class='item'><img alt='' src='".$row[hotelimg4]."' width='770' height='500' /></div> <div class='item'><img alt='' src='".$row[hotelimg5]."' width='770' height='500' /></div> </div> <div class='nav'> <a class='prev'><i class='fa fa-chevron-left'></i></a> <a class='next'><i class='fa fa-chevron-right'></i></a> </div> </div> <!-- Slideshow | END --> <div id='content'> <div align='left'> <h2><strong>Welcome to </strong> ".$row[hotelname]."</h2> <p> ".$row[hoteldescrtiption]." </p> <ul class='tags'> echo '<li>'; print_r($facilitiessplit); echo '</li>'; </ul> </div> <a href='guest-book.html' class='button'><span data-hover='BOOK ONLINE'>BOOK ONLINE</span></a> </div> </div> } $conn->close(); ?> <!-- Sidebar | START --> <?php include 'sidebar.php'; ?> <!-- Sidebar | END --> </div> <!-- Google Map | START --> <script> function initialize() { var latlng = new google.maps.LatLng(-31.957482,115.856868); var myOptions = { zoom: 14, center: latlng, mapTypeId: google.maps.MapTypeId.ROADMAP, scrollwheel: false }; var map = new google.maps.Map(document.getElementById('googlemap'), myOptions); var marker = new google.maps.Marker({ position: latlng, map: map, icon: 'system/images/point.png' }); } function loadScript() { var script = document.createElement('script'); script.type = 'text/javascript'; script.src = 'https://maps.googleapis.com/maps/api/js&callback=initialize'; document.body.appendChild(script); } window.onload = loadScript; </script> <div id='map'> <div id='googlemap'></div> </div> <!-- Google Map | END --> </main> <?php include 'footer.php'; ?>
  24. Justafriend

    floor Sum and group

    $dbh = new PDO("mysql:host=$hostname;dbname=$db", $username, $password); foreach($dbh->query('SELECT PlayerName, floor(((SUM(PScoreAlt) + SUM(PscoreS)) /1000 )*3) + floor(((SUM(ScoreDiffAlt) + SUM(PdiffS)) /500)*2) + floor(SUM(PScoreReg /1500))*3 + floor(Sum(scoredifreg /1500))*2 + SUM(prereg) + SUM(st) + SUM(hb) + SUM(Sbonus) AS BB, floor(((SUM(PScoreAlt) + SUM(PscoreS)) /1000 )*3) + floor(((SUM(ScoreDiffAlt) + SUM(PdiffS)) /500)*2) + floor(SUM(PScoreReg /1500))*3 + floor(Sum(scoredifreg /1500))*2 + SUM(prereg) + SUM(st) + SUM(hb) + SUM(Sbonus) + SUM(Ballots) AS TB, SUM(Ballots) AS PB FROM spplayer Group by PlayerName ') as $row) { $total4 = $row['PB']; $total5 = $row['BB']; $total6 = $row['TB']; Ok from the above code is used to generate a total of ballots awarded based on the conditions Now the catch is if i add a group by and echo it the total doesn't match what is there now and i have figured out why BUT i need a way to get the totals to match, The flaw is if i use just this part for an example floor(((SUM(PScoreAlt) + SUM(PscoreS)) /1000 ) ​if the totals are jane 1100 the floor would be 1 joe 1400 the floor would be 1 sam 1500 the floor would be 1 moe 1300 the floor would be 1 ​but the issue is even though the total is 4 it is giving me a floor of 5 as the sum of the four totals is 5300 with a floor of 5 ​What i am trying to do is figure out a way of getting a correct total of all the people so it would be floor(1100/1000)+floor(1400/1000)+floor(1500/1000)+floor(1300/1000) any help would be greatly appreciated
  25. When I run this I am getting no errors and no data back please can someone tell me what i am doing wrong <?php include 'conn.php'; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); //Query $sql = $conn->prepare("SELECT hotelid, hotelname FROM Hotels WHERE hotelid = '1'"); $sql->execute() ; ?> <div id="container"> <header> <div id="header"> <div class="h1"> <?php while( $row = $sql->fetch()) : ?> <h1><span><?php echo $row['hotelname']; ?></span> <?php endwhile ?>
×

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.