Got my solution: select ledger_date ,ledger_desc ,ledger_debit, ledger_credit, sum(ledger_debit) over (order by ledger_id) - sum(ledger_credit) over (order by ledger_id) as Balance from tblledger

You appear to have instructed phpMyAdmin to use the "Configuration Storage" database (which gives you extra features such as bookmarking queries), but the associated user doesn't seem to exist or have proper permissions. You can remove the configuration directive that is telling phpMyAdmin to use the advanced features by editing config.inc.php and setting $cfg['Servers'][$i]['pmadb'] to a blank string, like $cfg['Servers'][$i]['pmadb'] = ''; There is a chance the use, called the controluser, is misconfigured. If the user appears to exist in your phpMyAdmin, then probably either the host field or password are incorrect. Assuming it doesn't exist, you could create the missing user, using the username and password you define in config.inc.php for the controluser and controlpass fields: With MariaDB: CREATE USER 'pma'@'localhost' IDENTIFIED VIA mysql_native_password USING 'pmapass'; GRANT SELECT, INSERT, UPDATE, DELETE ON ``.* TO 'pma'@'localhost'; For MySQL 8.0 and newer: CREATE USER 'pma'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'pmapass'; GRANT SELECT, INSERT, UPDATE, DELETE ON .* TO 'pma'@'localhost'; For MySQL older than 8.0: CREATE USER 'pma'@'localhost' IDENTIFIED WITH mysql_native_password AS 'pmapass'; GRANT SELECT, INSERT, UPDATE, DELETE ON .* TO 'pma'@'localhost'; See also: https://docs.phpmyadmin.net/en/latest/setup.html#phpmyadmin-configuration-storage https://docs.phpmyadmin.net/en/latest/config.html#cfg_Servers_pmadb https://docs.phpmyadmin.net/en/latest/setup.html#manual-configuration https://docs.phpmyadmin.net/en/latest/config.html#cfg_Servers_controluser

For the foreign key constraint to work, the type of the id column in the Users table needs to be the same as that of the Employee_Id column in the emps table. So let's say for example that the Employee_Id has type int(11) unsigned, then that is how you should also specify the type of id in Users. (By the way, float(6) is a strange primary / foreign key!)

LEFT JOIN (instead of INNER JOIN or JOIN) produces a row in the output even if there is no matching row in the 'right' table. It will produce all NULL for the missing data. Then you can use COALESCE(p.DescProducto, 0) to turn NULL into 0.

Planned to create a field id in the table of messages

We need to check what you get from the OBD.$result = mysql_query("SELECT * FROM table_products WHERE visible='1' $query_cat ORDER BY $sorting", $link); Like that.if($result && mysql_num_rows($result) > 0){ ... and review the processing if there is no desired result.

For starters, get on to the:<?php try { $pdo = new PDO('mysql:host=Название хоста (у вас наверняка localhost);dbname=название БД','имя пользователя','пароль'); } catch (Exception $e) { echo $e->getMessage(); } ?> Then ask for a sample of data from the table:$stmt = $pdo->query('select * from text'); Next in the cycle (if you have a few lines of record) shall be taken as follows:if($stmt->rowCount() > 0){ while($res = $stmt->fetch(PDO::FETCH_BOTH)){ echo '<p>'.$res['text'].'<p>'; } } If you'd like to take out one of the:$res= $stmt->fetch(); echo '<p>'.$res['text'];.'</p>'; You can do it right in html, then just don't forget to put the php in. For example: <p><?php echo $res['text']; ?></p>

Good afternoon. You need to go to the phpmyadmin, default to open server, root and password login, and then I'd set up a new yantar-apart database under the project, and then press the IMPORT button and select your yantar-apart.sql

Two first reasons that may cause this error:In terms of mysql 127.0.0.1 and localhost - it's different things. And if you're willing to have access to the user root c Hosta 127.0.0.1that doesn't mean he'll have access. localhost♪It's a blunt error in a roll password.What should be considered in detail in these cases https://ru.stackoverflow.com/questions/552936/ ♪ Do whatever it says, if it doesn't help, add your question to the results of these actions, we'll think about it.

Depends on the method of installation.You. https://github.com/phpmyadmin/phpmyadmin phpMyAdmin, copy the right dose, change configuration (namely for phpMyAdmin). In this case, the configuration of the system is not affected. Similar to installation http://docs.phpmyadmin.net/en/latest/setup.html#installing-using-composer You set up a package manager, I won't tell you all the DS, like debian. phpMyAdmin is in the repository, you can be installed with help. apt or apt-get (sighs) https://wiki.debian.org/ru/LaMp#phpMyAdmin ) In this case, additional packages will be installed, configuration changes required for work are made phpMyAdminYou're using any auxiliary installers that might also change the installation process.Used http://docs.phpmyadmin.net/en/latest/setup.html#installing-using-docker ♪ It's up to you to decide whether a separate image will be or will be combined with other decisions of yours.

On the front page of the search for Yandex at the request of "phpmyadmin to set up a table." Specifically, this article: http://phys.bspu.unibel.by/static/lib/inf/int/htmlbook/pr_213.html ♪

As an option, it would be better to separate the contents of the filename by adding it to a separate table where u_login will be connected and then remove it.Then you don't have to remove a whole recording containing something other than "22.jpg" in "filename."P.S. Either remove by LIKE:DELETE FROM images_big WHERE filename LIKE '22.jpg%'

For MDB (Buttstrap) https://mdbootstrap.com We'll set up an OD with a table of "userinfo" and Poles: userinfo_id, userinfo_name, userinfo_position, userinfo_region,userinfo_age,userinfo_begin_dateWe need to get CSS on. <!-- MDBootstrap Datatables --> <link href="css/addons/datatables.min.css" rel="stylesheet"> Introduce a file to the body, for an advanced table:<table id="dtMaterialDesignExample" class="table table-striped" cellspacing="0" width="100%"> <thead> <tr> <th class="th-sm">№ </th> <th class="th-sm">Ф.И.О. </th> <th class="th-sm">Должность </th> <th class="th-sm">Область </th> <th class="th-sm">Возраст </th> <th class="th-sm">Начало работа </th> </tr> </thead> <tbody> <?php $conn = mysqli_connect("localhost", "root", "", "company"); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT userinfo_id, userinfo_name, userinfo_position, userinfo_region,userinfo_age,userinfo_begin_date FROM userinfo"; $result = $conn-&gt;query($sql); if ($result-&gt;num_rows &gt; 0) { // output data of each row while($row = $result-&gt;fetch_assoc()) { echo "&lt;tr&gt;&lt;td&gt;" . $row["userinfo_id"] . "&lt;/td&gt;&lt;td&gt;" . $row["userinfo_name"] . "&lt;/td&gt;&lt;td&gt;" . $row["userinfo_position"] . "&lt;/td&gt;&lt;td&gt;" . $row["userinfo_region"] . "&lt;/td&gt;&lt;td&gt;" . $row["userinfo_age"] . "&lt;/td&gt;&lt;td&gt;" . $row["userinfo_begin_date"] . "&lt;/td&gt;&lt;/tr&gt;"; } echo "&lt;/tbody&gt;"; } else { echo "0 results"; } $conn-&gt;close(); ?> and Java Scream // Material Design example $(document).ready(function () { $('#dtMaterialDesignExample').DataTable(); $('#dtMaterialDesignExample_wrapper').find('label').each(function () { $(this).parent().append($(this).children()); }); $('#dtMaterialDesignExample_wrapper .dataTables_filter').find('input').each(function () { $('input').attr("placeholder", "Search"); $('input').removeClass('form-control-sm'); }); $('#dtMaterialDesignExample_wrapper .dataTables_length').addClass('d-flex flex-row'); $('#dtMaterialDesignExample_wrapper .dataTables_filter').addClass('md-form'); $('#dtMaterialDesignExample_wrapper select').removeClass( 'custom-select custom-select-sm form-control form-control-sm'); $('#dtMaterialDesignExample_wrapper select').addClass('mdb-select'); $('#dtMaterialDesignExample_wrapper .mdb-select').materialSelect(); $('#dtMaterialDesignExample_wrapper .dataTables_filter').find('label').remove(); }); There's still a JS to connect. <!-- MDBootstrap Datatables --> <script type="text/javascript" src="js/addons/datatables.min.js"></script>

$command = "SELECT COUNT(uid) FROM users WHERE date BETWEEN UNIX_TIMESTAMP(SUBDATE(CURDATE(), 1) AND UNIX_TIMESTAMP(CURDATE())";

Is this where it's put in utf8?

There's no support for the lip, it's clear that it turns out a full violin index.php

DATE data type used for values containing information on Yes. MySQL extracts and removes DATE values in the "YYYYY-MM-DD" format.You won't be able to change the storage format on another database - it's the MySQL standard. Use the DateTime class for the forming of the withdrawal, which allows for easy handling of dates. DateTime::createFromFormat('Y-m-d', '2015-05-24')->format('d-m-Y');

phpMyAdmin looking line 'NULL' which not equal value 'NULL', so we're gonna have to use the SQL request.update table_name set column_name = 'value' where column_name is null;

SELECT dates.user_id FROM dates LEFT JOIN pays ON pays.user_id = dates.user_id WHERE pays.id IS NULL GROUP BY dates.user_id HAVING COUNT(dates.user_id) IN (7,8) We take all the records from the dates, pays with pay, make the condition that no payment has been made, group the user_id and see that the user matches the condition that he has seven or eight sessions.You asked about the number of visits in the second month, while the simplest thing you've come up with, that's how it worked out, of course, I think it's cool, but okay. Choose all the dates, Joyim pays, grouped by user_id, see if the bulb on different dates of the visits is equal to 7*col-wheel or 8*col-to-pay, at least 1, the user enters the interval and can be warned. Pays must have a unique identifier (id), dates must necessarily have a date of visit (date).SELECT dates.user_id, COUNT(DISTINCT pays.id)+1 pcount FROM dates LEFT JOIN pays ON pays.user_id = dates.user_id GROUP BY dates.user_id HAVING COUNT(DISTINCT dates.date) IN (7pcount, 8pcount) How shorter and more effective to write the second one didn't come to mind yet.

select vd.vendor_id, vd.title, vd.tax, v.vtotal, vs.country_id, vs.zone_id, c.commission from oc_vendor_discount vd, oc_vendor v, oc_vendors vs, oc_commission с <-было пропущено where v.vproduct_id = '" . (int)$product['product_id'] . "' and vs.vendor_id = v.vendor and c.commission_id = vs.commission_id