Is there a way to select all records where value = all or none, depending on the selected filter SQL? [closed]

So, I have a website where a user could display all tutors within the database. The user has a choice to select search filters, such as displaying tutors from Durbanville only, or displaying females only… So, the question is, Instead of writing code for each filter possibility, I would like to have one function which […]

How to execute shell scripts via PHP7 [closed]

The question is, i have used shell_exec() function in a php script but it runs once… the php-fpm do not run again due to disabled_functions issue reported in nginx error log. I tried exec() and passthru() and got the same problem. So, how to execute a shell script from PhP7 nowadays ?? BTW, the phpinfo() […]

Make the animation faster when there are thousands of components

I am trying to hide a JSplitPane with animation. By hide, I mean to setDividerLocation(0) so its left component is invisible (technically it is visible, but with zero width): public class SplitPaneTest { public static void main(String[] args) { SwingUtilities.invokeLater(() -> { JFrame frame = new JFrame(); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); frame.setLayout(new BorderLayout()); JPanel leftPanel = new JPanel(new […]

How to design database with post sharing with public, specific users or hide from specific users

I am new to database design, so please ignore if i am asking very simple, but i have searched a lot about this but didn’t found some helping material. So, the question is, I want to design a database which can support million of posts, the main functionality is, user can post anything, like text […]

Database Development

Optimal selection of predefined non-materialised data

Take the following result set as an example: Store Category Item Cost Stock Sold Ordered ABC Accessories Lock 344.31 281 141 225 DEF Components Chain 24.15 312 53 45 GHI Other Gloves 57.50 121 102 100 … We are looking to demo a feature for our application and this requires us to pull data in […]

Mastering Development

Post to Php file using Vanilla Javascript

I am posting to PHP file an OBJECT, the question is, I am not using name="" like when we do it inside the forms, but Instead, I am posting an Object, look: const done = async obj => { console.log("sending JSON to PHP…"); await fetch("myFile.php", { method: "post", headers: { ‘Content-Type’: ‘application/json’ }, body: JSON.stringify(obj) […]

Mastering Development

Architecture for an Local Web Application Hosted on an Embedded-System

I want to design a local web application that will be hosted on an embedded-system (orange-pi or raspberry-pi). The embedded-system will be connected to some sensor-devices through TCP-IP or RS485 and they should be poled in an infinite loop. The result should be updated graphically on the web page. I would like to use […]

Ask Chemistry

Do Cyclohexane-1,3-diones Give Positive Haloform Reactions?

Recently a post appeared on ChemSE asking why cyclohexane-1,3-dione (dihydroresorcinol) 1a doesn’t give a positive iodoform test. Unfortunately, the post was subsequently taken down after several comments. A paper by Fuson and Bull[1] reviewed the haloform reaction and stated that the iodoform test was negative for 1a. However, dihydroresorcinol undergoes the bromoform reaction[2] to yield […]

Protect php file in subdomain using account from main domain

I have problem like this I install WP on, then I have a single file located on called user.php where the folder position on file manager something like this so basically the wp files located on public_html folder, but my single file located on public_html/, the question is, is it possible […]

Mastering Development

SOAP Message stripping out XML Version

I am working on a SOAP Service where I need to send out a formatted error message with <?xml version=”1.0″ encoding=”UTF-8″?> at the top of outgoing message. Successful responses do not have this version text at the top of the response. The reason I am doing this is because we are taking over the provision […]