Update

This page explains how to update an existing Website in the CRM system using the form fields.

---

Form Fields

When updating a website, you can edit the following fields:

Field	Type	Description
Title	string	The name of the website (must remain unique).
Type	string	Type of website (e.g., Ecommerce, Blog, SaaS).
Website URL	string	The website’s full URL (e.g., https://example.com).
Country	string	Country where the website operates.
State	string	State/Region of the website.
Description	string	A short description of the website.
Geo Code Required?	boolean	Toggle to enable/disable geocoding requirement.
Lighthouse Report Required?	boolean	Toggle to enable/disable Lighthouse performance report.
Confirmation Email Required?	boolean	Toggle to enable/disable sending confirmation email.

---

Save Button (Update)

When you click the Save button while editing an existing website, the system runs an SQL UPDATE query to modify the record in the database.

Example SQL Query

UPDATE websites
SET 
    title = 'My Updated Website',
    type = 'blog',
    website_url = 'https://updated-example.com',
    country = 'Canada',
    state = 'Ontario',
    description = 'This is an updated description.',
    is_geo_code_required = 1,
    is_lighthouse_report_required = 0,
    is_confirmation_email_required = 1,
    updated_at = NOW()
WHERE id = 5;