Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

How to apply the conditions if/else in SQL?

tahishae

There's a sample in the variable.

Specify how to apply the conditions if/else Total sql♪ For example, if advert.hide='show' ... otherwise.

$db_query="select *
    from ".DB_PREF."advert advert"
    ." where "
    ." advert.hide='show'  "
    ." and advert.end_putdate > ".$GLOBALS["timeGlobal"]." "
    ." order by premium_adv DESC, sort_time DESC limit ".KOL_NEW_ADVERT_TO_GLAV;

E
elysha last edited by
Use your function. IF:
```
 select IF (advert.hide='show', 'Опубликовано', 'Скрыто') from ...
```
The function looks general, so:
```
IF(expr1,expr2,expr3)
```
If expr1 The truth then. IF() returns expr2Otherwise returning expr3♪
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

J

Recurring
Software Programming • php • • jonetta

2

0
Votes

2
Posts

0
Views

In your option, it may be, for example, 1,000 folders, and if it is a recurring attempt to consistently select a number, there may be an endless recurrence. Why don't you just give folders names by number of files in folder two? count(scandir($dir)) - 2♪The answers to your question may be a few, for example, in a selective choice:function createRandomDir($count = 0, $maxCount = 777) { if(++$count > $maxCount) //предотвращение бесконечной рекурсии exit('Не удалось создать директорию... Предотвращена бесконечная рекурсия'); $randval = rand(1, 1000); // Беру число в нужном диапазоне $structure = '../objects/'.$randval.'/'; if(is_dir("../objects/$randval")) createRandomDir() //рекурсивный вызов, будет создано новое число, которое ВОЗМОЖНО не совпадет с именем существующей папки if (!mkdir($structure, 0777, true)) // создаю папку exit('Не удалось создать директорию...'); } Or you can fix it. $i 0 to 1,000, check the folder $i+$randValif $i+$randVal > 1000 - Cancel. $i and $randValif the cycle is completed$i>1000and the folder is not created - there are no free names in many names between 0 and 1,000.Functions can be seen. uniqid() (returns the line, not the number), or str_replace('.', '', microtime(true))if you need a number, it'll be over 1,000.
B

Sending only the id
Software Programming • php • • baileigh

2

0
Votes

2
Posts

0
Views

M

1st MYSQLMySQL functions had become obsolete after updates. It is currently used MYSQLi for its performance being superior and some advantages. Read about this link: https://secure.php.net/manual/pt_BR/book.mysqli.php 2nd CONEXION WITH DATA BANKAs a way to ensure more security and better handling with DB, a part-to-part page should be made for the connection as follows.1 - Create a php page called conexao.php. After creating, add your connection to this page. Staying like this:<?php $servidor = "localhost"; $usuario = "root"; $senha = ""; $dbname = "copa"; //Criar a conexao $conn = mysqli_connect($servidor, $usuario, $senha, $dbname); if(!$conn){ die("Falha na conexao: " . mysqli_connect_error()); } ?> Thus avoiding the duplicate of connections. Save your connection wherever you wish (Preferably in the root folder along with the pages to follow this tutorial correctly).3rd FORMYou should first make the form send your data to PHP.at the beginning of the tag, assign it as POST method.<form enctype="multipart/form-data" name="form" method="POST"> After assigning, add a name to your button:<input type="submit" value="Cadastrar" name="btnForm"> So you can call the data when the button is triggered.Save your form where you want (Preferably in the root folder along with the pages to follow this tutorial properly)._You need to transfer your form input values into the INSERT.This way:<?php include_once("conexao.php"); // Incluir sua conexão com o banco de dados. include_once("formulario.php"); // Incluir a página do seu formulário. $btnForm = filter_input(INPUT_POST, 'btnForm', FILTER_SANITIZE_STRING); if($btnForm){ include_once 'conexao.php'; $dados = filter_input_array(INPUT_POST, FILTER_DEFAULT); $inserirBD = "INSERT INTO palpites (nome, email, palpites, palpites2, palpites3) VALUES ( '" .$dados['nome']. "', '" .$dados['email']. "', '" .$dados['palpites']. "', '" .$dados['palpites2']. "', '" .$dados['palpites3']. "' )"; $resultado = mysqli_query($conn, $inserirBD); if(mysqli_insert_id($conn)){ echo " <META HTTP-EQUIV=REFRESH CONTENT = '0;URL=http://localhost/PASTA/formulario.php'> <script type="text/javascript"> alert("Dados inseridos com sucesso."); </script> "; // Cria um alerta para seu cadastro. }else{ echo " <META HTTP-EQUIV=REFRESH CONTENT = '0;URL=http://localhost/PASTA/formulario.php'> <script type="text/javascript"> alert("Erro ao inserir dados."); </script> "; // Cria um alerta para seu cadastro. } } ?> Remembering that when you create an id on MySql, you can put it to be AUTO INCREMENT, where it will count every time you add a new hunch, all automatic, not needing to add it to the Mysql INSERT.
D

Is there an example of a step-by-step development on Yii from NAL?
Software Programming • php yii • • derk

2

0
Votes

2
Posts

0
Views

S

Look at this. http://www.youtube.com/user/killlinuxkill/videos There's a lot of things to do for a newcomer.Updating /users/13192/%D0%B0%D1%80%D1%82%D1%83%D1%80-%D0%BF%D0%B0%D0%BD%D1%82%D0%B5%D0%BB%D0%B5%D0%B5%D0%B2 it implements and explains most of the main parts of the website development using Yii. I don't understand what you mean by getting ready because Yii is a site set, here. http://yiiframework.ru/doc/guide/ru/quickstart.first-app documentation for the establishment of an empty Yii-Annex.
Error query sql The query has returned a value that is not correct sql
Software Programming • sql server sql • • Marcee

2

0
Votes

2
Posts

0
Views

T

You can do this in different ways and everything depends on what you want to do.To correct the error, you can make sure to return only one value through TOP instruction. Remember to specify an order so that you can have confidence that value will be assigned.DECLARE @Temp Date; SET @Temp = (SELECT TOP (1) eq.Fecha_adquisicion FROM Equipo eq INNER JOIN Empleados e ON e.ID_Empleado = ID_Empleado ORDER BY Fecha_adquisicion DESC); The other option that is a common form but has a slightly different behavior is using the SELECT to assign values.DECLARE @Temp Date; SELECT TOP (1) @Temp = eq.Fecha_adquisicion FROM Equipo eq INNER JOIN Empleados e ON e.ID_Empleado = ID_Empleado ORDER BY Fecha_adquisicion DESC; The main difference is that if the query does not return any value, the first option will assign an NULL to the variable, and with the second one will not change the value of the variable. Another difference is that the second option allows assigning values to multiple values at the same time instead of using multiple commands.If you want to store all the values, what you need in a table type variable that receives the values differently from a scale variable, but equal to a common table.DECLARE @Temp TABLE( Fecha_Adquisicion Date ); INSERT INTO @Temp( Fecha_Adquisicion) SELECT eq.Fecha_adquisicion FROM Equipo eq INNER JOIN Empleados e ON e.ID_Empleado = ID_Empleado; In this option we remove the ORDER BY because there is no order within a table.
B

How can I create a conditional with two conditions of two different variables in one?
Software Programming • python python 3.x numpy func languagetional progr • • baileigh

2

0
Votes

2
Posts

0
Views

first you have to remember that in Python there are no arraysunless you're working with numpy and variable X it's kind of numpy.array, second lists don't have a method apply() only DataFrames And you're not working with one. Finally your expression lambda is wrong, including X[:,0] (I don't know why you're doing that.) For your problem we will solve it using the function map() together with a lambda expression, to access each element we will use the syntax X[0],X[1] to access the first and second element correspondingly.the operation map() will return a list with the values obtained according to the last lambda expressionFrom what I see you compare with t, so if you say it should be greater than 0.5 and less than 0.3 t=[0.5,0.3]t = [0.5,0.3] #pondra 0 si el primer valor es menor que 0.5 el segundo es mayor 0.3, de lo contrario 1 y_new = map(lambda x: 0 if x[0]<0.5 and x[1]>0.3 else 1, X) #es lo mismo que #y_new = map(lambda x: 0 if x[0]<t[0] and x[1]>t[1] else 1, X) #para ver sus elementos lo convertimos a lista y_new = list(y_new) #imprimimos print(y_new) Dando as a result[1, 1, 0, 1, 1, 0, 0, 1, 1, 0, 0, 1, 0, 1, 0, 1, 1, 1, 0, 0] In a comment you said it was a Numpy.array(), in this case also works the lambda expression import numpy as np X = np.array([[0.5 , 0.65], [0.75, 0.34], [0.37, 0.5 ], [0.57, 0.74], [1. , 0.69], [0.1 , 0.61], [0.04, 0.36], [0.56, 0.45], [0.46, 0.01], [0.46, 0.97], [0.26, 0.83], [0.47, 0.01], [0.34, 1. ], [0.85, 0.41], [0. , 0.72], [0.66, 0.08], [0.3 , 0.19], [0.71, 0. ], [0.3 , 0.77], [0.17, 0.96]]) y_new = map(lambda x: 0 if x[0]<0.5 and x[1]>0.3 else 1, X) #es lo mismo que #y_new = map(lambda x: 0 if x[0]<t[0] and x[1]>t[1] else 1, X) y_new = list(y_new) print(y_new) Departure[1, 1, 0, 1, 1, 0, 0, 1, 1, 0, 0, 1, 0, 1, 0, 1, 1, 1, 0, 0] If you want to get the value Boolean we can do it by transforming it with function bool(), this by means of a list compressiony_new = [bool(val) for val in y_new] print(y_new) Departure[True, True, False, True, True, False, False, True, True, False, False, True, False, True, False, True, True, True, False, False] And as I said in a comment you can deny that.y_new = [not bool(val) for val in y_new] print(y_new) Departure[False, False, True, False, False, True, True, False, False, True, True, False, True, False, True, False, False, False, True, True]
R

Consultation Sql Conditioned Group
Software Programming • sql database • • Raziyah00

2

0
Votes

2
Posts

0
Views

B

I think you're comparing badly. If you don't want any row from that one. docto if it is already marked as charged, then you have to filter through that field and not by one that changes each row.SELECT status, Aut, docto, fdocto, nombre, rfc, frec, imp, obs FROM t_base WHERE docto not in( SELECT docto FROM t_base WHERE status in ('Cobrada','Cacelada','Cancelada','Cancelado')) AND docto in ('2018-02030405','2019-010203','2020-010203') ORDER BY docto DESC;
How did a SQL screen on MS SQL Server perform in the database?
Software Programming • database • • irl

2

0
Votes

2
Posts

0
Views

C

Maybe we should just set up a custodian procedure that will keep everything.
B

You can use the name of a column as a condition in SQL Server
Software Programming • sql server • • Burma

2

0
Votes

2
Posts

0
Views

C

Could you give more information about how you're trying to do the query?If what you want is to update that value you have pointed out would be something likeUPDATE nombretabla SET MONTO_ENE_18 = 40000 WHERE MONTO_ENE_18 = 30382 You could also use a AND to refine the search.
N

How do you turn the bitrix module through FTP?
Software Programming • php php7 bitrics • • Nykeriab

2

0
Votes

2
Posts

0
Views

T

You can turn off mistakes in file .htaccess or in the database in table b_option.
J

Preservation of original name pictures
Software Programming • php sql • • jonetta

2

0
Votes

2
Posts

0
Views

Send unique names using uniqid()and then these names along with the extension, and also, if necessary, by keeping them in the OBD system. I don't understand. UploadBut using standard methods, it's gonna look like this:$fileExt = explode('.', $_FILE['file']['name']) // Получаем расширение файла $fileName = uniqid("image_") . ".{$fileExt}"; // Создаем уникальное имя move_uploaded_file($_FILE['file']['tmp_name'], $path . $fileName) // Сохраняем файл We need to keep the variable. $fileName♪ The table is structured around:CREATE TABLE api.image ( id INT(11) NOT NULL AUTO_INCREMENT, path VARCHAR(255) NOT NULL, alias VARCHAR(255) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE = INNODB; alias You're asking it yourself, for example, you're not. alias♪ userIdand tie the picture to the user. Then it's like,SELECT i.path from image i WHERE i.userId = 1;
Array of conditions SQL - PHP
Software Programming • php mysql sql • • Marcee

2

0
Votes

2
Posts

0
Views

B

Yes, you can use implode/join, but your code is very repeated, a simple way to do this is:$keys = array('nome', 'tipoAnimal', 'raca', 'tamanho', 'sexo', 'estado', 'cidade'); $conditions = array(); foreach($keys as $key) { $val = $_GET[$key]; if (!empty($val)) { $conditions[] = "$key = '$val'"; } } $full_conditions = join(" AND ", $conditions); $sql = "SELECT * FROM nome_tabela" . (empty($full_conditions) ? "": " WHERE $full_conditions;"); This answer is only worth searching for equality in the database, it would not give to do something like select * from tabela where nome like '%foo%', I suggest you read about ORMs in PHP[0].[0] http://pt.wikipedia.org/wiki/Mapeamento_objeto-relacional
Request for multiple SQL conditions
Software Programming • sql access demand • • Mystic

2

0
Votes

2
Posts

0
Views

Z

SELECT country, -SUM(active) [Выступающие], -SUM(NOT active) [Закончившие выступать] FROM musicians GROUP BY country In MS Access, the logical field in the numerical context is transformed into 0 for FALSE and -1 for TRUE♪They have to be matured across the country and neutralize the minus.
R

ORA-00904 error
Software Programming • sql oracle • • Raziyah00

2

0
Votes

2
Posts

0
Views

K

As an option to get another request.select * from (...) t order by t.item_date, t.order_num;
T

How to improve view by sending data to ajax?
Software Programming • php html jquery ajax laravel • • terrea

2

0
Votes

2
Posts

0
Views

N

You can use the Blade components or call subviews to avoid repeating the JS code or HTML.Given that your code is a little long, I give you the idea to implement it with subvisives:resources/views/partials/js-ajax.blade.php$('#{{ $action }}-TE').on('click', function () { verModal(true); // ... }); resources/views/modal.blade.php$(document).ready(function () { @include('partials.js-ajax', ['action' => 'refresh']) @include('partials.js-ajax', ['action' => 'delete']) }); Something similar would be for the HTML code you have.More information in Blade documentation: https://laravel.com/docs/5.4/blade
A

As one SQL request, get all values with different sorting conditions
Software Programming • mysql sql database mysqli • • amarantha

2

0
Votes

2
Posts

0
Views

K

On the basis of comments on the question, it is a convincing request that the question be re-examined so that he would really ask what is needed:$rename=array('OFFLINE'=>'OFFLINE_STATUS','TEMPLATE'=>'TEMPLATE_NAME'); $result = $mysqli->query('SELECT name, type, value FROM settings'); while($row=$result->fetch_array()) { $name=strtoupper($row['name']); if($row['type']=='lvl' || $row['type']=='publish') { $name=$name.'_'.strtoupper($row['type']); } if(array_key_exists($name, $rename)) $name=$rename[$name]; define($name,$row['value']); }

How to apply the conditions if/else in SQL?

Suggested Topics

Recurring Software Programming • php • • jonetta

Sending only the id Software Programming • php • • baileigh

Is there an example of a step-by-step development on Yii from NAL? Software Programming • php yii • • derk

Error query sql The query has returned a value that is not correct sql Software Programming • sql server sql • • Marcee

How can I create a conditional with two conditions of two different variables in one? Software Programming • python python 3.x numpy func languagetional progr • • baileigh

Consultation Sql Conditioned Group Software Programming • sql database • • Raziyah00

How did a SQL screen on MS SQL Server perform in the database? Software Programming • database • • irl

You can use the name of a column as a condition in SQL Server Software Programming • sql server • • Burma

How do you turn the bitrix module through FTP? Software Programming • php php7 bitrics • • Nykeriab

Preservation of original name pictures Software Programming • php sql • • jonetta

Array of conditions SQL - PHP Software Programming • php mysql sql • • Marcee

Request for multiple SQL conditions Software Programming • sql access demand • • Mystic

ORA-00904 error Software Programming • sql oracle • • Raziyah00

How to improve view by sending data to ajax? Software Programming • php html jquery ajax laravel • • terrea

As one SQL request, get all values with different sorting conditions Software Programming • mysql sql database mysqli • • amarantha

Recurring
Software Programming • php • • jonetta

Sending only the id
Software Programming • php • • baileigh

Is there an example of a step-by-step development on Yii from NAL?
Software Programming • php yii • • derk

Error query sql The query has returned a value that is not correct sql
Software Programming • sql server sql • • Marcee

How can I create a conditional with two conditions of two different variables in one?
Software Programming • python python 3.x numpy func languagetional progr • • baileigh

Consultation Sql Conditioned Group
Software Programming • sql database • • Raziyah00

How did a SQL screen on MS SQL Server perform in the database?
Software Programming • database • • irl

You can use the name of a column as a condition in SQL Server
Software Programming • sql server • • Burma

How do you turn the bitrix module through FTP?
Software Programming • php php7 bitrics • • Nykeriab

Preservation of original name pictures
Software Programming • php sql • • jonetta

Array of conditions SQL - PHP
Software Programming • php mysql sql • • Marcee

Request for multiple SQL conditions
Software Programming • sql access demand • • Mystic

ORA-00904 error
Software Programming • sql oracle • • Raziyah00

How to improve view by sending data to ajax?
Software Programming • php html jquery ajax laravel • • terrea

As one SQL request, get all values with different sorting conditions
Software Programming • mysql sql database mysqli • • amarantha