Skip to content

Instantly share code, notes, and snippets.

View niisar's full-sized avatar
🎯
Focusing

Mohammed Nisar Ansari niisar

🎯
Focusing
7 followers · 1 following
View GitHub Profile
@niisar
niisar / Putting jQuery Into No-Conflict Mode.js
Created August 30, 2014 08:51
Putting jQuery Into No-Conflict Mode
<!-- Putting jQuery into no-conflict mode. -->
<script src="prototype.js"></script>
<script src="jquery.js"></script>
<script>
var $j = jQuery.noConflict();
// $j is now an alias to the jQuery function; creating the new alias is optional.
$j(document).ready(function() {
$j( "div" ).hide();
});
// The $ variable now has the prototype meaning, which is a shortcut for
@niisar
niisar / Text to Javascript.html
Last active August 29, 2015 14:06
Text to Javascript
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Text to Javascript</title>
<script type="text/javascript">
var oneClick = false, oneMoreClick = false;
function convIt(OoB) {
//check if the text is supplided for conversion or not.
if (!OoB.toEnc.value) { window.alert('You have not supplied any code for me to convert.\nPut some HTML or JavaScript in the large text box.'); OoB.isEnc.value = 'Resulting code will be displayed here'; return; }
//check to variable is currect or not.
@niisar
niisar / oca link
Last active August 29, 2015 14:06
oca link
@niisar
niisar / db backup restore.sql
Last active August 29, 2015 14:06
db backup restore
-------------------sqlserver
--detach db
EXEC master.dbo.sp_detach_db @dbname = N'nopCommerce'
--restore db
RESTORE DATABASE [nopCommerce] FROM
DISK = N'F:\NISAR WORKSPACE\E-Logistics\DB-E-Logistics\eLogistics.bak'
WITH REPLACE
GO
--backup db
@niisar
niisar / Delete last N characters from field in a SQL Server database.sql
Created September 13, 2014 04:56
Delete last N characters from field in a SQL Server database
UPDATE mytable SET column=LEFT(column, LEN(column)-5)
@niisar
niisar / text alignment in radio button group
Created September 25, 2014 13:57
text alignment in radio button group
.radioButtonList td
{
vertical-align: top;
}
.radioButtonList input[type="radio"]
{
float: left;
}
.radioButtonList label
{
@niisar
niisar / output to file in mysql.sql
Created October 9, 2014 09:05
output to file in mysql
select `TABLE_NAME`,`COLUMN_NAME`,`ORDINAL_POSITION`,`COLUMN_DEFAULT` from information_schema.columns where TABLE_SCHEMA = 'hhims' order by TABLE_NAME into outfile 'd:\del.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '';
@niisar
niisar / hms
Last active August 29, 2015 14:07
hms
http://mdsfoss.org/hhimsv2/index.php/login
doe
123
@niisar
niisar / create html in sql server.sql
Created October 14, 2014 11:04
create html in sql server
declare @pc table(CHILD_ID int, PARENT_ID int, [NAME] varchar(80));
insert into @pc
select 1,NULL,'Bill' union all
select 2,1,'Jane' union all
select 3,1,'Steve' union all
select 4,2,'Ben' union all
select 5,3,'Andrew' union all
select 6,NULL,'Tom' union all
select 7,8,'Dick' union all
@niisar
niisar / xml path tut 1.sql
Created October 14, 2014 11:07
xml path tut 1
-- Create table
CREATE TABLE #TestTable (StudentName VARCHAR(100), Course VARCHAR(100), Instructor VARCHAR(100), RoomNo VARCHAR(100))
GO
-- Populate table
INSERT INTO #TestTable (StudentName, Course, Instructor, RoomNo)
SELECT 'Mark', 'Algebra', 'Dr. James', '101'
UNION ALL
SELECT 'Mark', 'Maths', 'Dr. Jones', '201'
UNION ALL
SELECT 'Joe', 'Algebra', 'Dr. James', '101'