Details about how to use the PHP PDO library for data manipulation
Saya...panjang dari Chart of Account bisa dinamis tanpa perlu merubah coding program. Yang saya perlukan adalah : 1. Desain database untuk Financial Accounting (mySQL based) 2. Query untuk menghasilkan laporan yang diinginkan : - Laporan Jurnal - Laporan General Ledger - Laporan Trial Balance - Laporan Balance Sheet - Laporan Profit & Loss
we have a form for insert data, we need on submit to create a query before to process to check if data exist and IF exist show a modal with alert and name of data else process
I need someone freelancer to help me to fix the query below: select count(distinct p.products_id) as total from (products p) left join manufacturers m on (m.manufacturers_id=p.manufacturers_id) left join specials s on p.products_id = s.products_id left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id left join zones_to_geo_zones gz on
We need a part time resource on Java, Apache camel with mongo db to give support for US people on weekdays morning around 90 minutes IST 6 00 am to 8 00 am will provide 20000 per month minimum 4 years of experienced candidate on all the technologies mentioned above only eligible for the bid.
I have a PDO script and I need to Select from db and add some conditions I will pay €4 per hour. You must to have downloaded "chrome remote" for remotely work. Add in your description: can do remote !
Currently running NexusDB on Delphi 2007 compiled app. We are looking to test out Azure Cosmos DB to see if we get better results. requirements from developer Must be familiar with Azure and Cosmos DB Have their own Azure account to demonstrate DEMO before full deployment on our side.
Hi All I look for someone to build me an access database for Education Management System. The database with keep record of [login to view URL] [login to view URL] Records eg. Facilities, Student,Teachers, Budgets [login to view URL] Regords [login to view URL], Family Details, Leave For a more details project info please contact me
Query on Office 365 Excel Online to export the data. No bootstrapping. Need to use Dojo or jQuery, or find a way to get it into that format for me to use.
Project Duration: 1 Hour Project Overview When trying to run this query: SET `description` = REPLACE(`description`, 'â€™', ''') WHERE `description` like 'â€™%' We get the following error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right synt...
I am currently getting a 500 error on my website. I traced it back to an SQL query (SELECT XYZ FROM zip_code INNER JOIN city ON zip_code.city_id = city.city_id INNER JOIN region ON city.region_id = region.region_id INNER JOIN country ON region.country_id = country.country_id). The INNER JOIN country ON region.country_id = country.country_id part of
Scrape from a google spreadsheet into a database on Azure or EC2, and create a UI for non-technical people to query. Make sure certain users can add but cannot delete data from the db. Also the UI should sanitize and validate the data before entering it int the database.
We Have an ERP Project written in Delphi3 and using Paradox Tables with Borland BDE. Delphi code is more than 250k lines and DB have more than 100 Tables. The project is Running on Win2008R2 Server. Clients (around 15) are accessing the project through Terminal Server. All is Running but getting slowly with time. Some Paradox Tables have around 2GB
Schema is developed from online software and need tables added to PostgresSQL and ensure PostGIS is working correctly (for the GIS spatial data). If not working correctly, then you will need to document and provide information on how you made it work. this PostgreSQL/PostGIS is on a Windows 10 Machine. This project needs to be completed within 24 hours of award to freelancer.
...in site taking more than 10sec to load : [0x00007fae60e15320] query() /srv/[login to view URL]:25 [0x00007fae60e15220] query() /srv/[login to view URL]:84 [0x00007fae60e150f0] query() /srv/[login to view URL]
I have a quick issue I just need some advice on Fixing or a slight change of code. JSON Response is being presented to the app however, it won't append to the Dictionary that I'm trying to use. Paying a maximum of $30AUD for this as it is a quick code fix. Just needs a simple fix.
I need to solution for the Client information collection
Select rows to display the columns: name of product/service assign alias as “ProductService”, quantity sold of product (invoice detail), employeeID who is assigned to the invoice; where the employee ID equals 1; sort by name of product/service ascending.
SELECT [login to view URL], SUM([login to view URL] * [login to view URL]) as price FROM Customers INNER JOIN Invoice ON [login to view URL] = [login to view URL] INNER JOIN InvoiceDetail ON [login to view URL] = [login to view URL] group BY [login to view URL] I CAN"T SEEM TO GET THE Customers.Firstname...etc... because of the SUM... I can get one or the other but not both...
This work involves a pdf file of shipping labels with multiple pages that needs to be sorted based on a reference number in a text file that matches a label/page within a pdf file.. ie A list of alpha numeric letters/numbers are given vertically in a text file that need to be searched within the pdf file and as the pdf file finds the queries within its pages (which is one per page), it creates a n...
Scrap a webpage and store the table in mysql as it is. search with filter of the tables. one click copy the column text and export in excel. very simple. just need to detect td tags. no other table there so no need extra work for select table.
Jenkins pipeline project build with external HSQLDB. Data created on hsqldb. I want to write groovy script on Jenkins pipeline for, Step1: Make a zip folder of data folder on hsqldb. Step 2: Clean data folder from hsqldb.
Write an application that connects to the CoffeeDB database and displays a JList component. The JList component should display a list of customers with unpaid orders. When the user clicks on a customer, the application should display a summary of all the unpaid orders for that customer.
...experience in C#, .Net, SQL Server, and XAML. We need to create 3 small reports, and for each of them we need to get: a. SQL query/SP that will fetch the data from tables. b. C# code for the Web Services which will fetch the data from DB and provide them as a data structure c. XAML code for one page of the mobile app that will call the Web Service, consume
I need you to build a landing page. budget 600 Rs
We are in need to keep the records of cus...they buy, the sales that are recorded as well as the purchases, and the time and date these took place. The OS is windows, and I'd like it to be SQL server 2016. We need the db to have some restrictions such as mandatory fields filled with data. The current data we have is about 200 customers and 500 items.
ECMS. ECMS is an on online contrat management system which makes it easy to manage contracts. Main features. Technologies PHP. Mysql DB Java Script The system will allow for the upload of contracts creation of routes for approvals. The system should allow for the digital signatures to be appeneded to the contract once the approver approves his part
I need help in properly connecting to my msql db on my server. I keep on encountering the "Access Denied" thing.
I NEED A APP APP IN DIFFRENT PRIZE . EVERY DAY WIN A PRIZE. PRIZE IN WINNER GURANTED IN PUBLIC PRIZE TICKET PRIZE COST DIVIDED IN ADMIN OPTION APP REGISTRATION EVERY PERSON WITH GOOGLE EMAIL OR FACBOOK OR MOBILE NO IF ANY PERSON SHARE APP GET AND JOIN ANY PERSON PER PERSON 10 POINT WIN IF JOIN 10 PERSON GET 100 POINT MEAN RS 2 & USE IN NUMBER IN PRIZE TICKET ADD MONEY FEAUTRE ...
I have a query in place and would like to create a form with drop down boxes that allows the user to run the query based on the criteria they select. I have started the form but am struggling with linking the combo boxes to the query.
Hi, We have a fairly simple MySQL database that stores data from API calls made for customer data, we added a few things on and it's really slow now, I'm not sure the structure of it is correct now, I need an expert to look at it and fine tune it / make changes so it's not so slow. Please message me for details but it's not very large, maybe 70MB total size. I can send it t...
...create Mongodb query. It's maybe not the most complex query you ever find but we have not too much experience in MongodDB and how to use all this features. The query will cover all the basis filters and the use of the geospatial feature (just a simple search of maxdistance usign coordinates, we already have this). Basically, the query has to: Search