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).

MySQL problem

simrah

The problem is, when you reload the page, the MYSQL sample remains, it is not removed, but only increases by one each time, how to do so that it does not increase.

Here's the code.

       $result = mysql_query('SELECT `school` . `school`,  `street`
     FROM
      `datacenter`, `school` 
        WHERE
          `datacenter` . `id_school` = `school` . `id_school` 
         AND
       `datacenter` . `name` = "'.$name_teacher.'"');
    while( $row = mysql_fetch_array( $result )) 
    {

echo $row[0];

echo $row[1];

echo $row[2];

♪

N
Nykeriab last edited by

We need to re-entry the data.
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

J

Validation array POST php
Software Programming • php html5 • • Jolied

2

0
Votes

2
Posts

0
Views

E

One way to do is to generate a array associative from the form already relating the data of each record. Something like:<tr> <td><input type="text" name="registros[0][nome]" value="teste1"></td> <td><input type="text" name="registros[0][email]" value="email@email.com.br"></td> <td><input type="text" name="registros[0][fatura]" value="666666666"></td> <td><input type="checkbox" name="registros[0][valida]" value="1"></td> </tr> Note: the value of the index, exemplified as 0, must be manually incremented.So instead of generating four arrays distinguished, will be created only one. For example, $_POST would be something like:$_POST = [ 'registros' => [ [ 'nome' => '...', 'email' => '...', 'fatura' => '...', 'valida' => '...' ], [ 'nome' => '...', 'email' => '...', 'fatura' => '...', 'valida' => '...' ], [ 'nome' => '...', 'email' => '...', 'fatura' => '...', 'valida' => '...' ], ... ] ]; This way you can use the function array_filter to take only the records they have valida equal to 1:$validados = array_filter($_POST['registros'], function ($it) { return isset($it['valida']) and $it['valida'] == 1; });
K

MySQL problem
Software Programming • mysql • • kalena

2

0
Votes

2
Posts

0
Views

Y

There's no way to check it out now, but ENUM Have you checked the data?Not sure how to use CURRENT_TIMESTAMP type data DATETIME
J

Problems in mysql-libmysqlclient
Software Programming • mysql linux node.js centos • • juvenalb

2

0
Votes

2
Posts

0
Views

T

warning: mysql.h: No such file or directoryno headline files mysql♪distributive centos This can be done, for example, by the team:$ sudo yum install mysql-devel
E

MySQL - installation problems with linux
Software Programming • mysql linux databank • • esther

2

0
Votes

2
Posts

0
Views

It seems to me that there is no problem in installing MySQL but rather some earlier incomplete installation (broken). The error message states that there was an attempt to install the package atom, but lacked the installation of dependence git.In the error message is one of the possible solutions, which is to run sudo apt-get update sudo apt-get -f install where the -f option means fix broken.Another solution is to remove the package with pending installation dependencies:sudo apt-get --purge remove atom After error correction action, repeat the MySQL installation steps.To reduce error possibilities, and if you are new to using GNU/Linux & MySQL, I suggest you install MySQL packages that are part of the distribution repositories and not the packages of the MySQL repositories.The installation instructions of MySQL 5.7 in GNU/Linux distribution (derived from) Debian are in https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/ .
J

Friendly URL does not recover variable
Software Programming • php htac languagec languagees • • Jolied

2

0
Votes

2
Posts

0
Views

A

The problem with your .htaccess is that in the ruleRewriteRule ^/artista/([0-9]+)$ /artista.php?artista=$1 the ^/ at the beginning indicates that the path must start with /artista. As in your case the path begins with mg/, the rule is jumped. For it to work you just need to remove ^/ from the beginning of the rule.Ex:<IfModule mod_rewrite.c> RewriteEngine On RewriteCond %{SCRIPT_FILENAME} !-f RewriteCond %{SCRIPT_FILENAME} !-d RewriteRule /artista/([0-9]+)$ /artista.php?artista=$1 </IfModule> Note: If you don't know, http://htaccess.madewithlove.be/ you can find a very good tool to test htaccess.
R

Check the availability of certain data at MySQL
Software Programming • python mysql python 3.x telegram bot python telegram bot • • rielyn

2

0
Votes

2
Posts

0
Views

J

Check, like,def check(date: str, time: str): mycursor.execute("SELECT * FROM users WHERE data=date AND time=time") return myresult = mycursor.fetchone() @run_async @log_func(log) def on_time_12(update: Update, context: CallbackContext): global text_time user_data = context.user_data text_time = '12:00' user_data['Время'] = text_time if check(user_data['Дата'], user_data['Время']): query.answer_callback_query(text='Извините, это время занято, выберите другое!', show_alert=True) print('Найдено в бд') else: query.edit_message_text('''Введите своё *Имя и Фамилию*''', parse_mode='Markdown')
J

Problem with date in consultation mysql
Software Programming • php mysqli • • jules

2

0
Votes

2
Posts

0
Views

B

Good Killpe,The problem is that a format uses a separator (Formato español '/') and the other uses one different (Formato inglés '-').You must put a replacement for the separators to be able to cast the date well, as follows:$fechafin=date('Y-m-d',strtotime(str_replace('/', '-',$_POST["Listado_fechafin"])));
SELECT LATEST ENTRY ON GROUP BY
SQL, Database Testing • mysql • • irl

2

0
Votes

2
Posts

0
Views

R

SELECT * FROM account_logs WHERE ID IN ( SELECT MAX(ID) FROM account_logs WHERE customer_id = 1061 GROUP BY DATE ) ORDER BY DATE ASC ; The sub-query should return all the ID's that you are interested in.
F

C# Problem with updating registration with mysql "Windows Form"
Software Programming • mysql c sharp • • fbio

2

0
Votes

2
Posts

0
Views

B

The mistake is that MySQL waits for the race column, a chain but does not send that, plus the word reserved where, will always be glued or concatenated with the value you want to assign for the column raza.To fix this, you should add quotes to the value of Textbox and give a space to wherestring actualizar = "UPDATE raza SET " + " raza ='" + txtRaza.Text + "' WHERE id_raza =" + txtIdraza.Text; Of course, this is a security error, matching values directly. you should use prepared sentences, for which you would recommend https://docs.microsoft.com/es-es/dotnet/api/system.data.sqlclient.sqlcommand.prepare?redirectedfrom=MSDN&view=netframework-4.7.2#System_Data_SqlClient_SqlCommand_Prepare
R

Automatic publications instagram php
Software Programming • php api instagram • • rosemadder

2

0
Votes

2
Posts

0
Views

E

You can use this API: https://github.com/mgp25/Instagram-API Here’s an example of how to upload a photo to Instagram:<?php require '../src/Instagram.php'; /////// CONFIG /////// $username = ''; $password = ''; $debug = false; $photo = ''; // path to the photo $caption = null; // caption ////////////////////// $i = new Instagram($username, $password, $debug); try{ $i->login(); } catch (InstagramException $e) { $e->getMessage(); exit(); } try { $i->uploadPhoto($photo, $caption); } catch (Exception $e) { echo $e->getMessage(); }
Sort array by itself within the indice in PHP
Software Programming • php array • • irl

2

0
Votes

2
Posts

0
Views

A

With PHP 5.5.0 or higher, you can make use of the function http://php.net/manual/pt_BR/function.array-multisort.php together with the http://php.net/manual/pt_BR/function.array-column.php :<?php $arr = [['z', 'b', 'h', 'd', 'e'], ['b', 'c', 'r', 'i', 'l'], ['q', 'w', 'y', 'u', 's']]; // Ordena $arr pelo valor da coluna 0: array_multisort(array_column($arr, 0), SORT_ASC, $arr); print_r($arr); See working on https://ideone.com/F51GhJ | https://repl.it/MurE/0 Resulting in:Array ( [0] => Array ( [0] => b [1] => c [2] => r [3] => i [4] => l ) [1] => Array ( [0] => q [1] => w [2] => y [3] => u [4] => s ) [2] => Array ( [0] => z [1] => b [2] => h [3] => d [4] => e ) ) With the function array_column you will create the order of values based on the desired column and this order will be kept in the ordering of others arrays, which is own $arr.
J

Problems with MySQL Server
Software Programming • mysql mariadb archlinux • • jonetta

2

0
Votes

2
Posts

0
Views

K

MySQL server in Arch Linux replaced by MariaDB. It's MySQL server.Remove MySQL and MariaDB interfere with dependence.Perhaps you've forgotten to launch the base:mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql mysql_secure_installation And launch a demon:systemctl enable mysqld systemctl start mysqld We can read more detail. https://wiki.archlinux.org/index.php/MySQL_(%D0%A0%D1%83%D1%81%D1%81%D0%BA%D0%B8%D0%B9) ♪
E

python-problem with mySQL OBD
Software Programming • python mysql python 3.x code • • esther

2

0
Votes

2
Posts

0
Views

C

https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.to_sql.html does not allow change (UPDATE) SQL tables. The contents of the whole table may be re-written eitherif_exists='replace') or add new entries (if_exists='append') New records will only contain data that are available in DataFrameIf you need to do it UPDATEwhich may be done as follows:First, keep DataFrame in Time (for the meaning and not the type of tables in MySQL) Table:df.to_sql('tmp', conn, if_exists='replace') Then change the necessary columns at MySQL. http://docs.sqlalchemy.org/en/latest/core/tutorial.html#executing )update comments set pred_lr=tmp.pred_lr, pred_nb=tmp.pred_nb FROM comments INNER JOIN tmp on comments.id = tmp.id;
Problems when converting mysql query to mongodb
Software Programming • mysql sql mongodb nodejs • • Marcee

2

0
Votes

2
Posts

0
Views

depends how you have structured your documents in MongoDB a solution could be: db.nombreColeccion.find({campo:{$lt:variable}}, {placa:1, capacidad:1})
A

Problem when extracting data from a weak entity with a foreign key in MySQL
Software Programming • mysql sql • • Avante

2

0
Votes

2
Posts

0
Views

B

You have to add a common field between the 2 associated tables. Then in the WHERE add the condition. Example of how the structure of the SQL sentence should be (fiction data):SELECT * FROM Doctor_Account INNER JOIN Doctor_Patient_Connection ON Doctor_Patient_Connection.PatientAccount_ID = Doctor_Account.id WHERE Doctor_Patient_Connection.PatientAccount_ID = 2;

MySQL problem

Suggested Topics

Validation array POST php Software Programming • php html5 • • Jolied

MySQL problem Software Programming • mysql • • kalena

Problems in mysql-libmysqlclient Software Programming • mysql linux node.js centos • • juvenalb

MySQL - installation problems with linux Software Programming • mysql linux databank • • esther

Friendly URL does not recover variable Software Programming • php htac languagec languagees • • Jolied

Check the availability of certain data at MySQL Software Programming • python mysql python 3.x telegram bot python telegram bot • • rielyn

Problem with date in consultation mysql Software Programming • php mysqli • • jules

SELECT LATEST ENTRY ON GROUP BY SQL, Database Testing • mysql • • irl

C# Problem with updating registration with mysql "Windows Form" Software Programming • mysql c sharp • • fbio

Automatic publications instagram php Software Programming • php api instagram • • rosemadder

Sort array by itself within the indice in PHP Software Programming • php array • • irl

Problems with MySQL Server Software Programming • mysql mariadb archlinux • • jonetta

python-problem with mySQL OBD Software Programming • python mysql python 3.x code • • esther

Problems when converting mysql query to mongodb Software Programming • mysql sql mongodb nodejs • • Marcee

Problem when extracting data from a weak entity with a foreign key in MySQL Software Programming • mysql sql • • Avante

Validation array POST php
Software Programming • php html5 • • Jolied

MySQL problem
Software Programming • mysql • • kalena

Problems in mysql-libmysqlclient
Software Programming • mysql linux node.js centos • • juvenalb

MySQL - installation problems with linux
Software Programming • mysql linux databank • • esther

Friendly URL does not recover variable
Software Programming • php htac languagec languagees • • Jolied

Check the availability of certain data at MySQL
Software Programming • python mysql python 3.x telegram bot python telegram bot • • rielyn

Problem with date in consultation mysql
Software Programming • php mysqli • • jules

SELECT LATEST ENTRY ON GROUP BY
SQL, Database Testing • mysql • • irl

C# Problem with updating registration with mysql "Windows Form"
Software Programming • mysql c sharp • • fbio

Automatic publications instagram php
Software Programming • php api instagram • • rosemadder

Sort array by itself within the indice in PHP
Software Programming • php array • • irl

Problems with MySQL Server
Software Programming • mysql mariadb archlinux • • jonetta

python-problem with mySQL OBD
Software Programming • python mysql python 3.x code • • esther

Problems when converting mysql query to mongodb
Software Programming • mysql sql mongodb nodejs • • Marcee

Problem when extracting data from a weak entity with a foreign key in MySQL
Software Programming • mysql sql • • Avante