All Questions
Tagged with mysql-python php
13 questions
-1
votes
1
answer
67
views
How get last five unique rates of product based on month & year in mysql query
I have a table with following data
I want last five rates of item based on month & year.
The logic behind it is that, if item price change in any particular month say two changes in a month it ...
- 19
0
votes
1
answer
637
views
Show and auto update values of MySQL DB in the web page if they are updated in the DB
I am taking values from sensor at an interval of 1 second. These values are being stored in MySQL DB. This is an automatic process.
Now I have made a website(free hosting) to show these values. The ...
- 1
3
votes
0
answers
5k
views
mysql.connector.errors.ProgrammingError: 1045 (28000): Access denied for user 'xpto'@'localhost' (using password: YES)
I have an issue when I try to access to a mysql server (MariaDB v10.1.37 ) using the python mysql.connector version 8.0.15.
I am trying to read data from my database, but I am getting an error when I ...
- 31
0
votes
1
answer
26
views
Get right row values retrieved with "group by" [duplicate]
We have "transactions" table:
id amount txn_id status status_text
1 15 123456 0 pending
2 11 123123 0 pending
3 15 123456 1 complete
4 20 ...
- 895
-1
votes
2
answers
441
views
select one column using multiple like statement in mysql
I am using php pdo and mysql, i want to select one more column using like statement. currently i have this query. And this query work fine.
$get_name = $db->prepare("SELECT dou.businessName, m....
- 27
0
votes
0
answers
209
views
MySQLdb import error when calling python script from PHP
I am on Ubuntu16, python3.6 is installed through anaconda distribution.
I have successfully installed MySQLdb module and it works fine when called (say) from the terminal. However, when I try to ...
- 687
0
votes
1
answer
347
views
Select column in one row and save as variable using python and mysqldb
first sorry for my bad english. i'm php programmer and I just started a python programming language.
Mysql code:
SELECT * FROM `datapy` ORDER BY `No` DESC LIMIT 0,1
And show row:
++++++++++++++++++
...
0
votes
2
answers
55
views
Error in mysqli statement
I got this error in mysqli
mysqli_select_db() expects exactly 2 parameters, 1 given in
/home/u751513549/public_html/recent.php on line 6
This is the code
<?php // Connects to your Database
...
- 31
0
votes
1
answer
279
views
php cannot execute python script with MySQLdb
I have 2 scripts.
1 - php web-scripts which collects information from a user and execute python script with sending all collected data as arguments
2 - python script which gets arguments from php-...
- 152
0
votes
1
answer
197
views
MySQLdb Python Query
I'm trying to make a translation of an SQL query from PHP to MySQLdb for Python.
Following is the PHP Code:
$query = "
select
`ip_address`.`address`,
`interface`.`...
- 31
0
votes
2
answers
171
views
browser query vs python MySQLdb query [closed]
I wanted to know whether mysql query with browser is faster or python's MySQLdb is faster. I am using MysqlDb with PyQt4 for desktop ui and PHP for web ui.
- 961
0
votes
2
answers
128
views
Python mysqldb data
I have a php form which saves these values to the database:
id
rand (a randomly generated string)
x_val
y_val
I am calling these values back from database in a python program using mysqldb:
import ...
- 7,338
1
vote
2
answers
495
views
Python's MySQLdb slow! using 'SSCurso'r vs PHP's 'mysql_fetch_assoc'
I need to go over an entire table in Python.
I am using MySQLdb via 'SSCursor' and it is much slower than PHP's stuff.
PHP 5.3.5
$result = mysql_query("SELECT * FROM anytable");
while($row = ...
- 47