Using PHP PDO to manage data in MySQL
Details about how to use the PHP PDO library for data manipulation
Database programming falls into three categories: maintenance, data processing and programming. The programming portion is the creation of bespoke database for an application that allows for the application to interact with it. The bulk of work for a database programmer however, is the maintenance. Troubleshooting issues, recovering data and providing technical support provide a continuous employment for database professionals.
Processing the data is the importing, organizing and translating of data into the database. The programmer will write scripts to this effect, and perform daily checks on the database. This provides feedback in terms of any maintenance that is required.
Hire Database ProgrammersWe use Caspio and want to develop a series of web forms for clients to use as reports and team members to use to complete reports. We have one form in a wire frame format but require the development We are on a Caspio GROW account and have developed our own authentications for our dashboard. We want all our business tools housed in Caspio and are currently working on a KPI Dashboard, Budget tra...
Hello, I know how to design, the problem is the lack of time finding the products. I need a guy with RFID knowledge to discuss a PoC (help me define parts). I need to have a conversation with this person, I would prefer a videocall or something like that. I believe 1 or 2 hours is good for defining this. Thank you.
Hello, I know how to design, the problem is the lack of time finding the products. I need a guy with RFID knowledge to discuss a PoC (help me define parts). I need to have a conversation with this person, I would prefer a videocall or something like that. I believe 1 or 2 hours is good for defining this. Thank you.
Hello, I know how to design, the problem is the lack of time finding the products. I need a guy with RFID knowledge to discuss a PoC (help me define parts). I need to have a conversation with this person, I would prefer a videocall or something like that. I believe 1 or 2 hours is good for defining this. Thank you.
Hello, I know how to design, the problem is the lack of time finding the products. I need a guy with RFID knowledge to discuss a PoC (help me define parts). I need to have a conversation with this person, I would prefer a videocall or something like that. I believe 1 or 2 hours is good for defining this. Thank you.
People register for a course using Jotform, their data needs to be imported into the Moodle user database and they then need to be registered with the course they signed up for. Moodle is hosted so don't have server access to solve it this way. Happy to use tools such a Zapier or [login to view URL] if suitable, but would like to get the "recipe" for this to work.
i need the Oracle Database Expert Needed for multiple job. Details will be discussed
i need the Oracle Database Expert Needed for multiple job. Details will be discussed
This job involves diagnosing and correcting an integration issue between a legacy data forwarding application and an Oracle 10g database. The software is written in C# and contains a simple table query that is used to forward records to another system. The software is currently encountering a ORA-12541 / no listener error and is unable to retrieve the data. Remote access to the system is not avail...
Need someone to convert an existing local storage database (sembast) and make it work online (sembast_web). No UI or other logic needed.
Need a database expert, to Construct an ER diagram in UML. Represent the schema in textual form Mark Primary keys, foreign keys.. etc.
Need a database expert, to Construct an ER diagram in UML. Represent the schema in textual form Mark Primary keys, foreign keys.. etc.
Need to develop Delivery and Tracking cross platform application using Reactive Native front end.
Need an Android application that does package tracking and delivery.
EXPERIENCED PHP DEVELOPERS ONLY We need to develop a new pricing program for our webpage site, it is done in PHP- and we use WordPress for our website. WE ARE NOT LOOKING AT REBUILDING OUR WEBSITE IT ONLY A SECTION. We have designed the formula and the process in Excel and now we need to develop the PHP CODE for our website. THE FUNCTION IS AS FOLLOW. 1) THE ONLINE USE WILL ENTER THEIR...
I have a test database that I will share I am interested in 2 tables I need to insert new line in table A for each user that exist in table B we need to grab 2 vales ( from table B like ID and Name) enter it in table B so we need INSERT querry in table a for every used from table B in table A we will need 2 values that are unique for each user, an one value in table A will be the same for ev...
I'm looking to pull data regarding sales on the blockchain, anyone with stock market charting experience will have an advantage. Here is some background info: Per my understanding they are on the Flow Blockchain ([login to view URL]) and execute transactions through Dapper Labs ([login to view URL]) There are a couple of sites that appear to do it successfully [login to view URL] [login t...
We are a German shop for audio electronic and a self programmed Access Database (Access Frontend and MySql Database) helps us organize our business. The project is complete in German (Gui, Access Objects, Database Objects etc.). We need some support in creating reports and formulas in Access. The first question is if the German language is a knock-out fact, or if we could try to start with a litt...
I am looking for someone with API experience. We have websites we scraped and someone who can put all the scraped sites into a MySQL database what ever database. Also If you know how to blacklist websites from internet access
Hello, I'm looking for someone to update a Pricing Chatbot. The chatbot currently asks user information but there are a still few things to be done in order for the chatbot to make sense. Here are the tasks that I need doing: Once the chatbot asks for #of followers (nf), # of tweets (nt) and # of admin (na), I need the chatbot to show the price based on this formula: If nt is < 20 then t...
I need to build the logic of the new margin calculation of the NSE Only Logic Calculation of the New Margin Benefits Read Nsscl Margin File and Developed Logic
create a database in order to get the list of: customer name, product name, categories, prices, delivery date and payment [login to view URL] to do some analysis to help him to order the list by price in descendent order, to get the product with the lowest price, to count the products by address and the payment method.
Hi, I use .accdr access to manage our customer's database which is outdated and missing some functionality like selecting customer etc... I would like to know the cost to upgrade to a more modern version in order to manage our customers and which can be used on Google drive, or any other cloud service. The project will be to make a new management system to a better version/look using the...
Hello, I have an mysql database. We have a script to import data. data contains non standard character such “OFF††¼ ° Because of those character, import script is aborted. We need to change the database setting and schemas, so that it can accept all character, so that script is not stopped.
Need SQL database to sort & track (200) employees working on 12 rotating shifts. Track qualifications, personal data, team data, automatically update profiles from imported excel reports
i need to a Replication of 2 Microsoft SQL Server database for all data tables and views need synchronization be automatically or each hour do synchronization
Have an Access database and I want to link the tables to an MSQL database. -Exporting and Linking is working 100% Problem: When you export ACESS to MySQL Database the ACC Tables lose the relationships between each other. Very simple database, run 2 Queries with 2 Forms. So the ACESS QUERY works, except for the relationship status. Example: The default dropdown in ACESS Query does not work as norm...
We have java springboot app deployed on Kubernetes/Docker. but Oracle DB is on EC2, which create issue of performance in query to DB as its vertical scalable... Its 90% read operation and 10% write operation Need to do Oracle DB query handling by indexing, stored procedure and also by scalability (maybe using kubernetes/docker)
We have java springboot app deployed on Kubernetes/Docker. but Oracle DB is on EC2, which create issue of performance in query to DB as its vertical scalable... Its 90% read operation and 10% write operation Need to do Oracle DB query handling by indexing, stored procedure and also by scalability (maybe using kubernetes/docker)
il looking for a simple one page to display graph values from multiple database. should be sorted by weekly, monthy, quarterly and yearly
Looking for a Power BI expert can create a full power BI suit of reports with sourcess from REST apis for the majority and SQL databases. Let me know when you are ready to start immediately.
I will be grateful if I can actually get someone who help me out with my project. I will really need someone who can help me in completing my project as I'm running out of time.
I've a database and frontend form to collect user data. Via a dynamic page, a user can review their daily entries. Two requests: I want a user to be able to edit/update previous data entered on the log form I want a coach to be able to view and add comments to a runner's daily log and have that update when a user looks at their log page
We are looking for an simple app that automatically takes a defined schema and compares it to an existing instance. It will detect any changes that need to be made, make the changes (if required) and report any errors. This code will be used so that any time the application launches and there are database changes in either the schema or in preset data, this module will apply them via an automated ...
Capable of wending 12 products. Customer enters his phone number on LCD screen. He gets an OTP. Customer enters OTP. Machine accepts the order by LCD screen and pushes out the product in the tray for customer to pick up. The customer can maintain a wallet with the vending machine supplier or he can link his preferred wallet to the vending machine supplier. The transaction is debited from the custo...
Topic- "Graph-based analysis of big data" Big data is a term that describes the large volume of data both, structured and unstruc- tured that inundates a business on a day to day basis. But it’s not the amount of data that’s important. It’s what organizations do with the data that matters. Big data can be analyzed for insights that lead to better decisions and strategic...
We have financials in XBRL format, we want a fast solution to convert it and save it to SQL Database.
Develop Project Management framework on Odoo for a small company it will follow both Waterfall and Agile methodology With modules for Project Management according to PMI Forms and work flows for the 10 knowledge areas Agile Tools Scheduling Gantt Charts Dashboards For any bidder Must 1- Have very good past experience 2- Show previous Work 3- Develop a simple POC (Form, workflow, Gant Chart, C...
Hello I am interested in your services, But I am curious if you think you might be able to get this blockchain to work [login to view URL] I have allready installed yiimp ([login to view URL]) but I have no idea how to get the daemon to talk to the rpc server, no matter how I write the config for the node, nothing works. If you can help me figure this out I will gladly hire you. Thank you!
I need to build one application which scan barcode and compare its result to simple database (local) and giving the result with judgment OK or Not OK. App platform is WINDOWS EMBEDDED COMPACT 7 (successor of WIN CE). The app task is read 2 kind of barcode / QR code and compare both result, if match with criteria then display judgment result as GOOD / OK, and display NO GOOD for another result. Pr...
Am looking for a fast web based order execution interface to place orders and manage executed orders to interface with Zerodha. Am not looking for algo or any algo generated automated order execution. All orders will be manual for now. Most of the required code exists as sample in various forums (some from zerodha itself). Am just looking for someone who can tidy all that up and put them togethe...
given: schema sql and data sql provided task: write down 2 sql queries and 1 stored procedure apply PL/SQL (Oracle’s procedure extension to SQL) to write a stored procedure to process data send me message for more details
Looking for Oracle Fusion Financials/Security experts. Need to automate user creation and configure ftp connection setup and much more
We need a database and web interface that is able to track individual staff members compliance records. It will need to hold personal information, criminal records checks, driving licence checks, CV's and interview notes, as well as qualifications (Some that expire and some that don't). The system must be user friendly and intuitive, as well as being able to send alerts to users when in...
We would like to ask strong support from a skillful IT expert for a complex system integration. More details will be shared during our first online meeting. Our goals and aims are clearly defined but a keyperson is missing from the team. Programming + web development
Develop real-time data feeds software written in C/C++ to read the data from exchanges on Linux DB server. Develop the Websocketd server (written in C/C++, well-commented source code along with seastar) running on scyllaDB DB server. for Websocketd clients to access to scyllaDB that will have the real-time data streaming/historical data download based on our own custom REST API requests based ...
I need someone who can connect 5 workbooks together in googlesheet and create a MySQL database to store all the data from within all the work books to a database, as this is a live workbook, as new data is input into google sheet it must also update the database as well with the new data. ****All RIDICILOUS BIDS WILL BE DELETED AND IGNORED**** ****Requirements**** -Must Speak English -Must have Pr...
I have a large number of PDF documents generated from seeing patients. I currently store them in folders on dropbox, each folder relating to eithe a clinic visit, lab results, surgical notes, etc - I would like a better database management system - ideally something that would look after my dropbox data and assist with naming of files correctly and preventing accidental deletion of files. I am...
I have a database regarding payroll generation...here are one query and 5 reports I want to add-on running sum in report footer
Details about how to use the PHP PDO library for data manipulation
When starting new web project you mast make a decision: customize existing open source project (make it suitable for your needs), or start new project
Developing your own database to use for searches is not as complicated as you might think.