18,954 Topics
I have a software which demands this extensions on server , i tried by using xampp but failed. In the beginning it demands zend Guard Loader . I have tried to install on xampp but it can't be installed. I have already read this topic and follow and many topics …
I'm facing a database connection error in my MySQL-based application. The credentials are correct, but I keep getting: ERROR 1045 (28000): Access denied for user 'admin'@'localhost' Is it a privilege issue, host misconfiguration, or MySQL version mismatch? Seeking expert developers in the USA to resolve and optimize the database connection.
Hi, I have a question about web hosting. I want to purchase a hosting package from web.com, and they have mysql database. But the web hosting package says i can only have 300mb, but the issue is theres a 25 in front of the 300mb, it looks like this 25 …
I know that `SQL_CALC_FOUND_ROWS` has been deprecated, but I was just wondering if anyone knows why? It was so handy, even if slightly less performant than running the query twice (once with and once without the `LIMIT` clause).
An interesting lesson learned today: A table's auto-increment value gets cached in MySQL. If you run `ALTER TABLE table_name AUTO_INCREMENT = 1;` and nothing seemingly happens, you have to reconnect the client.
How can I identify and delete unused MySQL indexes? I have a large table that has somehow accumulated way too many indexes over the years, and I'd now like to identify and delete indexes that are no longer used by the application.
I want to run a query, of course more involved, but something roughly similar to: DELETE from table WHERE id IN ( SELECT id FROM table WHERE ... ) Doing that gives me an error message that I can't delete from the same table as I'm selecting from in a …
Our MySQL servers are behind our VPN and do not have public-facing IPs. Is there any benefit to connecting to them securely over SSL? I keep reading that it's recommended, but the only thing I can think of is that it will cause extra latency when establishing a connection?
A few years ago there was this absolutely **gigantic** spider on our bedroom ceiling above our bed. Let me tell you, that was terrifyingly strange. However, I think what still stands out in my memory most of all was the [MySQL Packets out of order](https://www.daniweb.com/programming/web-development/threads/540571/mysql-packets-out-of-order) error message that I kept …
I ran into a bit of a snag in my code, and I'm trying to make heads or tails as to whether this will work. From within my PHP script, can I write to a database using a MySQL connection in the middle of a transaction with a different connection? …
After the customer fills the form, the form data is sent to mysql and an email gets sent to me with the last form data that the customer submitted. But, the email "last mysql data" is not going as inline text. Please help me. Sample code is given below. ` …
Hi guys/gals! I've read through a lot, great site but I'm stuck and have started pulling out teeth:( I would like to selectively display markers (that change everyday) on a Google map, using a a couple of checkboxes (areacode)and a selection list (prices). [CODE] <!--Based off of code from: http://tips4php.net/2010/10/use-php-mysql-and-google-map-api-v3-for-displaying-data-on-map/--> …
A script that was working fine on 100 records per batch choked when I fed it 1,000 records. It gave: mysql.connector.errors.OperationalError: 1040 (08004): Too many connections So I went ahead and made sure to connect.close() everywhere that I opened a connection, and the script made it much further but eventually …
Hi I'm trying to make a system for someone I know and I have a customers page with a link to view orders and created another page to display the orders made for that specific customer name, I have got some php code on the page but it looks like …
Need webmaster fluent in php/mysql to make ongoing updates to my fairly simple e-commerce website. Please advise hourly rate and availability.
This week I'm working on the data warehousing capabilities of my application. Now most people here who have built more than a couple of applications can tell you how useful it is to include a datestamp on records or requests as they come in. The advantages are numerous. So much …
Hello Gang! I'm grateful once again for the advice to use MySQL over Postgres. It's been a pretty smooth experience so far. Unfortunately I had to migrate to a different host and have been getting an undefined variable error. Mysql is Running. I used the package manager to get python-mysql.connector …
   here is three Sql table name of them - 1. orders 2.order_item 3. target_value I am trying Two way here is may two code : 1 SELECT I.target_id as Iid, I.target_date as Idate, I.customer_name as Icust, I.target_product as Icat, I.target_pay as Ipay, I.target_rec as Irec, I.active as …
Hi People, I am having displaying categories and subcategories: i have one table where i ise parentid in the same table as: pid, cat, parentid, details i am able to list all cats/sub cats but i want to display as like this: animal » doggie » companion but my list …
i need code
Recently made a decision for an app I'm working on to accumulate data in batches AND THEN to insert it into the database with one statement rather than adding 1,000 records through one thousand separate inserts. Is this done better through file or memory? If I write the segments of …
Hey Gang! I'm hitting a point with my (python/mysql/linux) app for processing large amounts of network records where I need to make a design decision. I definitely want my app to have high performance. Because optimization as a skill set is so rare there is no reason not to employ …
I was consistently receiving MySQL "Packets out of order" error messages when attempting to connect to MySQL, mostly on my AJAX pages, but I couldn't attribute it to anything or reproduce it in any way. I did notice, however, that when switching MySQL persistent connections from on to off, the …
The advent of large language models (LLM) has replaced complex scripts with natural language for automating various tasks. You can now use LLM to interact with your databases using natural language, which makes life easier for people who do not have sufficient SQL knowledge. In this article, you will learn …
Hello I am trying to query a database to show records only for the current user using variable I get the correct data but only 1 row with results any guidance? // Query database to retrieve records associated with the user $sql = "SELECT * FROM table_name WHERE variable_name = …
What are some ways to improve MySQL performance on queries against large tables that include the HAVING BY clause. It's my understanding that anything in there doesn't benefit from table indexes.
Hello webmasters, I am currently building a template that I am going to sell on different websites like Codester and CodeGrape. I want to build a business directory. Here is what I have come up with ... 1. users can register and add listings. 2. admin can create categories for …
Hey Gang! OK today I am having trouble with my transaction processing application implemented in python/MySQL. Here is some "working" testing code. import psycopg2 from psycopg2 import Error import binascii from binascii import unhexlify import mysql.connector as mysql sql='''CREATE PROCEDURE testprocedure(OUT tacos INT) BEGIN show tables; SET tacos := 1 …
Hey! I've been asked to store some data from a client in mysql in an encoded format using python. Nothing could be easier, right? I will later need to decode the same data using mysql exclusively. Given that constraint, I thought that base64 would be the go to since nearly …
Security matters. How can I guard against things like SQL injection or cross-site scripting? It will be really helpful if somebody could help.
Hey guys, so I've been trying to create a website that allows users to update and delete records through the database I've set up in SQLyog. In my update confirmation file I've added location theme description to be updated and changed for all users. but for some reason its unable …
I'm working on an SQL query for a complex reporting system that involves multiple tables and joins. However, the query's performance is not meeting my expectations, and I suspect that the way I've structured my joins might be inefficient. Here's a simplified version of my query: SELECT orders.order_id, customers.customer_name, products.product_name, …
Sometimes you need to delete duplicate rows in a database :) In the future, set UNIQUE keys when you need them :) In the example below, we have a table appropriately named `TABLE_NAME` and there are multiple rows that have the same value for the `duplicate_field` field. In this example, …
Anyone seen or had this happen before, whenever I add, edit or delete in this datable. It only does this when I add the js pagination\search 
Hello, Got questions on Sql and Php Prepared Statements. How would you check whether the SQL managed to update a row or not ? Which one of the following lines would you add the IF condition to ? 1). mysqli_stmt_execute() 2). mysqli_stmt_affected_rows() Which of the following examples A-D are a …
Hello There, Look at this PAGINATION I built. This script I built from scratch and is working fine to query my Mysql DB and show results. But I need your feed-back to know if I managed to use the functions in the correct order or not. //FUNCTIONS IN USE TO …
Hello! I have created a project on Android studio, and i use java as langage, i want to create a biometric system with fingerprint, what i mean is that i want to use android fingerprint device to get fingerprint id and store it in MySQL with some personal informations, so …
Hiya, I need to learn the SQL query that counts all the points from more than one column and orders the matching rows based on most points in descending order. EXAMPLE 1: I do a keyword search for "mobile phone tutorial apps". Note 4 words. Sql should find all the …
PHP Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in <?php include("header.php"); $_SESSION['loc'] = "viewkeyowners.php"; if ($_SESSION['loggedin'] <> 1) { header("Location: logintest.php"); exit(); } //this is done because if user closes a tab/page, and logs back in(still in session), it would redirect to the last opened tab/page function …
So... I have a fully working code, but my boss asked me to add a button that downloads the table in excel format with the values from the database and I was like, *I can do that?* I also asked chatGPT but it has a character limit so it never …
I am having trouble showing the export buttons, it works perfectly if the data is not fetched from database with the basic example however they are not showing with my php code, I have included the script and necessarry files from https://live.datatables.net/kugajayu/1/edit. Please help, below is my script. <!DOCTYPE html> …
Hi Wanted to utilize the php/mysql insert into the FPDI pdf export tool. I have it working just as plain text which is nice. But, i'd like to to have mysql place db entries into it. I've declared my sql connection, just using dreamweaver at the moment. I'm struggling to …
Hiya, It seems to me that if I put a condition on ```` mysqli_stmt_fetch($stmt); ```` to check if user credentials was ok enough for the data to be fetched, then the whole purpose of using the following function is defeated. ```` password_verify() ```` This is what I mean .. ```` …
I have a database which contains authors and books. Some of those authors and books contain slashes in the name or title fields. When I query the database for authors, it matches just fine, with or without slashes. When I query books, however, it only finds books without slashes in …
I need to check db for matching user credential on login script. There must be atleast one matching row. Else, script should alert user not registered. Need to check the db using the function ````mysqli_stmt_num_rows()````. Assignment is to list all the various valid ways this function can be used to …
Helle Fellow Programmers! Unlike last time where I was checking for matching rows count using mysqli_stmt_rows_count(): https://www.daniweb.com/programming/web-development/threads/539306/login-with-prepared-statements-mysqli-stmt-num-rows-function On this thread, I am checking for matching rows count using Sql's COUNT function. This means, both threads are not same so mods do not close them. Issue is, on both threads, no …
Hiya, Which of these IF CONDITION codes are valid ? And can you rank the valid ones according to your choice by giving reasons to your choices ? Thanks! 1. ```` $conn = mysqli_connect("localhost","root","","buzz"); $sql = "INSERT into users (username,email) VALUES (?,?)"; if($stmt = mysqli_prepare($conn,$sql)) { mysqli_stmt_bind_param($stmt,"ss",$_POST[username'],$_POST['email']); if(!mysqli_stmt_execute($stmt)) //FIRST CHOICE …
What are some essential skills every web developer should have?
I want to populate report in browser, i prepare this report in i-net clear report, and report file having extension of rpt. I also want to pass parameter
Hello, I do not see $data defined, so what is it ? ```` function prepared_insert($conn, $table, $data) { $keys = array_keys($data); $keys = array_map('escape_mysql_identifier', $keys); $fields = implode(",", $keys); $table = escape_mysql_identifier($table); $placeholders = str_repeat('?,', count($keys) - 1) . '?'; $sql = "INSERT INTO $table ($fields) VALUES ($placeholders)"; prepared_query($conn, $sql, …
The End.