Month: September 2022

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

by

[ad_1] 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) … Read more

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

by

[ad_1] 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 … Read more

[Solved] How to retain previous graphics in paint event?

by

[ad_1] The simplest way is for you to create an ordered collection of objects (a List<> for example) which you would redraw each time that the OnPaint event is called. Something like: // Your painting class. Only contains X and Y but could easily be expanded // to contain color and size info as well … Read more

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

by

[ad_1] 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 [ad_2] solved PHP: INSERT array to table with a timer or clock (per … Read more

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

by

[ad_1] 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

[ad_1] 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 … Read more

[Solved] Display Username in Index page

by

[ad_1] 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 … Read more

[Solved] Javascript compare two text fields

by

[ad_1] 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. … Read more

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

by

[ad_1] 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”, … Read more

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

by

[ad_1] 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, … Read more

[Solved] Writing a function in laravel

by

[ad_1] 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(); … Read more