1,065 Topics
 | |
 | 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 everyone, I am Emmanuel Katto. I'm building a high-traffic web application that requires fast and efficient data retrieval from a relational database. To improve performance, I'm considering implementing a caching layer using Redis. But, I'm not sure about the best approach to design and integrate the caching layer into …  |
| | Project Preparation. Business Blueprint. Realization  |
| | 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, …  |
| | An equipment company wishes to create a database to support the hiring of tools and machinery to clients. The company has three types of equipment: power tools, such as drills and vacuum cleaners, plants such as excavators and scaffolding. Each piece of equipment is identified by a number. Power tools … |
| | **I have attached all of the coding needed** I'm using PHP to design a website. The problem that I am facing is that, the button on the add products page isn't taking the inputs and putting them on the products list page. I'm wondering what I can do to get … |
 | The benefits of online shopping need no elaboration anymore. Billions of people rely on online shopping service providers across the world. In fact, the e-commerce platforms proved to be saviors for people during the months of lockdown. Developing an online store can be profitable for sure but choosing the right … |
| | I am interested in technology, however I do not wish to go to university and after stumbling upon the MIT Challenge, I have taken it as a proof of concept. Clearly education is changing, and I would like to take a less traditional route. But before I go too far, … |
| | Any programming language or software that can help in database design and manipulation |
 | ## Introduction ## This tutorial teaches you how to implement the Type-safe Builder pattern using Kotlin. This pattern allows developers to create declarative and concise DSLs. Our implementation will be a Burger Builder that enables our users to create Burger objects expressively. ## Goals ## At the end of the … |
 | [ATTACH=RIGHT]20145[/ATTACH][B]Building your first DYNAMIC Database application. This is Part One of a four part tutorial on how to install and use your database, Part Two will teach you how to build successful connections and Part Three will teach you how to build database interaction and management of your databases.[/B] There … |
 | Dani Horowitz remains as passionate about our online community today as she was back in February 2002 when, while pursuing a computer science degree on Long Island, NY, she founded DaniWeb. Fast forward to now, and an amazing half a billion visitors later, DaniWeb has become a vibrant community of …  |
| | Hi All, I am going to write a small inventory tracking app for a small company. What they need is only to keep track goods in, goods out, supplier, customer, and purchase price and sell price so we are able to calculate purchase price, sales price, and stock value. [LIST=1] … |
| | Greetings. I am making some Point of Sales system but I have a little problem with the database design. You see, there is this list of products that will be added to a cart. What I need is when these items are added in the cart and then sold, it … |
| | I am making a small example of adding, editing, deleting and saving the treeView directory tree into the SQL Server database, what must I design to store in the database and write code ? |
| | I have dynamic page which is loading and preview page from database retrieved values. I did this with successfully. I want to remove parameters from page url. Note that I only used one parameter in url. My url is something like this. (with parameters) http://ads/ad?this=daihatsu-boon-m700s-new-design-2016-nugegoda-2019-04-05-22-49-04 I tried to remove parameters … |
 | hello everyone im taking database course this year and it's my first time to take it so i need help how to draw a ERD for following busniess case AND IF there many to many relation how i can establish a new relation ! Entity (Artist ) Attribute : death … |
 | I need a help about this i have a log in form design Username Password And my database table Username Password Usertype I want that if admin will login admin form will show. While if employee will log in emlpoyee form will show. How to do that in code. Im …  |
 | Dear Frien, I am working in C# .... I nedd Help/.] I created FROM1 which has DATAGRIDVIEW and fetched data from Database,and on the Form2 has Crystal Report Design , how can transfer data from Datagrideview of FORM1 to Crystal Report of FORM2.......... Code is bellow-: private void btn_CrtRep_Click(object sender, … |
 | Hi, I was hoping someone could help me. I'm trying to create a database to track exam results of students through 4 years of university study. Each year, students sit up to 10 different exams which have different weighting allocated to the results to determine a final aggregate result. I …  |
 | Hello to all, I am working on a project of job posting. There is a table in database. I have a html form and postcode.php (there will be code) , I am facing a problem with this code. **My html form code:-** <form name="posting" action="postcode.php"> <table class="table"> <h4>Job Details: <span>specify …  |
| | Hi All, I'm currently designing a website for my business and would like to have a system that pulls products from my database via PHP and adds them to my products section, but I'm unable to find anything that explains how to do it for the kind of setup I … |
| | his is an example of creating a semi-dynamic pie chart without the use of server-side imaging libraries [url]http://www.surfare.net/~toolman/temp/diagram.html[/url] CSS Diagrams Things to Do With CSS When You’re Bored at Work [url]http://komodomedia.com/blog/index.php/2005/08/24/creating-a-star-rater-using-css/[/url] Star Rater Creating a Star Rater using CSS [url]http://komodomedia.com/blog/index.php/2006/01/09/css-star-rating-part-deux/[/url] CSS Star Rating CSS Star Rating Part Deux [url]http://www.jluvip.com/works/css/starvote/index2-1.html[/url] Star …  |
 | I am working on a table that will hold batch data. The table will have a BatchDate column as a DateTime type. I'm considering adding a column for BatchYear as an integer and BatchPeriod (which could be a week number, a month number or a quarter number) as an integer, … |
| | I'm a beginner with databases and I'm trying to design a database in Microsoft Access that will allow users to make bookings for fitness classes. There are two slots per day that these classes can be booked for and each session can cater for 10 people. What I am struggling …  |
 | Hi to all! I made a class named “Database” I called openOrCreateDatabase in in its constructor but it was giving error. Then I searched on internet and got a solution that in case of non activity class I should also pass context. Then I passed context but then I am … |
| | Hi, I am developing a mobile app for a health care institution. I'd like to get a suggestion on how to approach my database design. There are many user types of this app; residents, nurse, and general-staff. The "resident" has many information that other types don't have; unit_number, food_allergy, emergency_contact, … |
 | Hey fellas. I've been using Windows as my main OS since I sat on an PC with win 95. Now I think is time to finally change to Linux! The main reason I didn't change sooner was because the .NET dev env, but now there's Mono. So, I really would …  |
| | Database systems and Administration Scenario: PEC offers several programs. Each program is supervised / chaired by a Head of the department (HoD) who is a lecturer. One HoD can lead only one program. There are several departments for each program. Many modules are offered by each department. Few departments are …  |
 | Dear folks , I've already created some website from scratch with html and javascript , php etc. On the other hand i also created websites with wordpress. I find the freedom in creating from scratch grandiose to say at least but wordpress to me has the benefits of professionally looking …  |
| | I have a form on our website that a user can fill out for custom product. I want the form data to be 1) stored into a mysql database AND after storing said data, 2) email the same data to our sales department. 1) The form data DOES get stored … |
| | I have been a happy user of TomTom satnav products since they first hit the market some ten years ago now. For the most part, that has meant dedicated hardware for in-car use. However, when I last [reviewed the TomTom app for the iPhone here at DaniWeb back in 2010](http://www.daniweb.com/hardware-and-software/tablets-and-mobile-devices/reviews/333687/edit-your-own-satnav-maps-with-tomtom-for-iphone) …  |
 | As the title says, anyone else noticing the activity on DaniWeb suddenly dropping? I usually check the Database and Software Developing sections in the morning. The Database one for awhile was getting a few new topics at least a day, but all of a sudden, it seems to have almost … |
| | Howdy All, I'm creating a database for UFO sightings and would appreciate some feedback or suggestions. Yes I know, strange topic. Some background info so that the problem is understood: I'm extracting data from several large UFO database catalogs, news articles, and other miscellaneous sources, so that the data can …  |
| | **Bold Text Here**Hi there I'm just wondering what the best or a good table layout would be for a little project I'm trying to do at work. I work at a temp to perm agency where companies use us for the probationary peroid of employement and then hire the workers … |
 | The Scenario Wyndham Summer Houses are a construction company based in US. The company specialize in building summer houses and outbuildings such as sheds. They want you to design and implement a database that meets the requirements for their data. These requirements are specified in this scenario and the examples … |
| | Choose a problem that interests you and which can be solved with a program. This problem will be the foundation for your homework assignments and presentation; this is the problem for which you will design a solution during this course. Your chosen problem should be of reasonable complexity. If a …  |
| | ## Contents ## Overview 1. Alternatives to Deprecated mysql_* Functions 2. SQL Injection: What to do with $_POST and $_GET variables 3. How to Insert Tablenames and Fieldnames Properly 4. What to do With Dynamic Values? 5. How to Use Aggregate Functions (COUNT, SUM, MIN etc) 6. How to Paginate …  |
| | How can i design a simple php site with a database like facebook  |
| | Recently in an interview I was asked to design a "send invitation for an appointment to multiple contacts in a company". (Something similar to creating an Appointment in Outlook) Here is what I came up with, I would really appreciate some feedback, suggestions, questions. So, after asking few questions, the … |
| | Dear all, i am trying to design a purchase form in which i wish to use jtable , when i press any character into the cell it should open a jlist with populated values from database and which let me select only one item from there and get the selected … |
| | Hello, I have a little problem , I am currently developing an application with PHP and MySQL , this application should show me more persons, each person must have one or more services and each service can be inversely associated with several people, for this I have 2 tables, one … |
| | Hi I am building this website for a small hotel. The user interface is ready and I have a form as shown below: If I click on submit I can insert the data from the form into the database.My question is where do I go from here? Is my database … |
| | Parse error: syntax error, unexpected '{' in E:\FYP\DB\TWAMPd\htdocs\web\edit_infos.php on line 58 I can't update the information page . Can someone help me? <?php include('config.php'); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link href="<?php echo $design; ?>/style.css" rel="stylesheet" title="Style" /> <style type="text/css"> … |
| | Hi, Please I'm new in database and I need your help, I'm working on my database project and before to continue I would like to be sure that my NORMALIZATION 3NF and my ER Diagram are correct. **Normalization 3NF** DESIGN PARTS SPECIFIED IN DESIGN PARTS PARTS USED AS SPECIFIED IN … |
 | Every year or so for the past couple of decades I've seen new products appear that claim to let you create software without having to know how to code. And every time the next one comes out, I roll my eyes, because they always fail to deliver as promised. Usually … |
| | Hi, sorry for my newbie question but I can't understand what is the different between Logical and Conceptual database design. Can you provide me with some samples for those two types of design? Also what design is generated with MySQL Workbench for example when you import database schema? Is it … |
| | Hello... Can anybody explain me Ebay or something like that database structur.Do All Item Categoris Store in One Table(with Differnt types)or do they story in many table .ex books for one table,jewellery in another table and so on.if they are store in differnt tables how do we search them ? … |
| | Hi, I am new to yii and php and i want to deleveop a database design for school exam time table and maintain the time table for school management. How can I procced the same? Please help me? :( |
| | On my view I am trying to get it so if my input link[] is next to the upload button then that link post will be inserted into the database with image I use codeigniter for a mvc frame work. I can insert the links and images fine, but the … |
The End.