API tools faq
paste
Guest User

Untitled

a guest
Oct 2nd, 2018
136
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 21.30 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. session_start();
  3. if(empty($_SESSION['userr'])) {
  4. header("Location: login.php");
  5. }
  6. include_once('company_header.php');
  7. $user = $_SESSION['userr'];
  8. $query = mysqli_query($conn, "SELECT * FROM companies WHERE email = '".$user."'");
  9. $q = mysqli_fetch_array($query);
  10. ?>
  11. <script type="text/javascript">
  12. $(function(){
  13. $("#modal_company_name").keyup(function(){
  14. var comp = $('#modal_company_name').val();
  15. if(comp.length =="") {
  16. $('.comp_error').remove();
  17. $('#modal_company_name').after('<span class="comp_error error">Company name is required</span>');
  18. $('.comp_error').show();
  19. } else {
  20. $('.comp_error').hide();
  21. }
  22. });
  23. $('#modal_contact').keypress(function(e){
  24. var conct = $('#modal_contact').val();
  25. if (e.which != 8 && e.which != 0 && (e.which < 48 || e.which > 57)) {
  26. return false;
  27. }
  28. });
  29. $('#modal_contact').keyup(function(){
  30. var conct = $('#modal_contact').val();
  31.  
  32. var reg1 = /^(+d{1,3}[- ]?)?d{10}$/;
  33. var validMobile = reg1.test(conct);
  34. if(!validMobile) {
  35. $('.contact_error').remove();
  36. $('#modal_contact').after("<span class='contact_error error'>Invalid mobile number</span>");
  37. } else {
  38. $('.contact_error').hide();
  39. }
  40. });
  41. $('#modal_website').keyup(function(){
  42. var cont = $('#modal_website').val();
  43. if(cont.length == '') {
  44. $('.website_error').remove();
  45. $('#modal_website').after("<span class='website_error error'>Employee Address is required</span>");
  46. $('.website_error').show();
  47. } else {
  48. $('.website_error').hide();
  49. }
  50. });
  51.  
  52. $('#modal_email').keyup(function(){
  53. var mail = $('#modal_email').val();
  54.  
  55. var reg = /^([A-Za-z0-9_-.])+@([A-Za-z0-9_-.])+.([A-Za-z]{2,4})$/;
  56. var validEmail = reg.test(mail);
  57. if(mail.length == '') {
  58. $('.emp_email_error').remove();
  59. $('#emp_email').after("<span class='emp_email_error error'>Employee email is required</span>");
  60. }
  61. else if(!validEmail){
  62. $('.email_error').remove();
  63. // $('#modal_email').after('<span class="email_error error">Invalid Employee Email</span>');
  64. } else {
  65. $('.email_error').hide();
  66. }
  67. });
  68. $('#modal_no_of_emp').keypress(function(e){
  69. var emp = $('#modal_no_of_emp').val();
  70. if (e.which != 8 && e.which != 0 && (e.which < 48 || e.which > 57)) {
  71. return false;
  72. }
  73. });
  74. // $("#modal_no_of_emp").keyup(function(){
  75. // var emp = $('#modal_no_of_emp').val();
  76. // if(emp.length =="") {
  77. // $('.emp_error').remove();
  78. // $('#modal_no_of_emp').after('<span class="emp_error error">No of employees is required</span>');
  79. // $('.emp_error').show();
  80. // } else {
  81. // $('.emp_error').hide();
  82. // }
  83. // });
  84. });
  85. </script>
  86. <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
  87. <script type="text/javascript">
  88. $(function(){
  89. $('#modal_update').on('click', function(){
  90. // var update = $('#modal_update').val();
  91. var ui = $('#modal_uid').val();
  92. var comp = $('#modal_company_name').val();
  93. var addr = $('#modal_address').val();
  94. var ct = $('#modal_city').val();
  95. var stat = $('#modal_state').val();
  96. var cont = $('#modal_country').val();
  97. var conct = $('#modal_contact').val();
  98. var web = $('#modal_website').val();
  99. var mail = $('#modal_email').val();
  100. var emp = $('#modal_no_of_emp').val();
  101.  
  102. var reg = /^([A-Za-z0-9_-.])+@([A-Za-z0-9_-.])+.([A-Za-z]{2,4})$/;
  103. var validEmail = reg.test(mail);
  104.  
  105. var reg1 = /^(+d{1,3}[- ]?)?d{10}$/;
  106. var validMobile = reg1.test(conct);
  107.  
  108. if(comp.length == '') {
  109. $('.comp_error').remove();
  110. $('#modal_company_name').after("<span class='comp_error error'>Company name is required</span");
  111. return false;
  112. }
  113. // else if(addr.length == '') {
  114. // $('.address_error').remove();
  115. // $('#modal_address').after("<span class='address_error error'>Address is required</span");
  116. // return false;
  117. // }
  118. // else if(ct.length == '') {
  119. // $('.city_error').remove();
  120. // $('#modal_address').after("<span class='city_error error'>City is required</span");
  121. // return false;
  122. // }
  123. // else if(stat.length == '') {
  124. // $('.state_error').remove();
  125. // $('#modal_state').after("<span class='state_error error'>City is required</span");
  126. // return false;
  127. // }
  128. // else if(cont.length == '') {
  129. // $('.country_error').remove();
  130. // $('#modal_country').after("<span class='country_error error'>City is required</span");
  131. // return false;
  132. // }
  133. else if(conct.length == '') {
  134. $('.contact_error').remove();
  135. $('#modal_contact').after("<span class='contact_error error'>Mobile number is required</span");
  136. return false;
  137. }
  138. else if(!validMobile) {
  139. $('.contact_error').remove();
  140. $('#modal_contact').after("<span class='contact_error error'>Invalid mobile number</span>");
  141. return false;
  142. }
  143. else if(mail.length == '') {
  144. $('.email_error').remove();
  145. $('#modal_email').after("<span class='email_error error'>Email is required</span");
  146. return false;
  147. }
  148. if(!validEmail) {
  149. $('.email_error').remove();
  150. $('#modal_email').after("<span class='email_error error'>Invalid Employee Email</span");
  151. return false;
  152. } else {
  153. console.log('Starting ajax');
  154. $.ajax({
  155. url: 'ajax_company_profile.php',
  156. type: 'post',
  157. data: {
  158. modal_uid: ui,
  159. modal_company_name: comp,
  160. modal_address: addr,
  161. modal_city: ct,
  162. modal_state: stat,
  163. modal_country: cont,
  164. modal_contact: conct,
  165. modal_website: web,
  166. modal_work_email: mail,
  167. modal_no_of_emp: emp
  168. },
  169. success:function(data){
  170. // window.location = "company_profile.php";
  171. }
  172. });
  173. }
  174. });
  175. });
  176. </script>
  177. <?php
  178.  
  179. // $query = mysqli_query($conn, "SELECT * FROM companies WHERE email = '".$user."' ");
  180. // $q = mysqli_fetch_array($query);
  181.  
  182. ?>
  183. <link rel="stylesheet" type="text/css" href="css/company_profile.css">
  184. <div class="right_col" role="main">
  185. <div class="container">
  186. <div class="row">
  187. <div class="col-xs-12 col-sm-12 col-md-12 nopadding">
  188. <ul class="breadcrumbs">
  189. <li>
  190. <a href="company_homepage.php"><i class="fa fa-home"></i></a>
  191. <span class="separator"><i class="fas fa-chevron-right"></i></span>
  192. </li>
  193. <li><a href="company_profile.php">Company Profile</a></li>
  194. <div class="button_edit">
  195. <a id="add_button"><button class="btn btn-default btn-sm" data-toggle="modal" data-target="#exampleModalLong">Edit</button></a>
  196. </div>
  197. </ul>
  198. </div>
  199.  
  200. <div class="col-md-12 col-sm-12 col-xs-12">
  201. <div class="row">
  202. <div class="x_content">
  203.  
  204. <form class="form-horizontal form-label-left" novalidate="">
  205. <span class="section">Personal Info</span>
  206. <?php if(!$q['company_name']==''){ ?>
  207. <div class="item form-group">
  208. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="Company">Company
  209. </label>
  210. <div class="col-md-6 col-sm-6 col-xs-12">
  211. <input class="form-control col-md-7 col-xs-12 input-box" type="text" value="<?php if(isset($_SESSION['userr']) && $_SESSION['userr'] != '') { echo $q['company_name']; } else { } ?>" readonly>
  212. </div>
  213. </div>
  214. <?php } ?>
  215. <?php if(!$q['email']==''){ ?>
  216. <div class="item form-group">
  217. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="email">Email
  218. </label>
  219. <div class="col-md-6 col-sm-6 col-xs-12">
  220. <input type="email" class="form-control col-md-7 col-xs-12 input-box" value="<?php if(isset($_SESSION['userr']) && $_SESSION['userr'] != '') { echo $q['email']; } else { } ?>" readonly>
  221. </div>
  222. </div>
  223. <?php } ?>
  224. <?php if(!$q['website']==''){ ?>
  225. <div class="item form-group">
  226. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="website">Website URL
  227. </label>
  228. <div class="col-md-6 col-sm-6 col-xs-12">
  229. <input type="url" class="form-control col-md-7 col-xs-12 input-box" value="<?php if(isset($_SESSION['userr']) && $_SESSION['userr'] != '') { echo $q['website']; } else { } ?>" readonly>
  230. </div>
  231. </div>
  232. <?php } ?>
  233. <?php if(!$q['no_of_emp']==''){ ?>
  234. <div class="item form-group">
  235. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="No of employee">No of employee
  236. </label>
  237. <div class="col-md-6 col-sm-6 col-xs-12">
  238. <input type="text" class="optional form-control col-md-7 col-xs-12 input-box" value="<?php if(isset($_SESSION['userr']) && $_SESSION['userr'] != '') { echo $q['no_of_emp']; } else { } ?>" readonly>
  239. </div>
  240. </div>
  241. <?php } ?>
  242. <?php if(!$q['address']==''){ ?>
  243. <div class="item form-group">
  244. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="Address">Address
  245. </label>
  246. <div class="col-md-6 col-sm-6 col-xs-12">
  247. <input type="text" class="optional form-control col-md-7 col-xs-12 input-box" value="<?php if(isset($_SESSION['userr']) && $_SESSION['userr'] != '') { echo $q['address']; } else { } ?>" readonly>
  248. </div>
  249. </div>
  250. <?php } ?>
  251. <?php if(!$q['city']==''){ ?>
  252. <div class="item form-group">
  253. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="City">City
  254. </label>
  255. <div class="col-md-6 col-sm-6 col-xs-12">
  256. <input type="text" class="optional form-control col-md-7 col-xs-12 input-box" value="<?php if(isset($_SESSION['userr']) && $_SESSION['userr'] != '') { echo $q['city']; } else { } ?>" readonly>
  257. </div>
  258. </div>
  259. <?php } ?>
  260. <?php if(!$q['state']==''){ ?>
  261. <div class="item form-group">
  262. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="state">State
  263. </label>
  264. <div class="col-md-6 col-sm-6 col-xs-12">
  265. <input type="text" class="optional form-control col-md-7 col-xs-12 input-box" value="<?php if(isset($_SESSION['userr']) && $_SESSION['userr'] != '') { echo $q['state']; } else { } ?>" readonly>
  266. </div>
  267. </div>
  268. <?php } ?>
  269. <?php if(!$q['country']==''){ ?>
  270. <div class="item form-group">
  271. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="country">Country
  272. </label>
  273. <div class="col-md-6 col-sm-6 col-xs-12">
  274. <input type="text" class="optional form-control col-md-7 col-xs-12 input-box" value="<?php if(isset($_SESSION['userr']) && $_SESSION['userr'] != '') { echo $q['country']; } else { } ?>" readonly>
  275. </div>
  276. </div>
  277. <?php } ?>
  278. <?php if(!$q['contact']==''){ ?>
  279. <div class="item form-group">
  280. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="contact">Contact
  281. </label>
  282. <div class="col-md-6 col-sm-6 col-xs-12">
  283. <input type="text" class="optional form-control col-md-7 col-xs-12 input-box" value="<?php if(isset($_SESSION['userr']) && $_SESSION['userr'] != '') { echo $q['contact']; } else { } ?>" readonly>
  284. </div>
  285. </div>
  286. <?php } ?>
  287. <div class="ln_solid"></div>
  288. </form>
  289. </div>
  290. </div>
  291. </div>
  292. </div>
  293. </div>
  294. </div>
  295. <!-- Modal -->
  296. <div class="modal fade" id="exampleModalLong" tabindex="-1" role="dialog" aria-labelledby="exampleModalLongTitle" aria-hidden="true">
  297. <div class="modal-dialog" role="document">
  298. <div class="modal-content">
  299. <div class="modal-header">
  300. <h2 class="modal-title" id="exampleModalLongTitle">Personal Info</h2>
  301. <button type="button" class="close close-model-trigger" data-dismiss="modal" aria-label="Close">
  302. <span aria-hidden="true">&times;</span>
  303. </button>
  304. </div>
  305. <div class="modal-body">
  306. <div class="x_content41">
  307. <form class="form-horizontal form-label-left">
  308. <div class="item form-group">
  309. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="company">Company <span class="required">*</span>
  310. </label>
  311. <div class="col-md-6 col-sm-6 col-xs-12">
  312. <input id="modal_company_name" class="form-control col-md-7 col-xs-12" name="modal_company_name" placeholder="both name(s) e.g Jon Doe" type="text" value="<?php if(isset($_SESSION['userr']) && $_SESSION['userr'] != '') { echo $q['company_name']; } else { } ?>">
  313. </div>
  314. </div>
  315. <div class="item form-group">
  316. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="address">Address
  317. </label>
  318. <div class="col-md-6 col-sm-6 col-xs-12">
  319. <textarea id="modal_address" name="modal_address" class="form-control col-md-7 col-xs-12"><?php if(isset($_SESSION['userr']) && $_SESSION['userr'] != '') { echo $q['address']; } else { } ?></textarea>
  320. </div>
  321. </div>
  322. <div class="item form-group">
  323. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="city">City
  324. </label>
  325. <div class="col-md-6 col-sm-6 col-xs-12">
  326. <input id="modal_city" type="text" name="modal_city" class="optional form-control col-md-7 col-xs-12" value="<?php if(isset($_SESSION['userr']) && $_SESSION['userr'] != '') { echo $q['city']; } else { } ?>">
  327. </div>
  328. </div>
  329. <div class="item form-group">
  330. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="state">State
  331. </label>
  332. <div class="col-md-6 col-sm-6 col-xs-12">
  333. <input id="modal_state" type="text" name="modal_state" class="optional form-control col-md-7 col-xs-12" value="<?php if(isset($_SESSION['userr']) && $_SESSION['userr'] != '') { echo $q['state']; } else { } ?>">
  334. </div>
  335. </div>
  336. <div class="item form-group">
  337. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="country">Country
  338. </label>
  339. <div class="col-md-6 col-sm-6 col-xs-12">
  340. <input id="modal_country" type="text" name="modal_country" class="optional form-control col-md-7 col-xs-12" value="<?php if(isset($_SESSION['userr']) && $_SESSION['userr'] != '') { echo $q['country']; } else { } ?>">
  341. </div>
  342. </div>
  343. <div class="item form-group">
  344. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="contact">Contact <span class="required">*</span>
  345. </label>
  346. <div class="col-md-6 col-sm-6 col-xs-12">
  347. <input type="text" maxlength="10" id="modal_contact" name="modal_contact" class="form-control col-md-7 col-xs-12" value="<?php if(isset($_SESSION['userr']) && $_SESSION['userr'] != '') { echo $q['contact']; } else { } ?>">
  348. </div>
  349. </div>
  350. <div class="item form-group">
  351. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="website">Web URL <span class="required">*</span>
  352. </label>
  353. <div class="col-md-6 col-sm-6 col-xs-12">
  354. <input type="text" id="modal_website" name="modal_website" placeholder="www.website.com" class="form-control col-md-7 col-xs-12" value="<?php if(isset($_SESSION['userr']) && $_SESSION['userr'] != '') { echo $q['website']; } else { } ?>">
  355. </div>
  356. </div>
  357. <div class="item form-group">
  358. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="email">Email <span class="required">*</span>
  359. </label>
  360. <div class="col-md-6 col-sm-6 col-xs-12">
  361. <input type="email" id="modal_email" name="modal_work_email" class="form-control col-md-7 col-xs-12" value="<?php if(isset($_SESSION['userr']) && $_SESSION['userr'] != '') { echo $q['email']; } else { } ?>">
  362. </div>
  363. </div>
  364. <div class="item form-group">
  365. <label for="no_of_emp" class="control-label col-md-3">No of employees</label>
  366. <div class="col-md-6 col-sm-6 col-xs-12">
  367. <input id="modal_no_of_emp" type="text" name="modal_no_of_emp" class="form-control col-md-7 col-xs-12" value="<?php if(isset($_SESSION['userr']) && $_SESSION['userr'] != '') { echo $q['no_of_emp']; } else { } ?>">
  368. </div>
  369. </div>
  370. <div class="ln_solid"></div>
  371. <div class="form-group">
  372. <div class="col-md-6 col-md-offset-3 button-submit">
  373. <input type="hidden" name="modal_uid" id="modal_uid" value="<?= $q['company_id']; ?>">
  374. <button id="modal_update" type="button" name="modal_update" class="btn btn-success">Update</button>
  375. <button type="submit" class="btn btn-primary">Cancel</button>
  376. </div>
  377. </div>
  378. </form>
  379. </div>
  380. </div>
  381. </div>
  382. </div>
  383. </div>
  384. <script>
  385. $(document).ready(function(){
  386. $('#email').keyup(function(){
  387.  
  388. var mail = $(this).val();
  389.  
  390. $.ajax({
  391. url:'ajax_company_profile.php',
  392. method:"POST",
  393. data:{email:mail},
  394. success:function(data)
  395. {
  396. if(data != '0')
  397. {
  398. $('#availability').html('<span class="email_valid error">Email already exists</span>');
  399. $('#submit').attr("disabled", true);
  400. $('.email_valid').show();
  401.  
  402. }
  403. else
  404. {
  405. $('.email_valid').remove();
  406. $('.email_valid').hide();
  407. $('#availability').html('<span class="text-success"></span>');
  408. $('#submit').attr("disabled", false);
  409. }
  410. }
  411. });
  412.  
  413. });
  414. });
  415. </script>
  416. <?php
  417. include_once('company_footer.php');
  418. ?>
  419.  
  420. <?php
  421. session_start();
  422. include('config.php');
  423.  
  424. echo $row = "SELECT email FROM companies WHERE email = '".$_SESSION['userr']."' EXCEPT('SELECT email FROM companies WHERE email != '".$_SESSION['userr']."'')";
  425. $r = mysqli_query($conn, $row);
  426.  
  427. $t = mysqli_fetch_array($r);
  428. var_dump($t);
  429.  
  430. if(isset($_POST['modal_uid'])) {
  431. $id = $_POST['modal_uid'];
  432. $company = $_POST['modal_company_name'];
  433. $add = $_POST['modal_address'];
  434. $city = $_POST['modal_city'];
  435. $state = $_POST['modal_state'];
  436. $country = $_POST['modal_country'];
  437. $contact = $_POST['modal_contact'];
  438. $web = $_POST['modal_website'];
  439. $email = $_POST['modal_work_email'];
  440. $emp = $_POST['modal_no_of_emp'];
  441.  
  442. $query = "
  443. UPDATE companies
  444. SET company_name = '".$company."',
  445. website = '".$web."',
  446. email = '".$email."',
  447. address = '".$add."',
  448. city = '".$city."',
  449. state = '".$state."',
  450. country = '".$country."',
  451. contact = '".$contact."',
  452. no_of_emp = '".$emp."'
  453. WHERE company_id = '".$id."'";
  454.  
  455. $q = mysqli_query($conn, $query);
  456. if($q>0) {
  457. session_unset();
  458. $_SESSION['userr'] = $email ;
  459. }
  460. }
  461. ?>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!