quinta-feira, 2 de junho de 2016
HTML 5 - POP UP
<!DOCTYPE html>
<head>
<title>Creating a modal window with HTML5 & CSS3</title>
<style>
#openModal {
position:relative;
z-index:1;
}
#popup
{
position:absolute;
z-index:2;
left:300px;
top:35px;
display:none;
width:500px;
padding: 5px 20px 13px 20px;
border-radius: 10px;
background: -moz-linear-gradient(#fff, #999);
background: -webkit-linear-gradient(#fff, #999);
background: -o-linear-gradient(#fff, #999);
}
.close {
background: #606061;
color: #FFFFFF;
line-height: 25px;
position: absolute;
right: -12px;
text-align: center;
top: -10px;
width: 24px;
text-decoration: none;
font-weight: bold;
-webkit-border-radius: 12px;
-moz-border-radius: 12px;
border-radius: 12px;
-moz-box-shadow: 1px 1px 3px #000;
-webkit-box-shadow: 1px 1px 3px #000;
box-shadow: 1px 1px 3px #000;
}
.close:hover { background: #00d9ff; }
</style>
</head>
<body>
<div id="popup">
<div>
<a href="#close" onclick="hide('closer'); hide('popup')" id="closer" title="Close" class="close">X</a>
<h2>Modal Box</h2>
<p>This is a sample modal box that can be created using the powers of CSS3.</p>
<p>You could do a lot of things here like have a pop-up ad that shows when your website loads, or create a login/register form for users.</p>
</div>
</div>
<div id="openModal" class="modalDialog">
<h2>TESTE</h2>
<p>POP UP CSS3.</p>
<p>You could do a lot of things here like have a pop-up ad that shows when your website loads, or create a login/register form for users.</p>
</div>
<script>
document.getElementById('popup').style.display = 'block';
function hide(id)
{
document.getElementById(id).style.display = "none";
}
</script>
</body>
</html>
MySQL How to fill a Google Drive Spread Sheet - Como preencher o Planilhas do Google Drive
// This app is made in JDBC
// Replace the variables in this block with real values.
var address = 'localhost:3306';
var user = 'USER';
var userPwd = 'PWD';
var db = 'DATABASE';
var dbUrl = 'jdbc:mysql://' + address + '/' + db;
//Gets and Sets the Current Spreadsheet as Active
var doc = SpreadsheetApp.getActiveSpreadsheet();
doc.setActiveSheet(doc.getSheetByName('Sheet1')); // nome da sheet
//No meu caso tenho a nome da coluna na linha 1: [E-mail] na coluna A1 e [Contato] na coluna B1
var lastRow = doc.getLastRow();
var lastRow_plus = lastRow + 1; // pula uma linha
var cell = doc.getRange('A'+lastRow_plus); // acha a ultima linha preenchida da coluna A
// Read up to 1000 rows of data from the table and log them.
function readFromTable() {
var conn = Jdbc.getConnection(dbUrl, user, userPwd);
var start = new Date();
var stmt = conn.createStatement();
stmt.setMaxRows(1000);
var results = stmt.executeQuery('SELECT DISTINCT email, contato FROM `SUA-TABELA` WHERE status_envio=0 order by email');
var numCols = results.getMetaData().getColumnCount();
var row = 0;
while (results.next()) {
var rowString = '';
for (var col = 0; col < numCols; col++) {
cell.offset(row, col).setValue(results.getString(col+1));
}
row++;
Logger.log(rowString);
}
var stmt1 = conn.prepareStatement('update SUA-TABELA set status_envio=1');
stmt1.addBatch();
var batch = stmt1.executeBatch();
results.close();
stmt.close();
var end = new Date();
Logger.log('Time elapsed: %sms', end - start);
}
Assinar:
Postagens (Atom)