Tag: mysql

Laravel ORM is giving an incorrect result on a simple query

I really don’t get it, help me understand. I’m writing an app which among other things calculates a NFL team “mark” (a mark is Win/Lose/Tie, sorry I don’t know the word in English for that), so I have a “Marca” attribute in the Team model, looks like this: Queries are…

Mysql where clause on multiple fields which one might be null

eloquent laravel mysql php

In my products table, I have 2 columns: price and discounted_price in which discounted_price is null most of the time unless there is a promotion for that product: +—-+——————–+——-+–…

Replace value in array with result of mysqli_query

mysql php

I’m having some trouble with php coding. What I want to do is following: Create an array ($rows) and fil it with the results of a mysqli_query ($query1) –> OK for each element in that array, replace the value of a certain key (pilot_rule_id) with the result of another mysqli_query ($query2). (t…

One particular id at first and after all ids in desc order

cakephp-3.0 mysql php

I need to get one particular id at first and, after that, all ids in descending order. This is what I have done but when I uncomment that order line it won’t work, Answer Just replace this line with your order by condition

How to check two rows from table that the value of them are not repeated at other rows

mysql php

Let’s say I have a table called services: And I made a form for updating this table:

How to make custom field text stored in database a link in wordpress frontend [closed]

mysql php wordpress

I am using a WordPress Form Plugin to store data. There’s this text field which I’m using to store links such as http://example.com. I want to make the links clickable and where possible change it …

Reorder chat tabs so tabs with newest received or sent messages are on top of list

mysql php sql sql-order-by subquery

I’m working on a simple messenger. This is how the Chat table looks like: This is how the User table looks like: This is how the PinnedUser table looks like: By using this query I can display …

PHP read from file line by line, declare as variable, then use in MySQL query as WHERE column_name equals variable

mysql php

Good day, My aim with the script (overview) is to let PHP read from text file line by line then declare the line as variable that will be used in a MySQL statement as a where clause into an array, …

checking mysql error code to prevent deleting a parent key to a foreign key to alert user

mysql php

I have a table named magazine, there is a foreign key from a table called researcher. I need to alert the user when they delete a researcher who has a magazine. I did that by using the mysql error code. this is my code. P.S: the variable $conn is from the php file that connects with the database Answer You

Trying to access array offset on value of type null…in login details

css html javascript mysql php

if ($row[’email’] == $email && $row[‘password’] == $password) { echo “Login success Welcome”.$row[‘username’]; # code… } else{ echo “failed to login”; }