CRUD OPERATION in DJANGO:-
Code of 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
Code of Views.py

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


def index(request):
return render(request,"scsapp/index.html")
def about(request):
return render(request,"scsapp/about.html")
def service(request):
return render(request,"scsapp/services.html")
def contact(request):
return render(request,"scsapp/contact.html")
def viewcontact(request):
    s=Contact.objects.all()
    return render(request,"scsapp/viewcontact.html",{'res':s})
def Editcontact(request):
    s = Contact.objects.get(pk=request.GET["q"])
    return render(request,"scsapp/editcontact.html",{'res':s})
def edit(request):
    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):
    s = Contact.objects.get(pk=request.GET["q"])
    s.delete()
    return redirect('viewcontact')
def contactcode(request):
    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'})
def editcontact(request):
    return render(request,"scsapp/editcontact")
def deletecontact(request):
    return render(request,"scsapp/deletecontact")
def gallery(request):
return render(request,"scsapp/gallery.html")
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>

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>

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>









1 Comments

If you have any doubt in programming or join online classes then you can contact us by comment .

Post a Comment

If you have any doubt in programming or join online classes then you can contact us by comment .

Previous Post Next Post