Rameshwar ghodke Rameshwar-ghodke

💭

working as Web Designer

Senior Software Engineer

Rameshwar-ghodke / Registration-form

Created March 30, 2017 11:49

	<!DOCTYPE html>
	<html>
	<style>
	form {
	border: 3px solid #f1f1f1;
	}

	input[type=text], input[type=password] {
	width: 100%;
	padding: 12px 20px;

Rameshwar-ghodke / Codegnitor installation process

Last active April 1, 2017 13:18

	Change the config file base url as-
	$config['base_url'] = 'http://localhost/';
	after that change the database pathin database.php file in config folder as --

	'hostname' => 'localhost',
	'username' => 'root',
	'password' => 'root',
	'database' => 'login',
	'dbdriver' => 'mysqli',

Rameshwar-ghodke / PDO Connection.php

Created March 30, 2017 11:58

	<?php
	$servername = "localhost";
	$username = "username";
	$password = "password";

	try {
	$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password);
	// set the PDO error mode to exception
	$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	echo "Connected successfully";

Rameshwar-ghodke / Insert,Delete,Update, Query using PDO

Created March 30, 2017 12:01

 <?php
 $servername = "localhost";
 $username = "username";
 $password = "password";
 $dbname = "myDBPDO";
 try {
     $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
     // set the PDO error mode to exception
     $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

Rameshwar-ghodke / Search through database

Created March 30, 2017 12:16

	In this example, when a user types a character in the input field, a function called "showHint()" is executed.
	The function is triggered by the onkeyup event.
	eg-----

	<html>
	<head>
	<script>
	function showHint(str) {
	if (str.length == 0) {
	document.getElementById("txtHint").innerHTML = "";

Rameshwar-ghodke / fetch information from a database with AJAX:

Created March 30, 2017 12:20

	<html>
	<head>
	<script>
	function showUser(str) {
	if (str == "") {
	document.getElementById("txtHint").innerHTML = "";
	return;
	} else {
	if (window.XMLHttpRequest) {
	// code for IE7+, Firefox, Chrome, Opera, Safari

Rameshwar-ghodke / .htaccess file

Last active April 1, 2017 11:20

	<IfModule mod_rewrite.c>
	RewriteEngine On
	RewriteBase /
	RewriteCond %{REQUEST_FILENAME} !-f
	RewriteCond %{REQUEST_FILENAME} !-d
	RewriteRule ^(.*)$ edge/index.php?/$1 [L]



	</IfModule>z

Rameshwar-ghodke / Login form using codegnitor

Created April 1, 2017 05:42

	// first call the following log() function in your controller
	eg :-
	function log()
	{
	//$this->load->helper(array('url'));
	$this->load->view('login_view');
	}
	// this function call through the form after submit the login form
	eg:

Rameshwar-ghodke / codegnitor base path

Created April 1, 2017 09:18

	<?php
	defined('BASEPATH') OR exit('No direct script access allowed');
	include getcwd()."/application/config/config.php";
	$base_url = $config['base_url'];
	?>


	<link href="<?=$base_url?>style/bootstrap/dist/css/bootstrap.min.css" rel="stylesheet">

Rameshwar-ghodke / Insert update delete using Codegnitor

Created April 2, 2017 13:42

 // insert into stud table value using codegnitor
 $data = array(
    'roll_no' => ‘1’,
    'name' => ‘Virat’
 );
 $this->db->insert("stud", $data);
 // Update query using codegnitor