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 are currently using Perfex CRM and have our MySQL database with data. We require to develop and generate reports by selection criteria that must work where we can see the info on the screen be able to print export to excel or save to pdf. The report must have proper headers and footers and details and have a professional layout. Php MySQL code-igniter. We require 10 reports done. Candidate must have experience with PERFEX CRM
I need the help of someone who could assist with some small scripts with SQl Programming Urgently...tif you can finish it in less than 2-3hrs hanks
I need explanation of architecture diagram related to database oracle PLSQL and Json
I want a custom Amazon product viewer integrated into my Wordpress site. I want to be able to load an excel sheet of Amazon product information into a database and users will be able to browse and filter my data on my website. A good examples of the type of product viewer is from Keepa. I would like the product viewer interface to be similar in function to Keepa. You must have work samples similar to what I am asking for. I would like to see a similar product that you have created. PLEASE READ THE PDF DOCUMENT to fully understand the project details and properly quote me a price and time estimate. Thank you.
I need the Database development. coder for multiple jobs. Details will be discussed.
I need the Database development. coder for multiple jobs. Details will be discussed.
I need the Database development. coder for multiple jobs. Details will be discussed.
I need the Database development. coder for multiple jobs. Details will be discussed.
I need the Database development. coder for multiple jobs. Details will be discussed.
I have a MySQL database with some tables and data. I need to add some additional fields to my main table and then have a update routine that that can read the record in the table , get matching data from other tables and update the main table with calculations and the results to be written in the database table. We can connect and share my screen to discuss further, I need this done immediately so must be done today. If you cannot do it today please do not reply and waste time
I need the Database development. coder for multiple jobs. Details will be discussed.
need to fix the table lines output in adobe pdf. small task, common problem, if you know how to handle this, easy job. I have 5 bids now, none of them looks like familiar with this problem/solution. Just a hint with a posible solution:
I am using Perfex CRM and a MySQL database. I need a loop routine that must select my data within a date range read the record find the correct price do a calculation and update the same record in the table and then move to the next till all us done. I require this as a option on the menu that we can reuse at any time. Must be able to work live online on my server as we will not be sharing the application or database to any outside person
Hi I have to prepare some course materials for some computer science courses like database. This include lectures, quizzes, etc.. Please only if you are expert in the above fields. You need to commit long time for this project please. Thank you
I am a quality and patent safety director , i am responsible for 14 hospitals , 61 primary health care centers I have alot of data , i hope to give me a professional work analysis and analytics to introduce these data to my boss Time i hope to finish work 4 days
Looking for an individual to upgrade Oracle database from 12c to 19c Required experience in upgrading Oracle databases Ability to define clear upgrade path and estimate effort
I have on my server PHP data tables which collects data from a website. I want to link the data to MS Access so I can analyse and write queries.
Convert the current database into microsoft access. Allowing users to enter data easily and for the database to be able to crunch the numbers and produce simple reports. Also to be able to search the database easily and bring up the values required.
I want a custom Amazon product viewer integrated into my Wordpress site. I want to be able to load an excel sheet of Amazon product information into a database and users will be able to browse and filter my data on my website. A good examples of the type of product viewer is from Keepa. I would like the product viewer interface to be similar in function to Keepa. You must have work samples similar to what I am asking for. I would like to see a similar product that you have created. PLEASE READ THE PDF DOCUMENT to fully understand the project details and properly quote me a price and time estimate. Thank you.
i want to transfer sql data to other sql databse using static ip
I am using Perfex CRM and a MySQL database. I need a loop routine that must select my data within a date range read the record find the correct price do a calculation and update the same record in the table and then move to the next till all us done. I require this as a option on the menu that we can reuse at any time. Must be able to work live online on my server as we will not be sharing the application or database to any outside person
Field people's doctor and retailer visit detail will be tracked through this report.
We have an access Database that we put together over 10 years ago. it was added to, modified and updated to work on newer versions of Access, Currently, we add data 5 days a week by collecting the information on paper then going to a desktop computer and enter the information. We want to move the data we already have to a new online database. We want to be able to add data with a smart phone app or a desktop computer. We would like 3 levels of access. Level 1, enter data into new record. Level 2 modify data in any record level 3 administrative level, where usernames , passwords, level access are added edited or deleted . We use to host our websites. . We would like to put the database there. We are OK moving away from MS Access because it changes regularly We can tolerate locking the d...
We are building a sales portal for our company and generating transactions using a form-based tool (FormSite). FormSite can write new rows to most databases and we'd like the new rows we generate for every transaction to be immutably recorded in our QLDB instance. We work 8am to 5pm eastern time. Some flexibility to time zone and other needs can be discussed. This is a senior-level role - we are looking for a smart, entrepreneurial developer who can make a serious contribution to us on both a technical and professional level. Who we’re looking for: - Experience working with AWS QLDB is a must - Transparency and Strong communication skill - Video call is required Interested? Give us a shout! Please include your experience as part of your application.
I need the Database development. coder for multiple jobs. Details will be discussed.
I need the Database development. coder for multiple jobs. Details will be discussed.
Installing new server to small established network of 5 computers, database exceeded 10 gb so we have to upgrade to sql standard from sql express. Small optometric office we run office mate ’ll be able to call office mate for help in transition to new server.
I have a Windows95 Program, that has obviously hardcoded some fonts into it. I would need those fonts as ttf or similar.
Install the required software and restore the Oracle 11g database backup. Make a connection with the application.
Client interview support and job support for 6 months in Big data engineer Python,hive,haddop,sql
create conceptual design and architecture of database system. tasks like: writing List of Main Entities, Attributes and Keys. writing use cases. do an ERD if you think u can finish message me I will send u full document
I would like a directory database that is simple to use. I would like a search filter option so that shippers can search for a truck and find matches based on the information provided by my carriers.
Connection failed: User "someting" has exceeded the 'max_user_connections' resource (current value: 50)
We are looking to develop a mobile app which provides information about soccer games. UI/UX will need to be built from scratch, along with front and back end. I will also need a database to be produced. We will send a technical specification document directly for more details. This app will be for both IOS and Andorid.
I want to force users to quit ms application database in order to use the backend for maintenance or do any changes, also I want to view attachment in reports
Need an online person to work with me in parallel for this view creation for report. Only remote online person is required
We have an existing system built on top of MySQL. The system uses a lot of various filters / queries and is very slow. It was built and modified as the needs changed so it is a bit of a “Frankenstein” creation. Our immediate need is to: (1) review the DB structure and suitability for our use cases, (2) optimize tables and queries/filters, and (3) determine if – long term - we should stay with MySQL or switch to something like PostgreSQL.
Hello to everyone! This is more or less what I need: I have a WP website on which a form will collect datas from my users with anagraphical data and preferences about Italian schools. Based on the choices a PDF module must be generated. The second step: a public database of all Italian schools is available in a .csv file or similars. Depending on the choices made by the users, a certain list of schools should be generated by means of a query and the pdf should be sent to this addresses via email (with a little additional message). the public database already exists, but it must be filtered depending on the data collected on my form time by time. the entered data in the form must define the query which operate on the public database (which naturally can be acquired and used freely)...
We are looking for an experienced SQL Developer to join our existing team of web-based enterprise application developers. The primary responsibility of the candidate is to develop Stored Procedures and Functions that perform the applications business logic. The candidate should demonstrate strong logical, analytical, coding and debugging skills. Ability to write medium to complex Stored Procedures & Packages, T-SQL queries (DML, DDL statements, etc.), Functions, Transactions, Triggers, Database designing, Indexes, Query optimization, Troubleshooting Desired Candidate Profile - Desired candidate should have excellent knowledge of T-SQL - Good understanding of query optimization and indexing - Good database designing skills - Knowledge of various packages like SSIS, SSRS, SSAS would b...
a. Activity diagrams, describing the algorithm of possible actions, happening in the system; b. Functional diagrams of all components (services) describing a structure of the application; c. Sequence diagrams, describing API calls and low-level access; d. Class diagrams for all the services e. YAML file Use of Swagger Editor I can provide the data model and tables, etc. for reference Please connect for more details. There will be continuous tasks for 1 whole month or more
Power BI expert needed,Looking for long term, high pay for quality work. Thank you
looking for a company/person to rewrite my company program to handle commercial bins not just domestic, we have outgrown the program we have now and wish to make some changes to the way the program works, looking for a price at the moment to see if we can justify a new program or update old one.
I want source code of Import excel file (image with content) in mySQL database by CI 4. bid only when you can complete this. There is sample file in attachment so you can use this. import that data in my SQL database and image into folder.
A cryptographic hash function requires that both the pre-image resistance and collision free properties are satisfied. MD5 is now broken and algorithms have been invented that find collisions in MD5 easily. In this part you will use a collision generation tool to find collisions and then generate two C binary files that have slightly different content but generate the same MD5 hash. This part needs to be done on Linux. The md5collgen tool to be used for this part has been tested on Ubuntu 20.04.
I have two lists of data sets need to compare and populate another list according to the screenshot that I attached.
Hi, MSSQL adding Column (Alter Table) where default calculate days between NOW and other Column I want to add Column with name "Dopen" where there is a default calculation between NOW an field "besteldatum" (in same Table) This is a urgent task. Thanks in advance.
WORKING ON A PROJECT TO GET A TRAVERLER OUT TO OUR SHOP FLOOR
Good day, I am looking for assistance in converting a database from filemaker to either ms access of SQL. I am open for suggestions. Thanks Rudy
Need to migrate data from HelpScout to FreeScout using their APIs
I am trying to do a drawing that eliminates numbers as digits are drawn. here is a short description of how I would like it to work. On the screen which will be put onto a green screen I need lottery numbers displayed. There will be 100,000 to 2 million numbers to start with they will be formatted as such MH-1234567 the letters will change with drawing but will be the same for all tickets in the drawing. I would like to upload a cvs file of all the numbers and the starting screen would display them all i know they will be very tiny. Next I need to be able to enter a random first number in this case it would be for the 1 in MH-1234567 our numbers start at 1,000,000 and go to 2,999,999 but we will be drawing a number between 0 and 9. If we draw for this first column a 8 the program sh...
Details about how to use the PHP PDO library for data manipulation
Developing your own database to use for searches is not as complicated as you might think.
Are you an I, or a T?