PANDUAJI.COM: December 2013

Install Solaar Logitech Wireless Driver on Linux Ubuntu

Support Logitech M325 Mouse

Solaar is an application that you must install on Ubuntu when you use Logitech wireless device! Perhaps many people who didn’t know the name of application, I just found out a little while ago from OMGUbuntu. So the function of this application is to simplify Logitech management of hardware that is using wireless as a liaison. Incidentally, I use Logitech M325 mouse and just idly trying to install this application and trying some features. Here are some features that i can enjoy this moment. Solaar

Feature The are many features that you get during installation Solaar on Ubuntu, but only some features that can be used by Logitech M325 mouse.

Identification of the type of mouse with this solaar application, i can identify Logitech mouse that i use. Beside that you also can identify every mouse that are around you.
Pair and Unpair with this application, you can connect and turn off the connection with the device, although the unifying receiver is still stuck on the laptop. With Unpair, automatically regardless of where the device is located then it is not able to connect with laptop or your computer anymore.
Knowing the battery capacity is very important for me, because it can be used to keep the vigil when the battery will be exhausted. But it looks like my mouse battery will still endure in quite a long time.

It looks like just 3 features that i felt. For thoose interested in installing Solaar in Ubuntu, try the tutorial below

How to Instal Solaar Logitech Wireless Device on Ubuntu

For install solaar, the first you have to add ppa to repository, this is the way

sudo add-apt-repository ppa:daniel.pavel/solaar

After that upgrade and install Solaar on Ubuntu in a way

sudo apt-get update && sudo apt-get install solaar

If you are using Gnome Shell, follow this command

sudo apt-get update && sudo apt-get install solaar-gnome3

After Solaar installation process is complete, make sure you unplug the unifying receiver first, after that plug it in again. Ta da! Your mouse will be detected by Solaar when it is a Logitech mouse that already provided according to which there is in List Supported Device.

2 comments

, by Pandu Aji Wirawan

internet

How To Create Teleprompter Web Base IV

How To Create Teleprompter Web Base IV - On this last part we will add chat feature thatcan be used communicate between broadcsater and news author. This chat feature is made by Anant Gart from inscript.com, to use it we need a database with name of chat table. To create table as requested by this feature, we can go to localhost/phpmyadmin. After that, open teleprompter database and select sql menu.

Menu SQL

On run sql text area, enter the code below that will make table name with variable needed to use this chat feature

CREATE TABLE `chat` (
  `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  `from` VARCHAR(255) NOT NULL DEFAULT '',
  `to` VARCHAR(255) NOT NULL DEFAULT '',
  `message` TEXT NOT NULL,
  `sent` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  `recd` INTEGER UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
)
ENGINE = InnoDB;

After the database is created, enter database with two users, broadcaster and author as username. In addition, it’s up to you to use your username as what, but you have to keep that in mind.

Add User

After username (at least two usernames). Next we need to enter a username and password of database on chat.php page. This section is located at the top of the file containing

define ('DBPATH','localhost');
define ('DBUSER','usernamedb');
define ('DBPASS','passworddb');
define ('DBNAME','namadb');

After username, password, and database name are set, next we will install this chat feature on the submit page. On the head, enter css link to pop up a chat using html code below

<link type="text/css" rel="stylesheet" media="all" href="css/chat.css" />
<link type="text/css" rel="stylesheet" media="all" href="css/screen.css" />

Next, enter menu to chat with newscaster, why newscaster? Because in this page is accessed by the news author. Here is the code for displaying chat menu with newscaster.

 <a href="javascript:void(0)" onclick="javascript:chatWith('penyiar')">Chat dengan Penyiar</a>

Next insert chat.php into php file submit by way of adding this php code.

<?php
include "chat.php";
$_SESSION['username'] = "penulis" //username penulis
?>

And don’t forget to include external javascript to enable this chat feature

<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/chat.js"></script>

Here is the code that i use in submit.php file which serves as news author’s page for entering news data into database.

<html>
<head><title>User Input</title></head>
<link rel="stylesheet" type="text/css" href="form.css">
<link type="text/css" rel="stylesheet" media="all" href="css/chat.css" />
<link type="text/css" rel="stylesheet" media="all" href="css/screen.css" />
<body>
<h2>Input Teleprompter</h2>

<form class="form" method="post" action="addtele.php">  

    <p class="judul">  
        <input type="text" name="judul" id="judul" value="<?php echo isset($_POST['judul']) ? $_POST['judul'] : '';?>" />  
        <label for="judul">Judul</label>  
    </p>  

    <p class="acara">  
        <input type="acara" name="acara" id="acara" value="<?php echo isset($_POST['acara']) ? $_POST['acara'] : '';?>"/>  
        <label for="acara">Acara</label>  
    </p>  

    <p class="creator">  
        <input type="creator" name="creator" id="creator" value="<?php echo isset($_POST['creator']) ? $_POST['creator'] : '';?>" />  
        <label for="creator">Author</label>  
    </p>  

    <p class="isi">  
        <textarea name="isi" value="<?php echo isset($_POST['isi']) ? $_POST['isi'] : '';?>"></textarea>  
    </p>  

    <p class="submit">  
        <input type="submit" value="Kirim" />  
    </p>  

</form>  
 <script type="text/javascript" src="js/jquery.js"></script>
    <script type="text/javascript" src="js/chat.js"></script>
<?php
include "chat.php";
$_SESSION['username'] = "penulis" // Must be already set
?>
<a href="javascript:void(0)" onclick="javascript:chatWith('penyiar')">Chat dengan Penyiar</a>
</body>
</html>

Next we will add this chat feature into newscaster’s page. How to enter the chat feature on this page, the same way as how to enter chat feature on submit.php pages, therefore, Here is the final contents of index.php file i have.

<html>
<head>
<title>Teleprompter</title>
<link rel="stylesheet" type="text/css" href="style.css">
<link type="text/css" rel="stylesheet" media="all" href="css/chat.css" />
<link type="text/css" rel="stylesheet" media="all" href="css/screen.css" />
</head>
<body>
<!-- Copyright Hannu Multanen 2005 - 2009 -->
<!-- www.cueprompter.com -->
<div id="badan">
 <div id="left">
 <table class="listberita">
 <tr><th>Pilihan Berita</th></tr>
 <?php                 
 include "koneksi.php";
 include "chat.php";
 $_SESSION['username'] = "penyiar";
 $sql = " SELECT * FROM input ORDER BY judul ";
 //echo $sql;   
 $sql = mysql_query($sql);
 while ($data=mysql_fetch_array($sql)){
 $d_id = $data["id"]; 
 $d_judul = $data["judul"];
 ?>
 <tr><td color="#FFFFFF"><a href="index.php?id=<?php echo $d_id;?>"><?php echo $d_judul;?></a></td></tr>
 <?php
 }
 ?> 
 </table>
 <br>
    <a href="javascript:void(0)" onclick="javascript:chatWith('penulis')">Chat dengan Penulis</a>
    <script type="text/javascript" src="js/jquery.js"></script>
    <script type="text/javascript" src="js/chat.js"></script>
 </div>
 <div id="right">
  <table width="950px" cellpadding="0" cellspacing="0" border="0" bgcolor="#666666">
  <tr>
  <td class="control">
   <a href="Javascript:pgup()" class="control">PgUp^</a>
   &nbsp;
   <a href="Javascript:rverse()" class="control">&lt;&lt; REVERSE</a>&nbsp;
   <a href="Javascript:stop()" class="control">STOP <span class="stcontrol">||</span></a>&nbsp;
   <a href="Javascript:fward()" class="control">FORWARD &gt;&gt;</a>  
   &nbsp; &nbsp;&nbsp;&nbsp;
  </td>
  <td class="control">
   Speed:
  </td>
  <td class="control">
  <a href="#" onclick="step='1';scspeed='50'" class="control">1</a>&nbsp;
  <a href="#" onclick="step='2';scspeed='40'" class="control">2</a>&nbsp; 
  <a href="#" onclick="step='2';scspeed='30'" class="control">3</a>&nbsp;
  <a href="#" onclick="step='2';scspeed='20'" class="control">4</a>&nbsp;
  <a href="#" onclick="step='3';scspeed='30'" class="control">5</a>&nbsp;
  <a href="#" onclick="step='3';scspeed='15'" class="control">6</a>&nbsp;
  <a href="#" onclick="step='4';scspeed='15'" class="control">7</a>&nbsp;
  <a href="#" onclick="step='5';scspeed='5'" class="control">8</a>&nbsp;
  <a href="#"  onclick="step='10';scspeed='5'" class="control">9</a>
   &nbsp;&nbsp;&nbsp;
   Display mode:
  <a onclick="document.getElementById('prom').style.filter='none'" class="control">Norm</a>&nbsp;
  <a onclick="document.getElementById('prom').style.filter='flipH'" class="control">Mirror</a>&nbsp;&nbsp;&nbsp;
   (Press "F11" for full screen)
  </tr>
  <tr  class="vali">
  <td colspan="3" class="vali">&nbsp;
  </td>
  </tr>
  </table>

<script language="JavaScript1.2">
var scspeed = 20
iens6=document.all||document.getElementById
ns4=document.layers
</script>
<div id="container">
<div id="contents">
</div>
 <div id="content" style="position:relative;width:100%;left:0;top:0;float:right;border:1px solid #CCC; z-index:-99">
<?php 

$id = $_GET['id'];

$sql = " SELECT * FROM input WHERE id = $id ";
//echo $sql;   
$sql = mysql_query($sql);
while ($data=mysql_fetch_array($sql)){
 $d_isi = $data["isi"]; 
}
?>
  <table cellpadding="0" cellspacing="0" border="0" width="100%">
   <tr>
    <td  id="prom" class="teks">
    <p><?php echo $d_isi;?></p></td>
   </tr>
  </table>
  <p class="cueprompter">disini tulisan kecil</p>
 </div>
</div>

</div>
<div>

<script type="text/javascript">
document.onkeyup = KeyCheck;
function KeyCheck(e){
 var KeyID = (window.event) ? event.keyCode : e.keyCode;
 switch(KeyID)
 {
case 112:
alert("nothing!!");}
}
</script>
<script language="JavaScript1.2">
var step=1
if (iens6){
 document.write('</div></div>')
 var contentobj=document.getElementById? document.getElementById("content") : document.all.content
 var contentheight=contentobj.offsetHeight
 if (document.getElementById&&!document.all){
     step=1
 }
}

else if(ns4){
 var contentobj=document.nscontainer.document.nscontent
 var contentheight=contentobj.clip.height
}
function fward() {
 if(window.scrolltimerup){
  clearTimeout(scrolltimerup)
 }
 if(iens6&&parseInt(contentobj.style.top)>=(contentheight*(-1)+100)){
  contentobj.style.top=parseInt(contentobj.style.top)-step
 }else if(ns4&&contentobj.top>=(contentheight*(-1)+100)){
  contentobj.top-=step
 }
 scrolltimerdown = setTimeout("fward()",scspeed)
}
function rverse() {
 if(window.scrolltimerdown){
  clearTimeout(scrolltimerdown)
 }
 if(iens6&&parseInt(contentobj.style.top)<=0){
  contentobj.style.top=parseInt(contentobj.style.top)+5
 }else if(ns4&&contentobj.top<=0){ 
  contentobj.top+=5
 }
 scrolltimerup = setTimeout("rverse()",scspeed) 
}

function stop() {
 if(window.scrolltimerup){
  clearTimeout(scrolltimerup)
 }
 if(window.scrolltimerdown){
  clearTimeout(scrolltimerdown)
 }
}

function pgup(){
 stop()
 if (iens6) {
  contentobj.style.top=0
 }
}

function getcontent_height(){
 contentheight=contentobj.offsetHeight
}
window.onload=getcontent_height

</script>
</body>

Anyone having problems with chat can be inputted but doesn’t show up anything? If you’re having the same problem with me, open chat.php file, then change the code below

if ($_GET['action'] == "chatheartbeat") { chatHeartbeat(); } 
if ($_GET['action'] == "sendchat") { sendChat(); } 
if ($_GET['action'] == "closechat") { closeChat(); } 
if ($_GET['action'] == "startchatsession") { startChatSession(); }

Change to

if (isset($_GET['action'])) { 
     if ($_GET['action'] == "chatheartbeat") { chatHeartbeat(); }  
     if ($_GET['action'] == "sendchat") { sendChat(); }  
     if ($_GET['action'] == "closechat") { closeChat(); }  
     if ($_GET['action'] == "startchatsession") { startChatSession(); }  
}

Already done? Teleprompter web base that you need to do is complete, with the chat feature for newscaster and author news, so they can communicate :D. Good luck with this tutorial.

No comments

, by Pandu Aji Wirawan

internet

How To Create Teleprompter Web Base III

Teleprompter Web Based

In this third parts, i will create a page that displays the results of the input from the author news, so that broadcasters can easily read news. For teleprompter web, I taken from the website cueprompter. I just added option menu of news which is already included by the author of news. So, news anchor can choose the news that will be read. Menu emerge from a database that is already made. For it file name is index.php. Before i create index.php, i created koneksi.php file that serves to connect to the database. This is the contents of koneksi.php file

<?php
mysql_connect("localhost","usernamedb","passdb");

mysql_select_db("namadatabase");

?>

I split page into two, each of page i give left id for left side and right id for right side. First i will discuss on the left side that i will give news list that can be selected by the broadcaster. Source of news that emerged came from news writter that submit through menuisi.php. ( Sections are discussed at Tutorial create a Teleprompter Web Base Part II).
This is html code for table that is used to showing a selection of news

<table class="listberita">
<tr><th>Pilihan Berita</th></tr>
        <tr><td> List berita muncul di sini</td></tr>
</table>

For retrieve news list of database, enter the code below in the table, but don’t put in the columns and rows.

<?php                
include "koneksi.php";
        $sql = " SELECT * FROM input ORDER BY judul ";
//echo $sql;   
$sql = mysql_query($sql);
while ($data=mysql_fetch_array($sql)){
$d_id = $data["id"];
$d_judul = $data["judul"];
?>

As for the displaying the news list that has been stored in the database, enter this code in the table rows

<tr><td color="#FFFFFF"><a href="index.php?id=<?php echo $d_id;?>"><?php echo $d_judul;?></a></td></tr>

Above code is in left id, as for right id i am using code from cuepropter.com

<table width="950px" cellpadding="0" cellspacing="0" border="0" bgcolor="#666666">
  <tr>
  <td class="control">
   <a href="Javascript:pgup()" class="control">PgUp^</a>
   &nbsp;
   <a href="Javascript:rverse()" class="control">&lt;&lt; REVERSE</a>&nbsp;
   <a href="Javascript:stop()" class="control">STOP <span class="stcontrol">||</span></a>&nbsp;
   <a href="Javascript:fward()" class="control">FORWARD &gt;&gt;</a>  
   &nbsp; &nbsp;&nbsp;&nbsp;
  </td>
  <td class="control">
   Speed:
  </td>
  <td class="control">
  <a href="#" onclick="step='1';scspeed='50'" class="control">1</a>&nbsp;
  <a href="#" onclick="step='2';scspeed='40'" class="control">2</a>&nbsp; 
  <a href="#" onclick="step='2';scspeed='30'" class="control">3</a>&nbsp;
  <a href="#" onclick="step='2';scspeed='20'" class="control">4</a>&nbsp;
  <a href="#" onclick="step='3';scspeed='30'" class="control">5</a>&nbsp;
  <a href="#" onclick="step='3';scspeed='15'" class="control">6</a>&nbsp;
  <a href="#" onclick="step='4';scspeed='15'" class="control">7</a>&nbsp;
  <a href="#" onclick="step='5';scspeed='5'" class="control">8</a>&nbsp;
  <a href="#"  onclick="step='10';scspeed='5'" class="control">9</a>
   &nbsp;&nbsp;&nbsp;
   Display mode:
  <a onclick="document.getElementById('prom').style.filter='none'" class="control">Norm</a>&nbsp;
  <a onclick="document.getElementById('prom').style.filter='flipH'" class="control">Mirror</a>&nbsp;&nbsp;&nbsp;
   (Press "F11" for full screen)
  </tr>
  <tr  class="vali">
  <td colspan="3" class="vali">&nbsp;
  </td>
  </tr>
  </table>


<script language="JavaScript1.2">
var scspeed = 20
iens6=document.all||document.getElementById
ns4=document.layers
</script>
<div id="container">
<div id="contents">
</div>
<div id="content" style="position:relative;width:100%;left:0;top:0;float:right;border:1px solid #CCC; z-index:-99">


  <table cellpadding="0" cellspacing="0" border="0" width="100%">
   <tr>
    <td  id="prom" class="teks">
    <p>Isi berita dari database</p></td>
   </tr>
  </table>
  <p class="cueprompter">disini tulisan kecil</p>
</div>
</div>


</div>
<div>


<script type="text/javascript">
document.onkeyup = KeyCheck;
function KeyCheck(e){
var KeyID = (window.event) ? event.keyCode : e.keyCode;
switch(KeyID)
{
case 112:
alert("nothing!!");}
}
</script>
<script language="JavaScript1.2">
var step=1
if (iens6){
document.write('</div></div>')
var contentobj=document.getElementById? document.getElementById("content") : document.all.content
var contentheight=contentobj.offsetHeight
if (document.getElementById&&!document.all){
     step=1
}
}

else if(ns4){
var contentobj=document.nscontainer.document.nscontent
var contentheight=contentobj.clip.height
}
function fward() {
if(window.scrolltimerup){
  clearTimeout(scrolltimerup)
}
if(iens6&&parseInt(contentobj.style.top)>=(contentheight*(-1)+100)){
  contentobj.style.top=parseInt(contentobj.style.top)-step
}else if(ns4&&contentobj.top>=(contentheight*(-1)+100)){
  contentobj.top-=step
}
scrolltimerdown = setTimeout("fward()",scspeed)
}
function rverse() {
if(window.scrolltimerdown){
  clearTimeout(scrolltimerdown)
}
if(iens6&&parseInt(contentobj.style.top)<=0){
  contentobj.style.top=parseInt(contentobj.style.top)+5
}else if(ns4&&contentobj.top<=0){ 
  contentobj.top+=5
}
scrolltimerup = setTimeout("rverse()",scspeed)
}

function stop() {
if(window.scrolltimerup){
  clearTimeout(scrolltimerup)
}
if(window.scrolltimerdown){
  clearTimeout(scrolltimerdown)
}
}

function pgup(){
stop()
if (iens6) {
  contentobj.style.top=0
}
}

function getcontent_height(){
contentheight=contentobj.offsetHeight
}
window.onload=getcontent_height


</script>

Enter this php code that serves to retrieve id of the database in div id content.

<?php 
$id = $_GET['id'];
$sql = " SELECT * FROM input WHERE id = $id ";
//echo $sql;   
$sql = mysql_query($sql);
while ($data=mysql_fetch_array($sql)){
$d_isi = $data["isi"];
}
?>

Enter php code below in the section where the content of news database is displayed

<?php echo $d_isi;?>

Are you confused by the row of code above? This is final file that i used

<html>
<head>
<title>Teleprompter</title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
<!-- Copyright Hannu Multanen 2005 - 2009 -->
<!-- www.cueprompter.com -->
<div id="badan">
<div id="left">
<table class="listberita">
<tr><th>Pilihan Berita</th></tr>
<?php                
include "koneksi.php";
$sql = " SELECT * FROM input ORDER BY judul ";
//echo $sql;   
$sql = mysql_query($sql);
while ($data=mysql_fetch_array($sql)){
$d_id = $data["id"];
$d_judul = $data["judul"];
?>
<tr><td color="#FFFFFF"><a href="index.php?id=<?php echo $d_id;?>"><?php echo $d_judul;?></a></td></tr>
<?php
}
?>
</table>
<br>
</div>
<div id="right">
  <table width="950px" cellpadding="0" cellspacing="0" border="0" bgcolor="#666666">
  <tr>
  <td class="control">
   <a href="Javascript:pgup()" class="control">PgUp^</a>
   &nbsp;
   <a href="Javascript:rverse()" class="control">&lt;&lt; REVERSE</a>&nbsp;
   <a href="Javascript:stop()" class="control">STOP <span class="stcontrol">||</span></a>&nbsp;
   <a href="Javascript:fward()" class="control">FORWARD &gt;&gt;</a>  
   &nbsp; &nbsp;&nbsp;&nbsp;
  </td>
  <td class="control">
   Speed:
  </td>
  <td class="control">
  <a href="#" onclick="step='1';scspeed='50'" class="control">1</a>&nbsp;
  <a href="#" onclick="step='2';scspeed='40'" class="control">2</a>&nbsp; 
  <a href="#" onclick="step='2';scspeed='30'" class="control">3</a>&nbsp;
  <a href="#" onclick="step='2';scspeed='20'" class="control">4</a>&nbsp;
  <a href="#" onclick="step='3';scspeed='30'" class="control">5</a>&nbsp;
  <a href="#" onclick="step='3';scspeed='15'" class="control">6</a>&nbsp;
  <a href="#" onclick="step='4';scspeed='15'" class="control">7</a>&nbsp;
  <a href="#" onclick="step='5';scspeed='5'" class="control">8</a>&nbsp;
  <a href="#"  onclick="step='10';scspeed='5'" class="control">9</a>
   &nbsp;&nbsp;&nbsp;
   Display mode:
  <a onclick="document.getElementById('prom').style.filter='none'" class="control">Norm</a>&nbsp;
  <a onclick="document.getElementById('prom').style.filter='flipH'" class="control">Mirror</a>&nbsp;&nbsp;&nbsp;
   (Press "F11" for full screen)
  </tr>
  <tr  class="vali">
  <td colspan="3" class="vali">&nbsp;
  </td>
  </tr>
  </table>

<script language="JavaScript1.2">
var scspeed = 20
iens6=document.all||document.getElementById
ns4=document.layers
</script>
<div id="container">
<div id="contents">
</div>
<div id="content" style="position:relative;width:100%;left:0;top:0;float:right;border:1px solid #CCC; z-index:-99">
<?php 
$id = $_GET['id'];
$sql = " SELECT * FROM input WHERE id = $id ";
//echo $sql;   
$sql = mysql_query($sql);
while ($data=mysql_fetch_array($sql)){
$d_isi = $data["isi"];
}
?>
  <table cellpadding="0" cellspacing="0" border="0" width="100%">
   <tr>
    <td  id="prom" class="teks">
    <p><?php echo $d_isi;?></p></td>
   </tr>
  </table>
  <p class="cueprompter">disini tulisan kecil</p>
</div>
</div>
</div>
<div>

<script type="text/javascript">
document.onkeyup = KeyCheck;
function KeyCheck(e){
var KeyID = (window.event) ? event.keyCode : e.keyCode;
switch(KeyID)
{
case 112:
alert("nothing!!");}
}
</script>
<script language="JavaScript1.2">
var step=1
if (iens6){
document.write('</div></div>')
var contentobj=document.getElementById? document.getElementById("content") : document.all.content
var contentheight=contentobj.offsetHeight
if (document.getElementById&&!document.all){
     step=1
}
}

else if(ns4){
var contentobj=document.nscontainer.document.nscontent
var contentheight=contentobj.clip.height
}
function fward() {
if(window.scrolltimerup){
  clearTimeout(scrolltimerup)
}
if(iens6&&parseInt(contentobj.style.top)>=(contentheight*(-1)+100)){
  contentobj.style.top=parseInt(contentobj.style.top)-step
}else if(ns4&&contentobj.top>=(contentheight*(-1)+100)){
  contentobj.top-=step
}
scrolltimerdown = setTimeout("fward()",scspeed)
}
function rverse() {
if(window.scrolltimerdown){
  clearTimeout(scrolltimerdown)
}
if(iens6&&parseInt(contentobj.style.top)<=0){
  contentobj.style.top=parseInt(contentobj.style.top)+5
}else if(ns4&&contentobj.top<=0){ 
  contentobj.top+=5
}
scrolltimerup = setTimeout("rverse()",scspeed)
}
function stop() {
if(window.scrolltimerup){
  clearTimeout(scrolltimerup)
}
if(window.scrolltimerdown){
  clearTimeout(scrolltimerdown)
}
}
function pgup(){
stop()
if (iens6) {
  contentobj.style.top=0
}
}
function getcontent_height(){
contentheight=contentobj.offsetHeight
}
window.onload=getcontent_height
</script>
</body>

Hopefully you guys are already understand with writings and the line of code above :D

No comments

, by Pandu Aji Wirawan

internet

How To Create Teleprompter Web Base II

submit form

In the first part, I’ve written down how to create the database. In the second part, i will discuss how to create a form for make input into database that we have created. In this section, we will create two php file :
1. Isi.php is a form to enter data into database.
2. Addtele.php is the liasion between the for content by database

Create Input Form to Database for User

This is the code from a isi.php file

<form class="form" method="post" action="addtele.php">  




    <p class="judul"> 

        <input type="text" name="judul" id="judul" value="<?php echo isset($_POST['judul']) ? $_POST['judul'] : '';?>" /> 

        <label for="judul">Judul</label> 

    </p> 



    <p class="acara"> 

        <input type="acara" name="acara" id="acara" value="<?php echo isset($_POST['acara']) ? $_POST['acara'] : '';?>"/> 

        <label for="acara">Acara</label> 

    </p> 



    <p class="creator"> 

        <input type="creator" name="creator" id="creator" value="<?php echo isset($_POST['creator']) ? $_POST['creator'] : '';?>" /> 

        <label for="creator">Author</label> 

    </p> 



    <p class="isi"> 

        <textarea name="isi" value="<?php echo isset($_POST['isi']) ? $_POST['isi'] : '';?>"></textarea> 

    </p> 



    <p class="submit"> 

        <input type="submit" value="Kirim" /> 

    </p> 



</form>

To remeber is the parameter name must be the same as the column name in database. Input with parameter name judul will be stored in a column judul also. If the name doesn’t match with the database then eror messages will appear, variable not recognized. To enter data in a database, I need action from the form that i’ve saved on a file addtele.php that Contains functions for connecting to the database, then choose database that will be included, after that create query MySQL and check out their work or whether the input to a database. Let’s we create file addtele.php.

Connecting Form to Database

The first, We define variable for establish a connection to a database with

session_start();


 define('DB_HOST', 'localhost');

    define('DB_USER', 'userdb');

    define('DB_PASSWORD', 'passdb');

    define('DB_DATABASE', 'namadb');

After defining a variable required to login, then connect to the database with

$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);


 if(!$link) {

  die('Gagal koneksi dengan server: ' . mysql_error());

 }

If they fail we will get error message failed connect to server. Usually this happens if variable for the connection to the database is false. Like database name, database username, password. If this is succesfull we are continuing with the function for choose the database.

$db = mysql_select_db(DB_DATABASE);


 if(!$db) {

  die("Database tidak dapat dipilih");

 }



 function clean($str) {

  $str = @trim($str);

  if(get_magic_quotes_gpc()) {

   $str = stripslashes($str);

  }

  return mysql_real_escape_string($str);

 }

After selecting the database, then we create query MySQL, that is the process input data to database

$qry = "INSERT INTO input(judul, isi, acara, creator) VALUES('".$_POST['judul']."','".$_POST['isi']."','".$_POST['acara']."','".$_POST['creator']."')";

 $result = @mysql_query($qry);

If we already submit to the database, then we check whether the inputted data already entered to the database with

if($result) {


  header("location: isi.php");

  exit();

 }else {

  die("GAGAL!");

 }

If this is succesfull, then we will go into isi.php page again so get the input. If they fail we will get error message failed. Why did throw it to the php page when successful? Because this is the page that is used by the author of the story so we don’t need to have access to the teleprompter page. Confused by the sequence? This is the contents of addtele.php file

<?php


 session_start();

 define('DB_HOST', 'localhost');

    define('DB_USER', 'mmb');

    define('DB_PASSWORD', 'mmb');

    define('DB_DATABASE', 'teleprompter');


 //koneksi ke database.

 $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

 if(!$link) {

  die('Gagal koneksi dengan server: ' . mysql_error());

 }


 //pilih database

 $db = mysql_select_db(DB_DATABASE);
 if(!$db) {
  die("Database tidak dapat dipilih");
 }
 function clean($str) {
  $str = @trim($str);
  if(get_magic_quotes_gpc()) {
   $str = stripslashes($str);
  }

  return mysql_real_escape_string($str);
 }
 //Membuat Query MySQL

 $qry = "INSERT INTO input(judul, isi, acara, creator) VALUES('".$_POST['judul']."','".$_POST['isi']."','".$_POST['acara']."','".$_POST['creator']."')";

 $result = @mysql_query($qry);
 //Mengecek keberhasilan
 if($result) {
  header("location: isi.php");
  exit();
 }else {
  die("GAGAL!");

 }

?>

NB: Screenshot form above already added with css, so it has the look more interesting than the form that created without css. Please amended if there is a fault of my explanation :D

No comments

, by Pandu Aji Wirawan

Pages

PANDUAJI.COM

Blaze Video Editor Giveaway

Step 1: Adding Video

Step 2: Editing Video

Step 3: Convert Video

System Requirements

Install Solaar Logitech Wireless Driver on Linux Ubuntu

How to Instal Solaar Logitech Wireless Device on Ubuntu

How To Create Teleprompter Web Base IV

How To Create Teleprompter Web Base III

How To Create Teleprompter Web Base II

Create Input Form to Database for User

Connecting Form to Database

Flickr Images

Blog Archive

Popular Posts

Labels

My Business

Pages

PANDUAJI.COM

Blaze Video Editor Giveaway

Step 1: Adding Video

Step 2: Editing Video

Step 3: Convert Video

System Requirements

Install Solaar Logitech Wireless Driver on Linux Ubuntu

How to Instal Solaar Logitech Wireless Device on Ubuntu

How To Create Teleprompter Web Base IV

How To Create Teleprompter Web Base III

How To Create Teleprompter Web Base II

Create Input Form to Database for User

Connecting Form to Database

Flickr Images

Blog Archive

Popular Posts

Labels

My Business

Subscribe