1+ <!doctype html>
2+ <html lang="en">
3+
4+ <head>
5+ <!-- Required meta tags -->
6+ <meta charset="utf-8"/>
7+ <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"/>
8+ <meta name="keywords" content="codemistic,code,c++,java,python,tutorials,lessons,learn c++,learn java,learn python,free tutorials,python tutorials,python lessons, python free course" />
9+ <meta name="description" content="Download Campus Leaders Certificates. Enter your email and get your certificate." />
10+ <title>Download Certificate</title>
11+
12+ <script>
13+ (function(w, d, s, l, i) {
14+ w[l] = w[l] || [];
15+ w[l].push({
16+ 'gtm.start': new Date().getTime(),
17+ event: 'gtm.js'
18+ });
19+ var f = d.getElementsByTagName(s)[0],
20+ j = d.createElement(s),
21+ dl = l != 'dataLayer' ? '&l=' + l : '';
22+ j.async = true;
23+ j.src =
24+ 'https://www.googletagmanager.com/gtm.js?id=' + i + dl;
25+ f.parentNode.insertBefore(j, f);
26+ })(window, document, 'script', 'dataLayer', 'GTM-MCNC43J');
27+ </script>
28+ <!-- End Google Tag Manager -->
29+ <!-- Global site tag (gtag.js) - Google Analytics -->
30+ <script async src="https://www.googletagmanager.com/gtag/js?id=G-YPTQSLH0XW"></script>
31+ <script>
32+ window.dataLayer = window.dataLayer || [];
33+
34+ function gtag() {
35+ dataLayer.push(arguments);
36+ }
37+ gtag('js', new Date());
38+
39+ gtag('config', 'G-YPTQSLH0XW');
40+ </script>
41+ <script data-ad-client="ca-pub-5352867889640158" async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
42+ <!-- Favicon -->
43+
44+ <link rel="icon" type="img/png" href="../favicon.png" />
45+ <!-- FONT AWESOME -->
46+
47+ <link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.13.1/css/all.css" integrity="sha384-xxzQGERXS00kBmZW/6qxqJPyxW3UR0BPsL4c8ILaIWXva5kFi7TxkIIaMiKtqV1Q" crossorigin="anonymous" />
48+
49+ <!-- FONTS -->
50+
51+ <link href="https://fonts.googleapis.com/css2?family=Kalam:wght@700&family=Ubuntu&family=Varela+Round&display=swap" rel="stylesheet" />
52+
53+ <!-- Animate on scroll -->
54+
55+ <link rel="stylesheet" href="https://unpkg.com/aos@next/dist/aos.css" />
56+
57+ <!-- Bootstrap CSS -->
58+ <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous" />
59+
60+ <title>Verify</title>
61+ <link rel="stylesheet" href="../lang_styles.css">
62+
63+ </head>
64+
65+ <body>
66+ <nav class="navbar fixed-top navbar-expand-xl navbar-dark">
67+ <a class="navbar-brand" href="https://codemistic.in/index.html">CODEMISTIC</a>
68+ <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
69+ <span class="navbar-toggler-icon"></span>
70+ </button>
71+ <div class="collapse navbar-collapse" id="navbarSupportedContent">
72+ <ul class="navbar-nav ml-auto">
73+ <li class="nav-item">
74+ <a class="nav-link" href="https://codemistic.in/index.html">Home</a>
75+ </li>
76+ <li class="nav-item dropdown">
77+ <a class="nav-link dropdown-toggle" href="#" id="navbarDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
78+ Tutorials
79+ </a>
80+ <div class="dropdown-menu" aria-labelledby="navbarDropdown">
81+
82+ <a class="dropdown-item" href="https://codemistic.in/cpp.html">C++</a>
83+ <div class="dropdown-divider"></div>
84+ <a class="dropdown-item" href="https://codemistic.in/python.html">Python</a>
85+ <div class="dropdown-divider"></div>
86+ <a class="dropdown-item" href="https://codemistic.in/java.html">Java</a>
87+ <div class="dropdown-divider"></div>
88+ <a class="dropdown-item" href="https://codemistic.in/dsa.html">Data Structure and Algorithms</a>
89+ <div class="dropdown-divider"></div>
90+ <a class="dropdown-item" href="https://codemistic.in/tutorials.html">All Tutorials</a>
91+
92+ </div>
93+ </li>
94+ <li class="nav-item">
95+ <a class="nav-link" href="https://codemistic.in/events.html">Events</a>
96+ </li>
97+ <li class="nav-item">
98+ <a class="nav-link" href="https://codemistic.in/teen-code.html">Teen-Code</a>
99+ </li>
100+ <li class="nav-item">
101+ <a class="nav-link" href="https://codemistic.in/campus.html">Campus Programme</a>
102+ </li>
103+ <!-- <li class="nav-item">
104+ <a class="nav-link" href="https://docs.google.com/forms/d/e/1FAIpQLSc2O28YJpxQc6kh2tKpI_Lf5MwfwGXVnhMs0g5EEXobJ4Beeg/viewform?usp=sf_link" target="_blank">Contribute</a>
105+ </li> -->
106+
107+ <li class="nav-item">
108+ <a class="nav-link" href="https://codemistic.in/register.html">Join Our Community</a>
109+ </li>
110+ </ul>
111+ </div>
112+ </nav>
113+ <br/>
114+ <h2 style="text-align: center;">Download Your Certificate</h2><br/>
115+ <div class="container my-4">
116+ <form action="campus_certificate.php" method="POST">
117+ <div class="form-group">
118+ <label for="exampleInputEmail1" style="font-weight:bolder;font-size:larger">Enter Your Email</label>
119+ <input type="text" class="form-control" id="exampleInputEmail1" aria-describedby="emailHelp" name="idno">
120+ </div>
121+ <button type="submit" class="btn btn-primary" style="font-weight: bolder;">Submit</button>
122+ </form>
123+ </div>
124+ <?php
125+
126+ $ servername = "localhost " ;
127+ $ username = "z05cnh72slgo " ; // Enter username of phpmyadmin/Webhosting
128+ $ password = "22March@1234 " ; // Enter password of database
129+ $ database = "certificates " ; // Enter database in which you have to store data
130+
131+ $ conn = mysqli_connect ($ servername , $ username , $ password , $ database );
132+ if ($ _SERVER ['REQUEST_METHOD ' ] === 'POST ' ) {
133+ if (!empty ($ _POST ['idno ' ])) {
134+ $ userid = $ _POST ['idno ' ];
135+ $ sql = "SELECT * FROM `campus` WHERE email=' $ userid' " ;//Replace codebattle with your table name in which all csv have been stored and also u_id with that column name in which all id's have been stored
136+ $ result = mysqli_query ($ conn ,$ sql );
137+ $ num = mysqli_num_rows ($ result );
138+ if ($ num == 1 ){
139+ while ($ row = mysqli_fetch_assoc ($ result )) {
140+ echo '<div class="container"><div class="alert alert-success alert-dismissible fade show" role="alert">
141+ <strong>Thank You ' .$ row ['name ' ].'!</strong> for your contribution as <strong> ' . $ row ['event ' ] . '</strong> <br />Certificate issued on <strong> ' . $ row ['date ' ] . '</strong><br /> Your Certificate ID is <strong> ' . $ row ['id ' ] . '</strong><br /><br /> <a href="https://codemistic.in/certificates/ ' .$ row ['card_id ' ] . '.pdf"><button class="btn btn-success" style="font-weight: bolder;">Download Your Certificate</button></a>
142+ <button type="button" class="close" data-dismiss="alert" aria-label="Close">
143+ <span aria-hidden="true">×</span>
144+ </button>
145+ </div></div> ' ;
146+ }
147+
148+ }else {
149+ echo '<div class="container"><div class="alert alert-danger alert-dismissible fade show" role="alert">
150+ <strong>Error! No certificate found. Enter correct email.</strong>
151+ <button type="button" class="close" data-dismiss="alert" aria-label="Close">
152+ <span aria-hidden="true">×</span>
153+ </button>
154+ </div></div> ' ;
155+ }
156+ }else {
157+ echo '<div class="container"><div class="alert alert-danger alert-dismissible fade show" role="alert">
158+ <strong>Error! Please enter email.</strong>
159+ <button type="button" class="close" data-dismiss="alert" aria-label="Close">
160+ <span aria-hidden="true">×</span>
161+ </button>
162+ </div></div> ' ;
163+ }
164+ }
165+ ?>
166+ <footer>
167+ <div class="row footer">
168+ <div class="logo">
169+ <img src="https://codemistic.in/image.png" alt="" class="f-img">
170+ <h5>LEARN CODE DISCUSS</h5>
171+ </div>
172+
173+ <div class="footer-column ">
174+
175+ <ul class="footer-ul">
176+ <li class="foot-header"><strong>CodeMistic</strong></li>
177+
178+ <li class="f-li"><a href="https://codemistic.in/index.html" class="f-links">Home</a></li>
179+
180+
181+ <li class="f-li"><a href="https://codemistic.in/team.html" class="f-links">Our Team</a></li>
182+
183+
184+ <li class="f-li"><a href="https://codemistic.in/terms-and-conditions.html" class="f-links">Terms of Service</a></li>
185+
186+
187+ <li class="f-li"><a href="https://codemistic.in/privacy-policy.html" class="f-links">Privacy Policy</a></li>
188+
189+ </ul>
190+ </div>
191+ <div class="footer-column ">
192+
193+ <ul class="footer-ul ">
194+ <li class="foot-header"><strong>LEARN</strong></li>
195+
196+ <li class="f-li"><a href="https://codemistic.in/cpp.html" class="f-links">C++</a></li>
197+
198+
199+ <li class="f-li"><a href="https://codemistic.in/java.html" class="f-links">Java</a></li>
200+
201+
202+ <li class="f-li"><a href="https://codemistic.in/python.html" class="f-links">Python</a></li>
203+
204+
205+ <li class="f-li"><a href="https://codemistic.in/dsa.html" class="f-links">DSA</a></li>
206+
207+ </ul>
208+ </div>
209+ <div class="footer-column ">
210+
211+ <ul class="footer-ul ">
212+ <li class="foot-header"><strong>CONTRIBUTE</strong></li>
213+
214+ <li class="f-li"><a href="https://docs.google.com/forms/d/e/1FAIpQLSduxk_aP9M1lqUAebQJwRXiVm2ukmdgv3T7gjBpOsr_gdeOcQ/viewform?usp=sf_link" class="f-links" target="_blank">Write an Article/Blog</a></li>
215+
216+
217+ <li class="f-li"><a href="https://docs.google.com/forms/d/e/1FAIpQLSc2O28YJpxQc6kh2tKpI_Lf5MwfwGXVnhMs0g5EEXobJ4Beeg/viewform?usp=sf_link" class="f-links" target="_blank">Internships</a></li>
218+
219+
220+ <li class="f-li"><a href="https://docs.google.com/forms/d/e/1FAIpQLSe9nr_Aw0fGIqm3_xWhqEzTr3UWdOFz-pvKpQvkAsosORYq9w/viewform?usp=sf_link" class="f-links" target="_blank">Videos</a></li>
221+
222+ <li class="f-li"><a href="https://docs.google.com/forms/d/e/1FAIpQLScOW3hJjxxwzPYL4u51oboc4T1aDtIUEIRa20hKPKu4UlcZAA/viewform?usp=sf_link" class="f-links" target="_blank">Donations/Funds</a></li>
223+
224+ </ul>
225+ </div>
226+
227+ </div>
228+ <div class="footer-links" style="text-align: center;">
229+ <!-- <h7>Connect With Us</h7><br><br> -->
230+ <a href="https://www.facebook.com/codemistic " target="_blank "><i class="icons fa-2x fab fa-facebook " style="color:#3b5998; "></i></a>
231+ <a href="https://www.instagram.com/codemistic.in " target="_blank "><i class="icons fa-2x fab fa-instagram " style="color:#e95950; "></i></a>
232+ <a href="https://www.twitter.com/codemistic " target="_blank "><i class="icons fa-2x fab fa-twitter " style="color:#8accf5; "></i></a>
233+ <a href="https://www.linkedin.com/company/codemistic " target="_blank "><i class="icons fa-2x fab fa-linkedin " style="color:#88b3ee; "></i></a>
234+ <a href="https://t.me/codemistic " target="_blank "><i class="icons fa-2x fab fa-telegram " style="color:#65adda; "></i></a>
235+
236+ <a href="https://www.youtube.com/channel/UCS1Iv_kkgQGDwoXtvrlwlag " target="_blank "><i class="icons fa-2x fab fa-youtube " style="color:red; "></i></a>
237+ <p class="foot mt-3">© Copyright : <strong>CodeMistic</strong> All Rights Reserved.</p>
238+ </div>
239+ </footer>
240+ <!-- Optional JavaScript -->
241+ <!-- jQuery first, then Popper.js, then Bootstrap JS -->
242+ <script src="https://code.jquery.com/jquery-3.5.1.slim.min.js" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous"></script>
243+ <script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.1/dist/umd/popper.min.js" integrity="sha384-9/reFTGAW83EW2RDu2S0VKaIzap3H66lZH81PoYlFhbGU+6BZp6G7niu735Sk7lN" crossorigin="anonymous"></script>
244+ <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js" integrity="sha384-B4gt1jrGC7Jh4AgTPSdUtOBvfO8shuf57BaghqFfPlYxofvL8/KUEfYiJOMMV+rV" crossorigin="anonymous"></script>
245+ </body>
246+
247+ </html>
0 commit comments