Skip to main content

Featured Post

What is Salesforce ? Who is salesforce developer?

  1. Introduction to Salesforce Definition : Salesforce is the #1 Cloud-based CRM (Customer Relationship Management) platform that helps businesses manage relationships with customers, automate business processes, and analyze performance. Founded : 1999 by Marc Benioff. Type : SaaS (Software as a Service). Tagline : "No Software" – because everything runs on the cloud, without local installations. 2. Why Salesforce? Traditional CRMs were expensive and required servers, installations, and IT staff. Salesforce revolutionized CRM by moving everything to the cloud . Benefits: 🚀 Faster implementation ☁️ Cloud-based (accessible anywhere) 🔄 Customizable without coding (point-and-click tools) 🤝 Strong ecosystem & AppExchange (marketplace like Google Play for Salesforce apps) 🔐 Security & scalability 3. Salesforce Products & Cloud Offerings Salesforce is not just CRM; it has multiple clouds (modules) for different busine...
Post a Comment

CRUD OPERATION in DJANGO , Insert, update, delete and select record from database




CRUD means Create, read, update and delete, in this article we will perform database operation to insert a record, update a record, delete record, and show record from the database.


Step 1st manage class on  models.py and write Code on Models.py



 from django.db import models
class Contact(models.Model):
   emailid= models.CharField(max_length=100)
   mobile= models.CharField(max_length=12)
   message= models.CharField(max_length=200)
   def __str__(self):
       return self.emailid +" "+self.mobile +" "+self.message


step2nd:  Code of Views.py for insertion, update, deletion, and selection

from django.shortcuts import render,redirect
from django.http import HttpResponse
from .models import Contact




def contact(request):        #load contact us page
return render(request,"scsapp/contact.html")


def viewcontact(request):    # code of data selection from contact table
    s=Contact.objects.all()    # sql query  select * from contact
    return render(request,"scsapp/viewcontact.html",{'res':s})


def Editcontact(request):      # code to find record from contact table
    s = Contact.objects.get(pk=request.GET["q"])    # sql select * from contact where id=?
    return render(request,"scsapp/editcontact.html",{'res':s})



def edit(request):            #code to update record from database to contact table
    e=request.POST["txtemail"]
    m=request.POST["txtmobile"]
    msg=request.POST["txtmsg"]
    s = Contact.objects.get(pk=request.POST["txtid"])
    s.emailid=e
    s.mobile=m
    s.message=msg
    s.save()
    return redirect('viewcontact')


def Deletecontact(request):    # code to find record for delete operation
    s = Contact.objects.get(pk=request.GET["q"])
    s.delete()
    return redirect('viewcontact')


def contactcode(request):        #code to insert record from database
    e=request.POST["txtemail"]
    m=request.POST["txtmobile"]
    msg=request.POST["txtmsg"]
    obj = Contact(emailid=e,mobile=m,message=msg)
    obj.save()
    return redirect('viewcontact')
   # return render(request,"scsapp/contact.html",{'res':'data submitted successfully'})



step3rd:- Code of Contact.html for Data Insertion Template

<!DOCTYPE html>
<html>
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="/static/style.css">
</head>
<body>
<header><h1>Welcome in FeedBack System Application</h1>
 <hr>

<ul><li><a href="home">Home</a></li><li><a href="about">About</a></li><li><a href="contact">Contact us</a></li><li><a href="service">Service</a></li><li><a href="gallery">Gallary</a></li></ul>
</header>
<section>
<center>
<h1>Welcome in Contact us page</h1>
<form action="contactcode" method="post">
{% csrf_token %}
<input type="email" name="txtemail" placeholder="Enter email" required="">
<br><br>
<input type="number" name="txtmobile" placeholder="Enter mobile" required="">
<br>
<br>
            <textarea rows="10" cols="20" name="txtmsg" placeholder="Enter message" required=""></textarea>
            <br>
            <br>
            <input type="submit" name="btnsubmit" value="Submit" />
        </form>
        {{res}}
        </center>
         <a href="viewcontact">View Contact</a>
</section>
<footer></footer>

</body>
</html>

Step 4th:- viewcontact.html

 <h1>View Contact Here</h1>
<table border="1">
<tr><th>EmailID</th><th>Mobileno</th><th>Message</th></tr>
 {% for q in res %}
     <tr>  <td>{{ q.emailid }} </td><td> {{ q.mobile }} </td><td> {{ q.message }}</td><td><a href="Editcontact?q={{ q.id }}"> EDIT</a></td><td><a href="Deletecontact?q={{ q.id }}">DELETE</a></td></tr>
 {% endfor %}

</table>

Step 5th editcontact.html

<p>Edit Record Here</p>
<form action="edit" method="post">
{% csrf_token %}
<input type="hidden" name="txtid" value="{{res.id}}">
<input type="email" name="txtemail" placeholder="Enter email" required="" value="{{res.emailid}}">
<br><br>
<input type="number" name="txtmobile" placeholder="Enter mobile" value="{{res.mobile}}">
<br>
<br>
            <textarea rows="10" cols="20" name="txtmsg" placeholder="Enter message" >{{res.message}}</textarea>
            <br>
            <br>
            <input type="submit" name="btnsubmit" value="Update" />
</form>









Labels:

Comments

  1. AayushAugust 12, 2020 at 3:31 PM

    Very Informative

    ReplyDelete
  2. anujaJanuary 5, 2021 at 3:32 PM

    models.py
    from django.db import models

    class Contact(models.Model):
    email_id=models.CharField(max_length=100)
    mobile=models.IntegerField()
    message=models.CharField(max_length=200)
    def __str__(self):
    return "email_id"+str(self.email_id)+"mobile"+str(self.mobile)+"message"+str(self.message)
    # Create your models here.
    views.py
    from django.shortcuts import render,redirect
    from django.http import HttpResponse
    from .models import Contact


    def viewcontact(request):
    res=Contact.objects.all()
    return render(request,"crudoperation/viewcontact.html",{'data':res})



    def editrec(request):
    if request.method=="POST":
    e=request.POST["txtemail_id"]
    m=request.POST["txtmobile"]
    msg=request.POST["txtmessage"]
    s=Contact.objects.get(pk=request.POST["txtid"])
    s.email_id=e
    s.mobile=m
    s.message=msg
    s.save()
    return redirect("viewcontact")
    else:
    res=Contact.objects.get(pk=request.GET["q"])
    return render(request,"crudoperation/editrec.html",{'data':res})

    def insertrec(request):
    if request.method=="POST":
    e=request.POST["txtemail_id"]
    m=request.POST["txtmobile"]
    msg=request.POST["txtmessage"]
    obj=Contact(email_id=e,mobile=m,message=msg)
    obj.save()
    return redirect("viewcontact")
    else:
    return render(request,"crudoperation/insertrec.html")
    return render(request,"crudoperation/insertrec.html",{'res':'data inserted sucessfully'})



    def deleterec(request):
    s=Contact.objects.get(pk=request.GET["q"])
    s.delete()
    return redirect('viewcontact')
    # Create your views here.
    urls.py
    from django.urls import path
    from . import views

    urlpatterns=[

    path('',views.viewcontact,name="viewcontact"),
    path('editrec',views.editrec,name="editrec"),
    path('deleterec',views.deleterec,name='deleterec'),
    path('insertrec',views.insertrec,name='insertrec'),



    ]

    ReplyDelete

Post a Comment

POST Answer of Questions and ASK to Doubt

Popular posts from this blog

Conditional Statement in Python

It is used to solve condition-based problems using if and else block-level statement. it provides a separate block for  if statement, else statement, and elif statement . elif statement is similar to elseif statement of C, C++ and Java languages. Type of Conditional Statement:- 1) Simple if:- We can write a single if statement also in python, it will execute when the condition is true. for example, One real-world problem is here?? we want to display the salary of employees when the salary will be above 10000 otherwise not displayed. Syntax:- if(condition):    statements The solution to the above problem sal = int(input("Enter salary")) if sal>10000:     print("Salary is "+str(sal)) Q)  WAP to increase the salary of employees from 500 if entered salary will be less than 10000 otherwise the same salaries will be displayed. Solution:- x = int(input("enter salary")) if x<10000:     x=x+500 print(x)   Q) WAP to display th...
217 comments
Read more

DSA in C# | Data Structure and Algorithm using C#

  DSA in C# |  Data Structure and Algorithm using C#: Lecture 1: Introduction to Data Structures and Algorithms (1 Hour) 1.1 What are Data Structures? Data Structures are ways to store and organize data so it can be used efficiently. Think of data structures as containers that hold data in a specific format. Types of Data Structures: Primitive Data Structures : These are basic structures built into the language. Example: int , float , char , bool in C#. Example : csharp int age = 25;  // 'age' stores an integer value. bool isStudent = true;  // 'isStudent' stores a boolean value. Non-Primitive Data Structures : These are more complex and are built using primitive types. They are divided into: Linear : Arrays, Lists, Queues, Stacks (data is arranged in a sequence). Non-Linear : Trees, Graphs (data is connected in more complex ways). Example : // Array is a simple linear data structure int[] number...
Post a Comment
Read more

Top 50 Most Asked MERN Stack Interview Questions and Answers for 2025

 Top 50 Most Asked MERN Stack Interview Questions and Answers for 2025 Now a days most of the IT Company asked NODE JS Question mostly in interview. I am creating this article to provide help to all MERN Stack developer , who is in doubt that which type of question can be asked in MERN Stack  then they can learn from this article. I am Shiva Gautam,  I have 15 Years of experience in Multiple IT Technology, I am Founder of Shiva Concept Solution Best Programming Institute with 100% Job placement guarantee. for more information visit  Shiva Concept Solution 1. What is the MERN Stack? Answer : MERN Stack is a full-stack JavaScript framework using MongoDB (database), Express.js (backend framework), React (frontend library), and Node.js (server runtime). It’s popular for building fast, scalable web apps with one language—JavaScript. 2. What is MongoDB, and why use it in MERN? Answer : MongoDB is a NoSQL database that stores data in flexible, JSON-like documents. It...
Post a Comment
Read more