7,368 Topics

Member Avatar for
Member Avatar for FarrisFahad

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 …

Member Avatar for antwanlee
0
21
Member Avatar for Dani

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.

Member Avatar for Reverend Jim
0
173
Member Avatar for nander

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 = …

0
31
Member Avatar for Dmytro_2
Member Avatar for Reverend Jim
-2
12
Member Avatar for cored0mp

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 …

Member Avatar for Dani
1
25
Member Avatar for cored0mp

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 …

Member Avatar for cored0mp
2
151
Member Avatar for jayashree10

Security matters. How can I guard against things like SQL injection or cross-site scripting? It will be really helpful if somebody could help.

Member Avatar for Dani
0
38
Member Avatar for Cameron_12

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 …

Member Avatar for AndreRet
3
127
Member Avatar for Vandiun

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, …

Member Avatar for DGPickett
2
114
Member Avatar for Dani

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, …

Member Avatar for Usamatamimi
4
4K
Member Avatar for Dani

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 …

Member Avatar for Dani
4
267
Member Avatar for Abhishek Upadhy_1

Web development refers to the creating, building, and maintaining of websites. It includes aspects such as web design, web publishing, web programming, and database management. It is the creation of an application that works over the internet i.e. websites.

Member Avatar for webdesing
-1
110
Member Avatar for nander

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 ![TableDuplicate.JPG](https://static.daniweb.com/attachments/4/792aec684975bfed8e5e50cce0835187.JPG)

1
42
Member Avatar for borobhaisab

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 …

Member Avatar for pritaeas
0
35
Member Avatar for borobhaisab

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 …

Member Avatar for Dani
0
180
Member Avatar for nander

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 …

Member Avatar for Dani
0
67
Member Avatar for Mindmade

What are the top 3 most important things to consider for a successful ecommerce website?

Member Avatar for acs_cobra
-1
118
Member Avatar for Pranay_2

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> …

Member Avatar for Pranay_2
0
809
Member Avatar for Cindy_11

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 …

Member Avatar for Dani
1
109
Member Avatar for borobhaisab

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 …

Member Avatar for Dani
0
39
Member Avatar for borobhaisab

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 …

Member Avatar for borobhaisab
0
124
Member Avatar for farman786
Member Avatar for Dani
0
49
Member Avatar for jmconsultants

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

Member Avatar for rproffitt
0
54
Member Avatar for borobhaisab

Howdy once more, Just got another question on Sql and Php Prepared Statement. How would you confirm a successful row insertion to a mysql table ? Which one of the following lines would you add the IF condition to in order to check insertion successful or not ? 1). mysqli_stmt_execute() …

Member Avatar for borobhaisab
0
90
Member Avatar for David_140

I am not that much of an expert in PHP as it has been few months since I started playing with it. Currently I am working on creating a basic CRUD operation in PHP. I follow this tutorial on CRUD in PHP (https://www.cloudways.com/blog/execute-crud-in-mysql-php/ ) to create it on a local …

Member Avatar for Rose_17
0
478
Member Avatar for Mallika_2

create table customer ( cname char(20) not null, street char(30), city char(30), primary key(cname) ) create table branch create table account ( bname char(15) not null, bcity char(30), assets integer, primary key(bname), check(assets>0) ) ( account # char(10) not null, ( bname char(15), balance integer, primary key(account#) forigen key (bname) …

Member Avatar for pritaeas
0
27
Member Avatar for IQBAL_13

Thank you for looking at this problem, details are all below. Below is the code <form style="overflow: hidden;" method="post"> <input type="checkbox" aria-label="Checkbox for following text input" name="kursus[]" value="<?php echo $row['IDKursus']; ?>"> <div class="d-flex justify-content-between mt-3"> <button type="submit" class="btn btn-success" name="daftar_kursus">Daftar Kursus</button> <button type="reset" class="btn btn-primary">Reset</button> </div> </form> if (isset($_REQUEST['daftar_kursus'])) { …

Member Avatar for Dani
0
147
Member Avatar for Rohit_63

Hey everyone, I have started a new position as an HR recruiter in a Website Development Company, can you guys suggest to me some questions I can ask fresher as well as experienced candidates?

Member Avatar for Dani
0
51
Member Avatar for IQBAL_13

I have a programming code problem, I need help to solve the problem. How to explode data array using MYSQL and using NOT IN. The program code is below <form style="overflow: hidden;" method="post"> <div class="table-responsive"> <?php $sql = "SELECT * FROM kursus WHERE KodKursus NOT IN (SELECT kursusList FROM pensyarahkursus …

Member Avatar for Dani
0
129
Member Avatar for Rico_2

hii, i want to ask how to loop this array for menu like in images public $list = [ [ 'id' => 'dashboard', 'text' => 'Dashboard', 'icon' => 'feather-home', ], [ 'id' => 'data_tables', 'text' => 'DataTables', 'icon' => 'feather-layers', 'children' => [ ['id' => 'basic', "text" => "Basic"], ['id' …

Member Avatar for AndrisP
0
121

The End.