Month: September 2022

[Solved] what will be the sql query code of this “Healthcare” database?

by

Update your 3rd query to – SELECT Patient.Name, Patient.age from Patient where patient.age < ’50’ and EXISTS ( SELECT Prescription.DoctorID from Prescription where Patient.Primary_DoctorID = Prescription.DoctorID and Prescription.P_ID = ( select Prescription_Medicine.P_ID FROM Prescription_Medicine where Prescription_Medicine.Tradename=”Vitamin” ) ); And update your 4th query to – SELECT dname FROM doctor d JOIN (SELECT speciality, MAX(doctor.experience) FROM … Read more

[Solved] json.Unmarshal interface pointer with later type assertion

by

An empty interface isn’t an actual type, it’s basically something that matches anything. As stated in the comments, a pointer to an empty interface doesn’t really make sense as a pointer already matches an empty interface since everything matches an empty interface. To make your code work, you should remove the interface wrapper around your … Read more

[Solved] PHP: INSERT array to table with a timer or clock (per second)

by

With javascript setInterval() method calls a function at specified intervals (in milliseconds). var pause = setInterval(function(){ insert data }, 2000); // 2 sec To stop the time use clearInterval(pause) by referencing the variable. To execute the function once use setTimeout() 0 solved PHP: INSERT array to table with a timer or clock (per second)

[Solved] Replacing a range between two iterators in C++

by

Using std::copy(), it can be done like this: #include <iostream> #include <vector> #include <algorithm> void printVector(const std::vector<int>& v) { bool first = true; std::cout << ‘{‘; for (int i : v) { if (!first) std::cout << “, “; std::cout << i; first = false; } std::cout << “}\n”; } int main(void) { std::vector<int> v1 = … Read more

[Solved] How can I convert an excel file into CSV with batch skipping some rows?

by

A very easy way, is to create a vbs script. Paste the below into a notepad and save as XlsToCsv.vbs. Make sure you give the full path of sourcexlsFile and also destinationcsvfile To use: XlsToCsv.vbs [sourcexlsFile].xls [destinationcsvfile].csv if WScript.Arguments.Count < 2 Then WScript.Echo “Error! Please specify the source path and the destination. Usage: XlsToCsv SourcePath.xls … Read more

[Solved] Display Username in Index page

by

CheckLogin.php if ( $count == 1 ) { $_SESSION[‘login_id’] = $row[‘id’]; $_SESSION[‘username’] = $row[‘username’]; // added if ( $_SESSION[‘login_id’] != ” || $_SESSION[‘login_id’] > 0 ) { // edited header(“location: index.php”); } else { header(“location: login3.html”); } } Index.php <?php require_once ‘UserSessionAdmin.php’; // edited $username = $_SESSION[‘username’]; // added ?> <!DOCTYPE html PUBLIC “-//W3C//DTD XHTML … Read more

[Solved] Javascript compare two text fields

by

Some issues with your code: You only had an event listener on the first input. You’ll need to add an event listener to the second input as well. The value on keydown won’t contain the same value as on keyup. You’ll need to do keyup to keep up with user input. Working fiddle here. document.getElementById(“text1”).addEventListener(“keyup”, … Read more

[Solved] function for Phone number to words in java for multiple digits [closed]

by

Call numToWords with your number. Otherwise if you already have a string just pass it and skip the String.valueOf(number) calling directly the split private static final HashMap<String, String> mapping; static { mapping = new HashMap<>(); mapping.put(“0”, “Zero”); mapping.put(“1”, “One”); mapping.put(“2”, “Two”); mapping.put(“3”, “Three”); mapping.put(“4”, “Four”); mapping.put(“5”, “Five”); mapping.put(“6”, “Six”); mapping.put(“7”, “Seven”); mapping.put(“8”, “Eight”); mapping.put(“9”, “Nine”); … Read more

[Solved] How do I make a custom discord bot @ someone that a person @ed in the command?

by

To mention a user you have to define it beforehand. You do this as follows: user = message.mentions[0] To mention the user you can either use f-strings or format. Based on the code above here is an example: @client.event # Or whatever you use async def on_message(message): user = message.mentions[0] if message.content.startswith(‘!best’): await message.channel.send(“Hello, {}”.format(user.mention)) … Read more

[Solved] Writing a function in laravel

by

You’re really missing out on the best parts of Laravel’s query builder. public function jobsearch(Request $request) { // htmlspecialchars makes no sense here $keyword = $request->input(‘keyword’); $city_id = $request->input(‘city_id’); $category_id = $request->input(‘category_id’); $query = DB::table(‘job_details’); if($keyword) { $query->where(‘job_title’, ‘like’, ‘%’.$keyword.’%’); } if($city_id) { $query->where(‘city_id’, $city_id); } if($category_id) { $query->where(‘category_id’, $category_id); } $results = $query->get(); foreach($data … Read more