Kirat

[Solved] Storing JSON Array of Arrays in PostgreSql

by

[ad_1] First statement returns two rows, one for each array. select jsonb_array_elements(msg->’root’) as el from js Then returns each individual values as text. with aa as ( select jsonb_array_elements(msg->’root’) as el from js ) select jsonb_array_elements(el)->>’cid’ as cid, jsonb_array_elements(el)->>’Display’ as Display, jsonb_array_elements(el)->>’FName’ as FName, jsonb_array_elements(el)->>’LName’ as LName from aa; This returns 3rd element of 2nd … Read more

[Solved] PHP nested array into HTML list

by

[ad_1] What you are looking for is called Recursion. Below is a recursive function that calls itself if the value of the array key is also an array. function printArrayList($array) { echo “<ul>”; foreach($array as $k => $v) { if (is_array($v)) { echo “<li>” . $k . “</li>”; printArrayList($v); continue; } echo “<li>” . $v … Read more

[Solved] Problem with pushing into stack with generic type [closed]

by

[ad_1] Your question misses important details and actually I shouldnt be writing this answer, but as you actually also didnt ask a question, I just do it. This error message: error: no matching function for call to ‘AlgoStack<State<std::pair<int, int>* >>::push(State<std::pair<int, int> >*&)’ tells us that there is an instantiation of AlgoStack with the template parameter … Read more

[Solved] How to use recursion to reverse text? [closed]

by

[ad_1] Normally with recursion you’d have a function that calls itself. You don’t need recursion to reverse a string, but I suppose you could have a function that takes a string, and appends the first character of the string to the reverse of the rest. I’ll try to explain how this works without giving too … Read more

[Solved] why are the top five color red red red red red?

by

[ad_1] You are accidentally changing the entire dictionary instead of the specific alien you want the dictionary to represent. For now, just add .copy() to each time you append an alien dictionary to your random list of aliens. if color[random_num] == ‘green’: aliens_1.append(alien_0.copy()) In the future, this is probably best handled with classes rather than … Read more

[Solved] How to Vertical align text in div

by

[ad_1] I have 2 solutions: 1- Use display:table-cell; vertical-align: middle 2- Use position:absolute; transform:translateY(-50%);top:50% .relative{position:relative;height:300px} .middle{position:absolute;top:50%;transform:translateY(-50%)} <div class=”relative”> <div class=”middle”> <h1>Middle</h1> </div> </div> [ad_2] solved How to Vertical align text in div

[Solved] Why this result in PHP?

by

[ad_1] First of all, echo is not a function, it is a language construct and it does not actually “return” anything. echo is for outputting strings. The reason it outputs (not returns) 1 instead of true is because true is not a string, it is a boolean value and therefore when it is typecast to … Read more

[Solved] I can’t view the database content on a php page [closed]

by

[ad_1] I have made an example how it could look with PDO (as i see you are just starting and i suggest to learn PDO as its not that hard) This way you also are safe from SQL injections. $host=”127.0.0.1″; $db = ‘test’; $user=”root”; $pass=””; $charset=”utf8mb4″; $usid = 0; $docname=””; $dsn = “mysql:host=$host;dbname=$db;charset=$charset”; $options = … Read more

[Solved] Accessing controls from different forms

by

[ad_1] Looking at the original code, there are two potential reasons for the NullReferenceException you are getting. First, tb is not defined in the code you provide so I am not sure what that is. Secondly, TextBox textbox = form.Controls[“textboxMain”] as TextBox can return null if the control is not found or is not a … Read more

[Solved] Python Code that returns true while key is pressed down false if release?

by

[ad_1] On some systems keyboard can repeate sending key event when it is pressed so with pynput you would need only this (for key ‘a’) from pynput.keyboard import Listener, KeyCode def get_pressed(event): #print(‘pressed:’, event) if event == KeyCode.from_char(‘a’): print(“hold pressed: a”) with Listener(on_press=get_pressed) as listener: listener.join() But sometimes repeating doesn’t work or it need long … Read more

[Solved] dynamic rectangular or square div of any size which can be fitted into a fixed size div [closed]

by

[ad_1] It’s all about ratio. You need to calculate the ratio between the rectange width & frame width. Sample code here.. function renderBox() { const width = document.getElementById(‘width’).value; const height = document.getElementById(‘height’).value; const box = document.getElementById(‘box’); let scale = 1; while(true) { if (width <= (400 * scale) && height <= (200 * scale)) { … Read more