Details about how to use the PHP PDO library for data manipulation
Mình cần 01 bạn có kinh nghiệm ghép và đồng bộ 100% mogodb với wordpress, tối ưu việc lưu trữ và tốc độ truy xuất lữ liệu cho một version của site [đăng nhập để xem URL] cho mình biết luôn giải pháp và hướng triển khai công việc khi "bid" Lưu ý: Giữ liên lạc và đúng hẹn Chỉ nhận việc k...
My website has been deactivated by my host. They told me this in a chat session: "Please remove unwanted script s/ DB queries which is causing high CPU utilization. You need to secure your websites. Also optimize your DB & websites for better performance. Reset all password and add captcha to contact forms and pages. And keep all plugins up to date
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
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 !
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...
...download the app, so you will need to be using mac and be comfort with working with react native for iOS. You also will get a "test" firebase account if you need to change DB-structor and testing. Please only bid if you fix you can solve this problem. If you got a solution and maybe need to do more work to fix it then i small fix we can diccuss about
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.
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/[đăng nhập để xem URL]:25 [0x00007fae60e15220] query() /srv/[đăng nhập để xem URL]:84 [0x00007fae60e150f0] query() /srv/[đăng nhập để xem 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 [đăng nhập để xem URL], SUM([đăng nhập để xem URL] * [đăng nhập để xem URL]) as price FROM Customers INNER JOIN Invoice ON [đăng nhập để xem URL] = [đăng nhập để xem URL] INNER JOIN InvoiceDetail ON [đăng nhập để xem URL] = [đăng nhập để xem URL] group BY [đăng nhập để xem URL] I CAN"T SEEM TO GET THE Customers.Firstname...etc... because of the SUM... I can get one or the other but no...
I have a request table I need a few queries done on. This is an excel sheet. I need to find out quick analytics on our user behavior. It would be excellent to get the %, numbers and graphs depicting results.
Hi, I need to upload data from an excel to a database by creating a new table, and from there transfer some data to 2 sql tables from that database. More details in the attached excel file. Cosmin
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...
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.
We're looking for a programmer that can develop a tool that read some fields from a DB and from a local excel and use such values to fill a .docx template and convert it into a PDF/A
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 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 ...
...to be stored in the linking table) - zero or more pictures (stored in DB) with the ability to mark one (per item) as the primary picture in the table linking items to pictures) Each Guild has - name Each crafter has - ability to log in as self - ability to view items in DB and mark that they are able to create it, including a short text note so
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