I’m trying to take some results from a query that I do to Oracle and paste them on a CSV file, the problem is that, in the foreach loop, the code should writes line by line, but he writes only the …
Tag: php
How do i group the time in and time out according to the employee number and date [closed]
attendence sql file[ ][2] I try to get attendance table data (which include the emp_no ,date ,time).i want insert the above table date as emp_no,date,time in and time out.time logic is show in below. …
Sql select from a table but use another table value as where clause [closed]
How can I select * from table posts but using table network_follow.follower as where condition? I have table posts, column by_user and table network_follow column follower I don’t know if that’s …
To retrieve data from SQL table fields with different IDs into corresponding different variables
The sql database table named ‘data’ has the fields ‘date’, ‘project_id’ and ‘amount’. I am able to retrieve the total amount spent on a single project with the code below: $sql = “SELECT sum(data….
How to secure save user login for long term access
I create a PHP/MySQL application that will be used to log in to the user with a username and password, but I need the user login to the system to survive even turning off the browser or restarting the …
Math calculation laravel (netto-brutto)
I have code: But I have also another field Rechnung preis – Netto. What must be the code for calculate netto-brutto from bedrag_rechnung_brutto. It must be -19%. Netto = brutto /1,19. Answer What is your question over here? You already answered it yourself?
On signup form INSERT -> update corresponding values in another table
From usersTable there are userRoles. — Teacher, Mentor, Student. When a user submits signup form, they are either one of the three. I also have three more tables, — teacherTable, mentorTable, …
PDO union select results nothing
I need to select name, surname from users where username = column following inside network_follow table the query: “SELECT * FROM network_follow WHERE following = :f UNION SELECT name, surname FROM …
How to insert NULL into decimal type column using PHP?
I’m trying to insert NULL into a column, called price, which is of type Decimal. The column is nullable and the default is NULL. I want to insert NULL, only when nothing has been entered in the “…
Why does my data from SQL table delete after I run this code?
I have this code that I want to run and it’s connected to my database and it uses to show the values on the table but every time I do an UPDATE query. It updates the rest of the row with zeros except …