database Archives - Page 5 of 14

[Solved] Convert SQL WHERE query to JOIN [closed]

November 30, 2022 by Kirat

For the most part, you just change your comma separated tables to JOIN clauses. The “ON” clause of the join is what comes from the WHERE clause SELECT DISTINCT r.recipe_id, r.recipe_name, r.recipe_image, r.recipe_duration, r.recipe_serving, r.recipe_difficulty, (SELECT category_name FROM tbl_category WHERE r.category_id = category_id) AS category_name, (SELECT cuisine_name FROM tbl_cuisine WHERE r.cuisine_id = cuisine_id) AS cuisine_name, … Read more

[Solved] How to convert sql query to LINQ query?

November 29, 2022 by Kirat

your SQL to LINQ look like this:- try this from po1 in PO join pu in POUnit on po1.POID equals pou.POID join s in Scope on pou.ScopeCodeID equals s.ScopeID join t in Timesheet on s.ScopeID equals t.ScopeID join pr in Projects on s.ProjectID equals pr.ProjectID where s.ProjectID = 1 group by s.ScopeID Select new { … Read more

[Solved] I would like someone to explain me how to find highest normal form of relation

November 28, 2022 by Kirat

Left side of FD must be candidate key OR right side must be at least part of it in order to satisfy 3NF. So, you have problem with c -> d because c is not candidate key and d is not part of it. 0 solved I would like someone to explain me how to … Read more

[Solved] Laravel: Create tables with variable in name

November 27, 2022 by Kirat

“Now i need a table for each user where i can store something like a CV.. Date begin, date end, City etc” Sounds like you need another table with a 1:1 relationship to the users table Your new table will look something like tblFurtherUserInfo FurtherUserInfoId CV DateBegin DateEnd City You should add a new row … Read more

[Solved] How can I access each value from an array?

November 26, 2022 by Kirat

Try using foreach loop. foreach($resultData2 as $resultData) { echo $resultData[’email’]; } solved How can I access each value from an array?

[Solved] How to store users transactions history on database and how to show the transaction history whenever a user wants to view their transactions

November 26, 2022 by Kirat

How to store users transactions history on database and how to show the transaction history whenever a user wants to view their transactions solved How to store users transactions history on database and how to show the transaction history whenever a user wants to view their transactions

[Solved] firebase recycler adapter showing null pointer exception

November 26, 2022 by Kirat

put your recycler adapter inside the onCreate method 0 solved firebase recycler adapter showing null pointer exception

[Solved] How to remove double quotes from an echo statement [closed]

November 25, 2022 by Kirat

//your double quotes come in this line: $values=”<option value=”” . $row[‘name’] . ‘”>”‘ . $row[‘name’] . ‘”</option>’; //change it to: $values=”<option value=”” . $row[‘name’] . ‘”>’ . $row[‘name’] . ‘</option>’; 0 solved How to remove double quotes from an echo statement [closed]

[Solved] Sorting query by importance, weight, and length

November 25, 2022 by Kirat

I find this problem rather challenging in MySQL. I can think of a few different approaches: union all variables window function (not available in MySQL prior to 8.0) subqueries in the order by clause None of these are trivial. Here is one solution: select t.* from ((select t.*, 1 as which from t where status=”important” … Read more

[Solved] Database model for car-service [closed]

November 24, 2022 by Kirat

Maybe a table like this one can help you model the price changes: create table service ( id int primary key not null, name varchar(50) ); create table car_type ( id int primary key not null, name varchar(50) ); create table location ( id int primary key not null, name varchar(50) ); create table service_price … Read more

[Solved] free host for database [closed]

November 24, 2022 by Kirat

Use an http tunnel like ngrok example: ngrok tcp 3306 it will expose your tcp port Forwarding tcp://0.tcp.ngrok.io:16922 -> localhost:3306 0 solved free host for database [closed]

[Solved] How to retrive data from database in the form of grid in ruby on rails

November 23, 2022 by Kirat

your “col-md-3” is missing “, and you have to put the column size inside the loop each, here is your revision that you can try <div class=”row”> <% unless @fridges.blank? %> <% @fridges.each do |fridge| %> <div class=”col-md-3″> <div class=”card card-cascade narrower”> <div class=”view overlay hm-white-slight”> <%= image_tag(fridge.image.url(:medium), :alt => “Fridge Item”, :class => “img-fluid”)%> … Read more

[Solved] MySql database structure for : Search based on single column and different value [closed]

November 23, 2022 by Kirat

try this: create table City ( Id int, Name varchar(50) ); insert into City (Id, Name) VALUES (1, ‘Toronto’), (2, ‘Chicago’) create table Libraries( Id int, Name varchar(50), CityId int ); insert into Libraries (Id, Name, CityId) VALUES (1, ‘Toronto Library 1’, 1), (2, ‘Toronto Library 2’, 1), (3, ‘Chicago Library 1’, 2), (4, ‘Chicago … Read more

[Solved] my query doesn’t work [closed]

November 23, 2022 by Kirat

You need to use your condition inside the if($query), but i dont think is there any need to recheck because you are already checking in Query WHERE username = $username. So i have modified your code as: Modified Code: $sql = “SELECT id, username, password FROM login WHERE username=”$username” LIMIT 1″; $query = mysqli_query($dbcon, $sql); … Read more

[Solved] How to store session id as foreign key in phpmyadmin

November 21, 2022 by Kirat

When using session, a random string is generated to identify a user – this string is called session ID. Session ID is stored in cookies. Cookies are sent to the web server with every request. On the server, session ID is then connected with session data. Attacker can’t change the session data, therefore, storing a … Read more