Lowyat.NET: Latest topics by fanco

Desa Restu 2, Salak Tinggi, Sepang

fanco — Thu, 27 Jun 2013 19:53:03 +0800

Desa Restu 2, Salak Tinggi, Sepang....
- Leasehold
- 20x55 n 20x60
- Price range RM349k to 364k
- no deposit
- location near kota warisan and unfinish flyover in salak tinggi...

anyone bought this house?is it worth to buy?
need advice for own stay...

SQL connection using C sharp

fanco — Wed, 29 Sep 2010 01:00:35 +0800

i building c sharp application that can access SQL server for sending and receiving data, but i have problem in connection because im using outside server n not localhost.

this sample of my code:

CODE

string Server = "111.222.333.444";
string Username = "my_username";
string Password = "my_password";
string Database = "my_database";

string ConnectionString = "Data Source=" + Server + ";";
ConnectionString += "User ID=" + Username + ";";
ConnectionString += "Password=" + Password + ";";
ConnectionString += "Initial Catalog=" + Database;

#endregion

#region Try to establish a connection to the database

SqlConnection SQLConnection = new SqlConnection();

try
{
SQLConnection.ConnectionString = ConnectionString;
SQLConnection.Open();

// You can get the server version
// SQLConnection.ServerVersion
}
catch (Exception Ex)
{
// Try to close the connection
if (SQLConnection != null)
SQLConnection.Dispose();

// Create a (useful) error message
string ErrorMessage = "A error occurred while trying to connect to the server.";
ErrorMessage += Environment.NewLine;
ErrorMessage += Environment.NewLine;
ErrorMessage += Ex.Message;

// Show error message (this = the parent Form object)
MessageBox.Show(this, ErrorMessage, "Connection error", MessageBoxButtons.OK, MessageBoxIcon.Error);

// Stop here
return;
}

i already try my domain website for data source but still cant connect...

read data form device and detecting devices

fanco — Wed, 04 Aug 2010 17:36:12 +0800

im developing ph monitoring & management system...
now i have problem in read data from device...i send and read data from my ph sensor using wireless device...the system will on 24 hour n the data will be update each 5 minute...now im using readtimeout and its only read for couple of second only...how do i want to display data if the sensor retrieve data without user to click read button??...this sample of my current coding

CODE

private void button1_Click(object sender, EventArgs e)
{
string nameport;
string dis;
nameport = comboPort.SelectedItem.ToString();
textPort.Text = namaport.ToString();
xbee = new SerialPort(nameport, 9600, Parity.None, 8, StopBits.One);
xbee.Open();
string str1;
int slp1 = 100;
for (int x = 0; x < 5; x++) // 5 trys for response, increasing delay each try
{
Thread.Sleep(slp1);
if (xbee.BytesToRead > 0)
{
byte[] rsp = new byte[xbee.BytesToRead];
xbee.Read(rsp, 0, xbee.BytesToRead);
str1 = ToHexDigits(rsp);
MessageBox.Show(str1);
break;
}

slp1 += 500;
}
xbee.Close();
}

my other problem is to set portname without user to select portname like 'COM1'...right now user have to know which port the device connected before selecting device portname for open port...

error in reload page in php n javascript

fanco — Wed, 21 Jul 2010 01:52:14 +0800

i developing system that can display data that sent by sensor to sql server...
i have problem in display latest data...

the main page is papar.php
mysql_connect.php is for connect to database
subpapar.php is the file that i want to refresh or reload every 3 second...

this is sample some of my code...

CODE

if possible i want to call reload function not in <body>, coz most of the page i include it

» Click to show Spoiler - click again to hide... «

php configuration problem

fanco — Fri, 01 Jan 2010 09:49:53 +0800

i install apache n php separately because i have to link apache n tomcat server.
im using apache2.2 n php5.
i already write this on httpd.conf:

CODE

LoadModule php5_module "c:/php/php5apache2_2.dll"
AddType application/x-httpd-php .php
PHPIniDir "c:/php"

the error is:

QUOTE

httpd.exe: Syntax error on line of C:/Program Files/Apache Software Foundation/Apache2.2/conf/httpd.conf: Cannot load C:/php/php5apache2_2.dll into server: correcr. Reinstalling the application may fix this problem.

apache server still cannot run
do i have to adjust anything on php.ini?

undefined function mysql_connect()

fanco — Wed, 16 Dec 2009 17:04:51 +0800

im installed the apache, php n mysql separately, because i have to connect server...my system is using jsp & php, thats why i cannot using a package installer like appserv or wamp...after installed or the applicatio i cannot run php file that have sql coding...

this is some of the error:

CODE

Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\jadual\classes\itdatabase.php on line 4

i try to run on other pc that installed using appserv...the web page is doing ok, accept for the jsp file...
this is my first time integrate php with jsp

need help: assembly language

fanco — Fri, 17 Apr 2009 01:00:39 +0800

hello everyone.
i have asgnmnt that must input string into array and compare. but i only manage to input one string into an array n cannot put more than that...i already google, got to library, and ask my friend...but still dont have the solution...most of it, i found how to input integer into array but not string...

actually that is not my main problem, my problem is to compare 2 string from string that i input...

here are some declaration for variable:

» Click to show Spoiler - click again to hide... «

here are sample of coding for input string:

» Click to show Spoiler - click again to hide... «

the input will store in character1

below are various of method that i try...
cmsb:

» Click to show Spoiler - click again to hide... «

Str_compare:

» Click to show Spoiler - click again to hide... «

cmp:

» Click to show Spoiler - click again to hide... «

lengthof:(this one i to try to compare length of string, but it still compare the array n not what inside it)

» Click to show Spoiler - click again to hide... «

all the result will input into variable smallChar....

all of it compare the length of array but not string that have been input....
all of my classmate still don't have the solution n my lecture wont give the solution or sample of it...
i already try my best, but still cannot...
plzzzzzzzz help me....

Stunt 4 Rider

fanco — Sun, 01 Mar 2009 10:03:19 +0800

This is my first blog....this blog teach about how to do stunt with motorbike...the content in my blog are based on other forumer n stunter in stuntlife.com and other recourses...

comment are welcome, thanx

import excel into database

fanco — Mon, 23 Jun 2008 09:10:01 +0800

sorry for asking again but i need help in import excel and insert the data from excel to database php...
below is sample of my coding...i try to set the variable and display it to see if the coding working or not.... but didnt work...

CODE

<?php
$data = array();

function add_person( $id, $nama, $barcode, $ic, $jbtn, $jwtn, $jenis, $status )
{
global $data;

$data []= array
(
'id' => $id,
'nama' => $nama,
'barcode' => $barcode,
'ic' => $ic,
'jbtn' => $jbtn,
'jwtn' => $jwtn,
'jenis' => $jenis,
'status' => $status,
);
}

if ( $_FILES['file']['tmp_name'] )
{
$dom = DOMDocument::load( $_FILES['file']['tmp_name'] );
$rows = $dom->getElementsByTagName( 'Row' );
$first_row = true;
foreach ($rows as $row)
{
if ( !$first_row )
{
$id = "";
$nama = "";
$barcode = "";
$ic = "";
$jbtn = "";
$jwtn = "";
$jenis = "";
$status = "";

$index = 1;
$cells = $row->getElementsByTagName( 'Cell' );
foreach( $cells as $cell )
{
$ind = $cell->getAttribute( 'Index' );
if ( $ind != null ) $index = $ind;

if ( $index == 1 ) $id = $cell->nodeValue;
if ( $index == 2 ) $nama = $cell->nodeValue;
if ( $index == 3 ) $barcode= $cell->nodeValue;
if ( $index == 4 ) $ic = $cell->nodeValue;
if ( $index == 5 ) $jbtn = $cell->nodeValue;
if ( $index == 6 ) $jwtn = $cell->nodeValue;
if ( $index == 7 ) $jenis = $cell->nodeValue;
if ( $index == 8 ) $status = $cell->nodeValue;

$index += 1;
}
add_person( $id, $nama, $barcode, $ic, $jbtn, $jwtn, $jenis, $status );
}
$first_row = false;
}
}
?>
<html>
<body>
<table>
<tr>
<th>id</th>
<th>nama</th>
<th>barcode</th>
<th>ic</th>
<th>jbtn</th>
<th>jwtn</th>
<th>jenis</th>
<th>status</th>
</tr>
<?php foreach( $data as $row ) { ?>
<tr>
<td><?php echo( $row['id'] ); ?></td>
<td><?php echo( $row['nama'] ); ?></td>
<td><?php echo( $row['barcode'] ); ?></td>
<td><?php echo( $row['ic'] ); ?></td>
<td><?php echo( $row['jbtn'] ); ?></td>
<td><?php echo( $row['jwtn'] ); ?></td>
<td><?php echo( $row['jenis'] ); ?></td>
<td><?php echo( $row['status'] ); ?></td>
</tr>
<?php } ?>
</table>
</body>
</html>

this is the sample of data in excel....

NO STAF NAMA BARCODE NOKP KOD JABATAN KOD JAWATAN JENIS KOD STATUS
5353 abc 1234 9876543210 001 002 E Y
5354 qwe 4321 7896543210 001 003 E A
5355 zxc 7894 6789543210 002 006 B Y

_______________________
sorry, already find the solution...i already modify the coding.... thanx for view this thread....

go to previous page using php

fanco — Thu, 12 Jun 2008 12:47:27 +0800

i'm trying 2 find a way to go to the previous page without using $_GET or session...

this is how it work:
user will view list staff that attend for previous event...below are example url...

CODE

http://localhost/system_cict/report_event.php?id=141&who=at&s=10&np=20

the user will select one of the user to view more detail about the staff....
below are example url...

CODE

http://localhost/system_cict/view_user_report.php?id=zxc

after that i want to put some link in view_user_report.php to go back to previous page, like below url:

CODE

http://localhost/system_cict/report_event.php?id=141&who=at&s=10&np=20

need help: sql error

fanco — Tue, 27 May 2008 12:19:15 +0800

i'm want to create web page for search...
in my search page, user must enter the name(text) and select which department (combobox) they want to search
this part of my search function...

CODE

// Get the search variable from URL
$var = @$_GET['search_name'];
$trimmed = trim($var); //trim whitespace from the stored variable

$var_bhgn = @$_GET['search_department'];
$trimmed_bhgn = trim($var_bhgn);

//connect to my database
require_once ('mysql_connect.php');

$query = "SELECT * FROM individu WHERE name LIKE \"%$trimmed%\" AND id_bhgn='$trimmed_bhgn' ORDER BY name";

$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);

my page show error in =
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\cict\view_result_name02.php on line 71

i still can't find what the problem is...is it sql error???
need help ASAP....

upload and rename....

fanco — Wed, 21 May 2008 12:32:05 +0800

CODE

<?php
// This page edits a user.
// This page is accessed through view_users.php.

$page_title = 'Upload Photo';
include ('./includes/header02.html');

// If no session value is present, redirect the user.
if (!isset($_COOKIE['user_id'])) {

// Start defining the URL.
$url = 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']);
// Check for a trailing slash.
if ((substr($url, -1) == '/') OR (substr($url, -1) == '\\') ) {
$url = substr ($url, 0, -1); // Chop off the slash.
}
/*if ($_COOKIE['id_level']!="00"){
exit();}*/
$url .= '/index.php'; // Add the page.
header("Location: $url");
exit(); // Quit the script.
}
elseif($_COOKIE['id_level']!="02"){
// Start defining the URL.
$url = 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']);
// Check for a trailing slash.
if ((substr($url, -1) == '/') OR (substr($url, -1) == '\\') ) {
$url = substr ($url, 0, -1); // Chop off the slash.
}
$url .= '/index.php'; // Add the page.
header("Location: $url");
exit(); // Quit the script.
}

$id=$_COOKIE['user_id'];

if (isset($_POST['submitted'])) {
if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/png")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/jpg"))
&& ($_FILES["file"]["size"] < 2000000))
{
if ($_FILES["file"]["error"] > 0)
{
echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
}
else
{
echo "Upload: " . $_FILES["file"]["name"] . "<br />";
echo "Type: " . $_FILES["file"]["type"] . "<br />";
echo "Size: " . ($_FILES["file"]["size"] / 2000000) . " Mb<br />";
echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";
}
}
else
{
echo "Invalid file";
}
}

?>

<p>Your picture must:</p>
<ul>
<li>Picture format(jpg,gif,png,jpeg)</li>
<li>Less than 2Mb</li>
</ul>
<br />

<form action="upload_photo02.php" method="post" enctype="multipart/form-data">
Filename: <input type="file" name="file" id="file" size="30"/>
<br /><br />
<input type="submit" name="submit" value="Submit" />
<input type="hidden" name="submitted" value="TRUE" />
</form>
<?php include ('./includes/footers.html'); ?>

i want to rename the picture after each download with out delete the format '.jpg'...
if the picture already exist, i want to overwrite it...

rename it according to user id..
if the user id ad050765, the name of the pic is ad050765.jpg....

need help ASAP.....

need help:upload and rename picture

fanco — Wed, 21 May 2008 09:48:44 +0800

CODE

$id=$_COOKIE[user_id];

if (isset($_POST['submitted'])) {
if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/png")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/pjpeg"))
&& ($_FILES["file"]["size"] < 20000))
{
if ($_FILES["file"]["error"] > 0)
{
echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
}
else
{
echo "Upload: " . $_FILES["file"]["name"] . "<br />";
echo "Type: " . $_FILES["file"]["type"] . "<br />";
echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";
if (file_exists("IMGstaff/" . $_FILES["file"]["name"]))
{
echo $_FILES["file"]["name"] . " already exists. ";
}
else
{
move_uploaded_file($_FILES["file"]["tmp_name"],
"IMGstaff/" . $_FILES["file"]["name"]);
echo "Stored in: " . "IMGstaff/" . $_FILES["file"]["name"];
}
}
}
else
{
echo "Invalid file";
}
}

Flash: Import scene?

fanco — Wed, 23 Jan 2008 23:29:38 +0800

i'm trying to import scene from other .fla but still donno how to import...
the reason because there are more than 1 .fla is each file was make from different person...
and each .fla have link to theire own scene....
i try to import as .swf,but the result didn't go the way i expected....
i need help from all of u ASAP...coz the dead line is near...

degree(software vs multimedia)

fanco — Sun, 07 Oct 2007 13:18:43 +0800

i'm student in utm kl n taking dip. in science comp(multimedia).... this is my last year n i need ur guide for choosing my course in degree...it's hard for me to choose between continue degree in software engineering or multimedia...
i like to develop web site, creating media application n develop database....

i need to know what kind of software that we learn n which gov u is better(coz i not from a rich family).for now i'm choosing utm, coz i want to start my freelancer in jhr n it's near to my house...

i need guidance from all of u...thanx