Just as adding records, updating records is an activity done daily by developers. On registration forms, updating records is one of the main demands and requests, regardless of the type of environment in which the application will run, you hardly see an application without this feature.

For applications that use PostgreSQL as the default database UPDATE command is responsible for updating records in tables, as shown in the following syntax:

UPDATE [Table]

SET [Column] = [Value]

For you to better understand the operation of this command will use a practical example.

UPDATE product

SET price = 2000

In the above example we update all records in the table with the product price 2,000, but this however is not the usual way to use this command. It must be combined with the WHERE clause that will allow so that only records that are in accordance with the conditional be updated.

UPDATE product

SET Price = 2000

WHERE Cod_prod = 1

Note that in the above command only the product with code 1 will be updated, so other records will remain exactly as they are avoiding data inconsistencies in the database and thereby directly impacting on their reliability.

database-postgre-sql

PHP PostgreSQL

Currently he is known as one of the most advanced free databases in the world, created in 1985 by Michael Stonebraker, it is in the version 9.0 released in 2010. The PostgreSQL Global Development Group works hard in the source code of the database to make it more complete.PostgreSQL has gained more space in the market for web development because of the large amount of resources it has, moreover, it is a free DBMS and this makes it extremely attractive for those who need to work with low-cost projects.

PHP PostgreSQL

Who uses the PostgreSQL database in PHP projects successfully combine low production and maintenance cost, also it has many of the features that the databases offers thus making it a complete option.

But when you are developing a project, is essential to have a tool that can assist you. With Scriptcase you can easily connect to PostgreSQL database, all you need to inform to connect to the PostgreSQL is:

  • Connection Name: It will help you identify the connection among the others.
  • DBMS Driver: it Will show a list with all drivers available.
  • Server/Host(Name or IP): The physical address from the database, it may be local on your machine, on your local network or remote in the cloud.
  • Port: The port that you want to use to connect to your database.
  • Username: Username for the user from the database.
  • Password: The password from the previous selected username.

PHP PostgreSQL Connection

Once you connect Scriptcase with your database, it will read your tables and create applications based on the desired tables. Scriptcase will identify all special characteristics from your table, such as primary keys, foreign key, auto-increments, among others, and will show that at the application level. All the CRUD (Create, Read, Update and Delete) actions will be managed by the Scriptcase. On forms and reports all the navigation, searches and filters (Static or Dynamic) will be also handled by Scriptcase automatically.

Scriptcase support stored procedures and all SQL statements (joins, order by, group by, among others) of PostgreSQL, why lose time when you have Scriptcase to help you out?! Download it now and test it free for 20 days!

 

Know more about the best and most efficient PHP RAD Tool of the market! Get to know Scriptcase.

You might also like…

PROCESAMIENTO AJAX EN SCRIPTCASE

Ajax en los formularios de Scriptcase puede usarse para recargar un campo de tipo de select basado e...

IMPORTAR IMAGENES DE LA BASE DE DATOS Y UTILIZAR CLASES DE BOOSTRAP

Como muchas personas ya saben, Bootstrap es una biblioteca de front-end libre y de código abierto p...

TENDENCIAS DE DESARROLLO WEB PARA 2017

Usted verá en este post tendencias para 2017 en Diseño Web, en el medio digital y en el desarrollo...

Comment this post

Get new posts, resources, offers and more each week.

We will use the information you provide to update you about our Newsletter and Special Offers. You can unsubscribe any time you want by clinck in a link in the footer of any email you receive from us, or by contacting us at sales@scriptcase.net. Learn more about our Privacy Police.