Creating php scripts and database on mySQL
15 USD Laboratory 4 – Two tables are required.The first contains information about the companies, namely the name of the company (up to 250 characters).The second is the information about the cars produced by companies: the name of the car (up to 150 characters), its value (full number) and a reference to the company.Further, get information about companies and cars in the form of a two-level list.The first level contains the names of companies in the alphabetical order.On the second are the information about the cars for this company, sorted by the names of the cars in the alphabetical order.All these pages must be extracted from the base with one request, i.e.and e.It is not possible to make a request purely for the companies, and then for each company to extract additional request information about the cars.(You need to write a script to create a database tables, fill the database with and remove the database tables.page according to the task)
Laboratory 5 – It is necessary to create three tables – cars, firms and countries.The car table has a name, links to the company and the country.There are two pages to be implemented.The first shows a list of cars in the form of a table of three columns.In the first column the name of the car is given, in the second - the name of the company with a reference to the page of view of the company.In the third column is the name of the country.The list of vehicles must be ordered by the name of the vehicle.The second page shows detailed information about the company on its key, namely: the name of the company and the number of cars of the company (you need to write a script to create tables and a script to fill these tables with data)
Applications 1
Client's review of cooperation with Aleksandr B.
Creating php scripts and database on mySQLHe did everything well, to set up and explained how it works.
Freelancer's review of cooperation with client
Creating php scripts and database on mySQLA good customer.
Everything is clear!
I hope for further cooperation.
-
Вадим Любивый, откуда у бедного студента 8к рэ?
-
Current freelance projects in the category Databases & SQL
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 42 minutes back ∙ 4 proposals |
Accounting, planning, and sales system for a mushroom farm
601 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 2 days 4 hours back ∙ 53 proposals |
External report 1C 8.3 — forecast of goods balances
22 USD
An external report (.erf) is needed for 1C:Enterprise 8.3 (configuration to be specified). What it should do: Extract product balances from the database Analyze sales history for the last 30 days Calculate the average sales rate for each product Determine how many days until the… Databases & SQL, Client Management & CRM ∙ 2 days 5 hours back ∙ 13 proposals |
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (Penetr
Project Overview We operate a custom-built customer relationship management (CRM) platform that runs two service businesses on a single system. It is a modern JavaScript web application backed by a backend-as-a-service (BaaS) database and deployed on a serverless hosting… Databases & SQL, Testing & QA ∙ 2 days 17 hours back ∙ 10 proposals |
Database synchronization
Synchronization of Microsoft Access programs and CRM SalesDrive. Data transfer from CRM to Microsoft Access in the first stage (changing the funnel status). Data transfer from Microsoft Access to CRM in the second stage (changing the status in the program). Databases & SQL ∙ 2 days 23 hours back ∙ 12 proposals |