Questions tagged as 'mysql'

Tagged questions
1
answer

Check with a search engine in laravel

I wanted to know if the query is well done Where to find the posts of a blog that contain a word "query": public function search(Request $request) { //guarda la palabra en $query $query = $request->input('query');...
asked by 19.09.2017 / 02:16
1
answer

How to validate fields in MySQL stored procedures

I want you to recommend the most optimal way to validate the fields of a table when making an insert by stored procedures, when I say validate I mean that repeated data is not entered in fields that are defined as unique. My question arises b...
asked by 05.02.2018 / 22:30
1
answer

Update of multiple rows with different values

I'm trying to update different rows with different values, in my sql table, the closest I've come is: UPDATE cursos SET posicion = 11 where Id in (1,2) But it updates me with the same value (11) logically the two rows, I need to give a...
asked by 30.08.2017 / 01:12
1
answer

How to make an UPDATE of records to 3 related tables?

I have three related tables as follows: Now what I have to do is edit the information of a course, for example, the start date and in the quota table edit the amount of fees, to later edit the number of amounts in the table detalle_cuot...
asked by 26.08.2017 / 21:48
3
answers

Is it possible to do a kind of WHERE *?

I seek to make a query that makes a complete selection of the tabla that I select where any of all the existing fields in the db match the search value, this implies that the data that exists in the base of data with a value equal...
asked by 05.09.2017 / 16:37
1
answer

Select dependent PHP and MySQL

Greetings, I am creating a web application to register job vacancies using PHP, MySQL and a bit of Javascript. My problem is that I want to filter by educational level so that all records do not appear. I thought to use a switch inside PHP but i...
asked by 04.09.2017 / 20:21
1
answer

Send variable between two php files

Good morning I have a page where I show a sql table. And I want if the user clicks on a title it shows only the information of a row. I am trying to do so, news.php: <form action="new.php" method="post">...
asked by 31.08.2017 / 13:46
2
answers

Error Array to string conversion

I am trying to send two arrays to my BD, an array of activities and another array of points !! so the form, and the error that throws me is an array to string conversion I do not understand why, could you help me? error 1/2 is:...
asked by 05.09.2017 / 04:11
1
answer

Check only the current month

I have an invoice which will be filled in monthly, the records with the date do it correctly at Hora de Caracas/Venezuela , but in the following script it shows the values of example 05/agosto/17 al 05/septiembre/2017 , which would c...
asked by 05.09.2017 / 06:46
1
answer

Translate from SQL query to Eloquent

Hi, I'm new to eloquent and laravel, I have the following query, which runs perfectly from phpmyadmin: SELECT * FROM vips_categories JOIN vips_products JOIN vip_archivos WHERE vips_categories.parent_id = 1 AND vips_categories.parent_id = vips...
asked by 04.08.2017 / 20:49