39,388 Topics
 | |
| | I have two dates like $date1 ="2016-05-01"; $date2 ="2016-05-31"; how to get saturday and sunday count like between range is 9  |
| | Below is my code function getWorkingDays($startDate, $endDate){ $begin=strtotime($startDate); $end=strtotime($endDate); if($begin>$end){ echo "startdate is in the future! <br />"; return 0; }else{ $no_days=0; $weekends=0; while($begin<=$end){ $no_days++; $what_day=date("N",$begin); if($what_day>5) { $weekends++; }; $begin+=86400; }; $working_days=$no_days-$weekends; return $working_days; } } $beginday=date("2016-04-01"); $lastday=date("2016-06-30"); $nr_work_days = getWorkingDays($beginday,$lastday); echo $nr_work_days; ?> above code is giving count … |
 | $city = "Amersfoort"; if ($stmt = $mysqli->prepare("SELECT District FROM City WHERE Name=?")) { $stmt->bind_param("s", $city); $stmt->execute(); $stmt->bind_result($district); $stmt->fetch(); printf("%s is in district %s\n", $city, $district); $stmt->close(); } This brings many questions: - What is `s` on the line 4? Do I need to bother with that? - What if I … |
| | hi, all i am new in php developing i need to know how i could make a user data hidden or inactive to the viewer of my website without deleting this user data from my database can i do that using php code? if yes what is this coding criteria … |
| | Hello guys. I am currently developing a Case Management System with a versioning function. The versioning function will allow top management to see the different versions of a document and the different changes that were made by either the lawyer or top management. My problem is, how would I start … |
| | Hi, In an excel file, I have 10 headings and that file contains more than 6000 records. I upload file using oleread.inc and excelreader file. It takes time to upload recods in table minimum 4 - 6 minutes. How to decrease the time and insert records in table fastly. |
| | I'm getting two errors detailed below: Notice: Undefined index: username in C:\wamp\www\member.php on line 8 Call Stack # Time Memory Function Location 1 0.0006 131808 {main}( ) ...\member.php:0 ( ! ) Notice: Undefined index: passwd in C:\wamp\www\member.php on line 9 Call Stack # Time Memory Function Location 1 0.0006 131808 … |
| | I have this code session_start(); $username = $_SESSION['username']; function getUserRole($username, $roleid){ $con=dbConnect(); $query="select * from user inner join userrole on user.id = userrole.userid inner join role on role.id = userrole.roleid where username = $username"; $sql=$con->prepare($query); $sql->bindValue(':username',$username); $sql->bindValue(':roleid',$roleid); $sql->execute(); $row = $sql->fetch(); $username = $row['username']; $roleid = $row['roleid']; if($row > 0){ … |
| | I think this is called "foreign key" and "local key" ? I have a table `users`, these users have `rank`. It's an `int`. There is a table named `rank`, this table has field where hexadecimal string is placed `FF0000`. Is there a way to `SELECT * FROM users` and `SELECT … |
| | Hey everyone, I have a question about a database design that I have right now. The template I was given from someone is the first attached that you will see. I looked at it and figured that the database design of that is not the best, so I decided to … |
| | TAXONOMY MENU SUB CATEGORY CREATION: Problem: I'm trying to create and display menus in the below format using taxonomy(category,subcategory).I have also created Views to fetch the taxonomy values. (See attached taxonomy.png) Menu1 -- > Menu2 ---> Menu3 Menu4 Menu5 Menu 6 Now when executed, I'm not getting the correct format … |
| | Hi all, Submitting forms to PHP is easy with Ajax. But what if I wanted to design my website to allow for JS-free web browsers? If I call a PHP file with Ajax, I might get an error message in return to dynamically add to the page, but if I … |
| | Hi, I have a page for sending SMS by selecting anyone organization, By selecting organization, it will calculate how many customers are there to send SMS, It will display the SMS Count along with all managers names using JQUERY AJAX. For counting this value,it takes so much time in online, … |
 | Sir, please help me to locate the error, if user not found or wrong user name password etc then all codes work fine but when I enter correct user name and password then no result. <?php session_start(); require_once("includes/connect.php"); require_once("includes/functions.php"); if(isset($_POST['login'])) { $muser=clean($_POST['username']); $mpass=clean($_POST['password']); if(empty($muser)) { echo ('<script type="text/javascript">alert("User name must …  |
| | I have multidimensional array that include department and category. Based on the selecting department and category, i need to search names. below is my code $shop = array( array( "emp_name" => "ramu", "department_name" => "cse", "Number" => 15 ), array( "emp_name" => "ramesh", "department_name" => "eee", "Number" => "56", ), … |
| | Hi guys I was hoping you could help I would like to add 10000 records in mysql db.All once with after running a single php script. in one of the fields should generate 10000 rand generated numbers. Any suggests would really help. I was thinking of a for loop. [CODE] …  |
| | any body help me to convert php multi dimensional array to php multi dimensional array format $data = array( array( "emp_name" => "ramu", "department_name" => "cse", "Number" => 15 ), array( "emp_name" => "ramesh", "department_name" => "eee", "Number" => "56", ), array( "emp_name" => "ravi", "department_name" => "it", "Number" => … |
| | Hey everyone, I have a question. I have a web app where you have a table that will either update, delete, or add a user. The update works great but the delete is weird. It deletes just fine, but I ask for a confirmation first before the action is completed. … |
| | Dear Experts, I have following codes while($res = mysqli_fetch_array($result)) { echo "<tr onMouseOver=this.className='highlight' onMouseOut=this.className='normal'>"; echo "<td align='center' width='10%' >".$res['code']."</td>"; echo "<td align='left' width='50%' >".$res['products']."</td>"; echo "<td align='center' width='20%'>".$res['weight']."</td>"; echo "<td align='center' width='20%' ><a href=\"master_u.php?id=$res[id]\"><img src=images/pencil.png alt=Edit title=Edit></a> <a href=\"delete.php?id=$res[id]\" onClick=\"return confirm('Are you sure you want to delete?')\"><img src=images/delete16.png alt=Delete title=Delete></a></td></tr>"; …  |
| | I know this is very basic but i am not able to get the fuction return a string. Instead it is returning the value 1. Below is the code: <?php function getUserRole($username, $roleid){ include "data.php"; $con=dbConnect(); $query="select * from user inner join userrole on user.id = userrole.userid inner join role … |
| | i have a wcf service running, the problem am facing is how do i use the wcf to connect to the client and generate reports. if am no a wrong path please help thank |
| | My code here suppose to grab list of injection string from table:* injection_text*, column: *injection_code* and inject it at the tail of the URL's crawled by my program, the URL's crawled are stored table: *pages_crawl*. my program suppose to display the result of the injection. the purpose of this program … |
| | Hey everyone, I have a question. I created a page that pop-ups when a user clicks a link and that page displays a table of the information that it pulls from the database that I have created. I want to be able to have a user click an update button … |
| | Hi, I have many records in my table minimum 3000k records. When I select SMS Page , it has two ajax pages, for calculation, So, the SMS Page is taking so much time to complete the task. I want to reduce the time of this page without affecting anywhere. How … |
| | Hi I am trying to do the same thing. I would like to save the Facebook user timeline details OR messages in MySQL database. Timeline details are visible in screen total posts are like this http://screenshot.co/#!/2dcbee03ff , if I want to see the 'messages' only I can see in the … |
| | Hi I have a php application which runs on an IIS Server and I want to create/append a file on an other server or PC Can I do it if I use fopen and I create a folder on that other server or PC which I grant write access to … |
| | Sir I have follwing data var1= '5,487,256.36 ' var2= '245,868.48 ' How to get this sum with Js or with any other method. Basically I want to use it with PHP. var3= '5,733,124.84' Please |
| | Hey everyone, I am trying to use JQuery to help me load a page on my page so that the user does not have to refresh or move to a new page. So far, I have the code so that the next page's contents will display, but the update button … |
| | I am trying to create a table in html/php that is dynamic sized but allows users to edit rows of the table, I have 99% of this done and the last piece is to send edited values VIA ajax to an edit page where I update to the database and … |
| | Hi, i recently created a bit of script to pull images from a database and display them horizontally using a scroll bar. i have now decided to try and integrate it with jquery to give it a bit of life. At first, i use the jquery plugin to use 5 … |
The End.