53 Solved Topics
Remove Filter  | Hi all, Say I have a table called "posts" with thousands of records. For each user, I want to display the top 10 most recent posts. I would normally use: `select * from posts order by created_date desc limit 10` However, doesn't this select ALL records and then removes all …  |
| | Hi all, I have a text box. When users press enter, it triggers the submit function: commentContent.keydown(function(e){ if(commentContent.is(":focus") && (e.keyCode || e.which) == 13 && !e.shiftKey) { e.preventDefault(); commentForm.submit(); } }); This then prepends the content of the text box into the HTML. `commentsHere.prepend(commentData);` However, when I search for this … |
| | Hi all, I've been trying to create a friendly time function for a while, it's purpose should be quite obiovus from the code below. Currently, it outputs "expired" for everything. I am so utterly confused from visualising the code and trying to figure out where the times lie in relation … |
| | Hi all, In PHP just wondering if anyone knows whether one method of creating multiple indexes within an array is more efficient / preferable to another? ` $listing['one'] = $x; $listing['two'] = $y; $listing['three'] = $z; ` or: $listing = [ ['one'] => $x, ['two'] => $y, ['three'] => $z … |
| | Hi all, Something disturbing is happening... I make an AJAX call to a page and it returns unprocessed PHP, not HTML. However, when I navigate to the page manually, the PHP is processing as expected. This must be a huge security vulnerability? My AJAX call is: $('#forgot').click(function(e){ e.preventDefault(); lFormContainer.load("ajax/?page=authenticate/username"); }); … |
| | Hi all, I'm running into a problem with PHP and mysql. I run a mySQL query, which returns the following object: `mysqli_result Object ( [current_field] => 0 [field_count] => 2 [lengths] => Array ( [0] => 1 [1] => 186 ) [num_rows] => 1 [type] => 0 )` I then …  |
| | Hi all, I am running a mySQL database on a webserver hosting multiple Wordpress installations. It seems that database is getting swamped with memory and going into a continual loop of shutting down and restarting. A reboot fixes the issue temporarily, but I have no idea what I can do … |
| | A theoretical question about connecting to hidden services through PHP. Say I am writing an application on the clearnet that relies on data stored within a mySQL database that is hosted on a hidden Tor service. How would I initiate this connection? Some brief research has pointed me towards the …  |
| | Hi all, I just have a question about how PHP works. Say I have several classes that I call but don't `unset()` once I've finished with them, how long will the server hang onto that data. Is it completely dependant on the client connection to the server? Similarly, I understand …  |
| | Hi all, just a quick question. I believed that `$('#value')` was a jQuery function equivalent to `document.getElementById('value')` however, in the code below, only the second function gives the desired result. Can someone explain why this is? $('#value').value = "1"; document.getElementById("value").value = "1";  |
| | I'm having some real trouble running some basic queries that I should be able to run easily. I have a table called settings. When I query `SELECT * FROM settings` I get the output: +----+-----------------+--------------------------------+ | ID | key | value | +----+-----------------+--------------------------------+ | 1 | view | default | … |
| | Hi all, I'm having some serious issues with AJAX forms. I'm currently using jQuery 2.2.0 and the jQuery Form plugin. I have a simple php file: <?php if(isset($_POST)): print_r(json_encode($_POST)); endif; ?> I have a simple html form: <form method="post" id="regform"> <input id="login_name" name="login_name" type="text" > <input id="login_password" name="login_password" type="text" > … |
| | Hi all, I have two square <div> containers one under the other. When I click a button, I would like the second <div> to fade on top. Because the top <div> is transparent, the bottom <div> needs to be hidden first. I have given the second div a Z-index of … |
| | hi all, I am trying to make an array that looks like this: Array ( [status] => [MERGE0] => removed@email.address [merge_fields] => Array ( [MERGE1] => James [MERGE2] => doe ) ) In my code, there is an undefined number of [merge_fields], so I am using the code below to … |
| | Hi all, I am aiming to create an array with the same structure as this: Array ( [798D25C0DEABD] => Array ( [quantity] => 1 ) [40B2B0FA3D222] => Array ( [quantity] => 1 ) ) The code I am using is therefore: for($i = 0; $i < count($response); $i++) { $ph[] … |
| | hi all, I have been coding a payment gateway using a company called SwipeHQ. Using their APIs I have programatically created products from my website and make sure they stay updated. However, I'm now completely stuck about how to have my checkout navigate to their payment form and then return … |
| | Hi all, I have a fairly limited understanding of how objects work exactly, but basically I have: `$response[] = $html->data->identifier;` Which I would think stored the values as an array, but when I try to add something to that array with: `$response[] = array('quantity' => $itemsinfo['qty']);` I get the error …  |
| | Hi all, my understanding was that Nginx doesn't do any caching unless you tell it to. However, for some reason, all my filles are being cached, and so the website doesn't respond to change in css or js files etc. I thought that the below server{} code would help: location … |
| | Hi all, Brand new to nginx, but it seems to be the rising star, and suited to hosting high volumes like I'm doing. However, I'm having trouble setting up the config files. A day of google searching hasn't really helped. My nginx.conf looks like: events { worker_connections 768; # multi_accept … |
| | Hi all, I have a HTML video within a div that is 100% width of the page. I want the video fill the container and crop the height to fit. But so far I cannot get the video to expand at all! I'm simply using: .video { width:100%; } and … |
| | Hi all, I'm very very new when it comes to JavaScript, but I understand it's what I need to solve my problem. Basically, I have a PHP script that takes a while to process (several minutes). This script is linked from my homepage and when the script finishes it redirects … |
| | Always get really confused when dealing with timezones... I have a string `8/11/2013`, which I apply the following code: $firstDate = new DateTime($rawData[$backdate][0]); $firstDate = $firstDate->format('d/m/Y'); The issue is that PHP seems to think that the '11' is the day, when it's actually the month (I'm in NZ). When I … |
| | Hi all, quite a strange problem here. I have a csv file with rows: 20/12/2011 4.75 4.75 4.53 4.55 94.74 432.98 4.57 21/12/2011 4.38 4.38 4.38 4.38 20.9 91.54 4.38 22/12/2011 4.19 4.19 4.17 4.17 8.54 35.71 4.18 23/12/2011 3.86 4.35 3.84 4.22 149.49 625.81 4.19 24/12/2011 4.33 4.33 4.33 … |
| | Hi all, I'm working with a function that only accepts values between 0 and 1, so I need to scale my data first. The first part involved in this is calculating the high/low values of my inputs. I pass this into a function that churns out X and Y values … |
| | Hi all, For some reason, a white edge has appeared down the side of my website. It was never there before. The web suggested I should make sure to reset margins etc to 0 at the top of my stylesheet, which I already do. The edge is not due to … |
| | Hi all, I've been trying to follow the basic Apple developer tutorial, where you create a food tracker app. I can not get one part of the code to work, and I can't see why. Not only is it exactly the same as in the example, but searches online also … |
| | Hi all, I have a multidimensional array [0]:[0], [1], [2], [3] and I want to try and find the min and max values of each index of that array over the whole array. I am using: for ($i = 0; $i < count($input); $i++) { $string1[] = $input[$i][1]; $string2[] = … |
| | Here's a fun one... How would you solve a basic simultanous equation with PHP? I have an array with a range [high,low] of [378,395] and I want to normalise the data in that array between the values of [-1, 1]. From that, using `x => ax + b`you get the … |
| | Hi all, I am using a for statement to generate lots of arrays, example: Array ( [0] => 2 [1] => 395.0 [2] => 0.33 ) Array ( [0] => 3 [1] => 394.0 [2] => 0.81 ) But, I want to have them all within 1 array, example: Array … |
| | Hi all, I am able to pull data from a CSV file into a string array using the following code. public static string[,] ReadCSV(string filename) { //Read Text string whole_file = System.IO.File.ReadAllText(filename); //Split into Lines whole_file = whole_file.Replace('\n', '\r'); string[] lines = whole_file.Split(new char[] { '\r' }, StringSplitOptions.RemoveEmptyEntries); //Calucluate Rows …  |
| | I am using a mySQL query in PHP to pull content from rows into an array. A simple for statement is then displaying this data: for ($i = 0; $i < ($num_rows); $i++): //Find Author Name $query = 'SELECT firstname, lastname FROM vd_users WHERE id = ?'; $statement = $mySQL_con->prepare($query); … |
| | Hi there, I'm still fairly new to programming. Would someone be able to explain exactly how different windows should be used in MS Visual Studio? It seems that variable sharing between different windows is problematic. So does that mean that if you are trying to do multiple things on one … |
| | Hi all, I have a multi-dimensional array. Using a **for** function, I would like to display the information inside the array. This means using a variable $i for the first index of the array, which I think is causing the problem. I am getting the error message: `Undefined offset: 2` … |
| | Hi there, I am trying to populate a page with multiple rows from a mySQL database. To grab the data, I am using: for ($i=1; $i < 5; $i++) { $query = 'SELECT * FROM table WHERE column = ?'; $statement = $mySQL_con->prepare($query); try { $statement->execute(array($i)); } catch (PDOException $error) … |
| | Hi there, As an excerise I am trying to create a basic PHP blog. Creating the user login system was pretty straightforward, and I've 2 mySQL tables, one with user information, and one with the blog information (and with a foreign key referencing the user id). However, I'm stuck for … |
| | Hi there, I created a new table and forgot to set the primary key with an auto_increment. I went back and use: `ALTER TABLE table ADD PRIMARY KEY AUTO_INCREMENT (column);` However, now whenever I try to insert a new row of data, I get the error message "Duplicate entry '0' … |
| | Hey guys, Using PHP I store a datetime in a mySQL table. I am trying to draw that out and reformat the time. The datetime is contained within the array $user_data['6'] and the format in the mySQL table is set to datetime. The error I'm getting is Call to a … |
| | Hi all, I am using the PHP Facebook SDK to login users. A login button validates the user and returns to a callback 'fb-callback.php'. On this page, I dump the returned data into a mySQL table, start a Session, and redirect to the homepage. As a test, I stopped the … |
| | Hi guys, I can't get passed this error: Call to a member function bind_param() on a non-object. I have spent hours looking for insights, and can see that my $statement returns FALSE, but have no idea why? My understanding of PHP is limited, so it might help if I actually … |
| | Does anyone know if it's possible to intercept the button presses off a presentation remote, just like we are able to listen for keyboard strokes? In this case, the buttons on the remote don't appear to be linked to a keyboard button. |
| | Hi there, I have two WPF windows. The first (Window1) has a timer that moves an item down a list, then passes the new current selection to a global variable I defined in App.xaml.cs Window 2 then has another timer that is set to .1 of a second after the … |
| | Could someone please explain to me the purpose or reasons for using Dispatcher.Invoke? I am getting the error: *The calling thread cannot access this object because a different thread owns it. * and a quick Google search suggested that was due to not using Dispatcher.Invoke (they also said it was …  |
| | Hi there, I've created a new C# WPF project. The first MainWindow displays a listbox of images within a folder and displays them inside a larger image object. I am trying to get Window1 to open a fullscreen version of the selected image, that changes depending on what image is … |
| | Hi there, trying to do something I thought was pretty basic, but can't get around this error. I have a ListBox, List (AllImages) full of image paths, and two image elements. Image 1 displays the selected item, Image 2 displays selected item + 1 I have: `int inx = Convert.ToString(ImageList.SelectedIndex);` … |
| | Hi all, I'm very new to software development. My main area is HTML/PHP/JavaScript, but have done a bit of C# before. I don't believe the idea I have is suited for a web development option, so am looking for ideas / a starting point for a solution to the below … |
| | Hi all, I'm quite a new developer, and I've spent a long time trying to figure out what is causing this error: "SQLSTATE[HY093]: Invalid parameter number: parameter was not defined" As far as I can tell, all my parameters are defined? My code is below: $mySQL_query = "INSERT INTO vd_users … |
| | Hi Guys, As part of an online store, I have a dropdown box where the user selects a size. If the user selects size L then the 'add to cart' button needs to link to a page different than if the user selected size M. I figured out that I … |
| | Hi there, My PHP is appalling/non-existant. I have a HTML website with a PHP header that I've 'included' on all the pages. The problem is that this header colours red whichever page we are currently on, defined under the CSS as being 'active'. Therefore, from what I see, I need … |
| | Hi there, I have a webpage in HTML, strong-links.org, and am tired of having to make changes to every single page when I update the header or footer, and someone suggested I can use PHP to reference the template within the HTML pages. As a test, I have test.strong-links.org/index2.html live … |
| | Hi all, I am trying to populate text on my website from data stored in a MySQL database. I have this script before the <head> of my HTML to establish the connection: <?php $username = "USERNAME"; $password = "PASSWORD"; $hostname = "127.0.0.1:3306"; //connection to the database $dbhandle = mysql_connect($hostname, $username, …  |
The End.