Lowyat.NET: Latest topics by alwinc

[WTS] BRAND NEW SURFACE PRO 4 ITEM SOLD!

alwinc — Mon, 14 Nov 2016 18:24:07 +0800

Item(s): Microsoft Surface Pro 4 i5 12.3" 4GB 128GB + Type Pad ITEM SOLD!!!!

Package includes: Complete with Typepad

Price: Rm3500 || ORIGINAL PRICE RM4xxxx

Warranty: FULL

Dealing method: COD

Location of seller: SUNWAY / PUCHONG

Contact method/details: PM

Age of item: BRAND NEW

---

Item(s) conditions: BRAND NEW

Picture:

ITEM SOLD!!!!

Reason for sale: NOT USING

Need help in php

alwinc — Fri, 27 Sep 2013 14:05:07 +0800

Please help:

QUOTE

print_r($this->item->extra_fields);

output:

QUOTE

[{"id":"4","value":"icon-management.png"},{"id":"11","value":"take-a-quiz?quiz_id=3"}]

how do i get the value of the id 4?

i tried the following but it doesn't work:

QUOTE

foreach ($this->item->extra_fields as $key=>$extraField):
if($extraField->id == "4"):
$thumbnail_url = $extraField->value;
endif;
endforeach;
?>

S&P Agreement + Loan Agreement Fees

alwinc — Tue, 20 Aug 2013 00:23:54 +0800

By referring to the quoted prices for both Loan agreement and S&P agreement for 585K property. Considered expensive?

S&P Agreement (RM16500)
Stamp Duty : 11,550
Legal Fees : 4950

Loan Agreement (RM6900)
Stamp Duty : 2925
Legal Fees : 3975

how to get current checked radio button value?

alwinc — Sun, 03 Mar 2013 15:17:50 +0800

Seek for advice how to get the current checked radio value instead of previous checked value?

function assignRadioValue() {
var params = $("input[name=radioOption]:checked").val();
alert(params);
}

<div id="radio">
<input type="radio" id="radio1" name="radioOption" onClick="assignRadioValue()" value="zero"/><label for="radio1">Choice 1</label>
<input type="radio" id="radio1" name="radioOption" onClick="assignRadioValue()" checked="checked" value="first"/><label for="radio2">Choice 2</label>
<input type="radio" id="radio2" name="radioOption" onClick="assignRadioValue()" value="second"/><label for="radio3">Choice 3</label>
<input type="radio" id="radio3" name="radioOption" onClick="assignRadioValue()" value="third"/><label for="radio3">Choice 3</label>
</div>

---solved

alwinc — Fri, 01 Mar 2013 15:18:26 +0800

---solved

php looping error to display saved data on form

alwinc — Mon, 18 Feb 2013 10:56:43 +0800

Please help with the following looping error to display saved data onto form.

QUOTE

//get all the colors from 'SELECT color_id, color_name FROM #__product_colors';
$colorlist

//get all the stored values "SELECT colour_id, files_id, min_value, max_value FROM #__product_files_colors_map";
$arraySelectedColors

$noOfSelected = count($arraySelectedColors);

print_r(arraySelectedColors); => Array ( [0] => Array ( [0] => 7 [1] => 234 [2] => 11 [3] => 11 ) [1] => Array ( [0] => 6 [1] => 234 [2] => 22 [3] => 22 ) )

-------------------------------------------------------------------------------

$colorRangeOutput .= '<table cellpading="0" cellspacing="0" style="border: 1px dotted #555555;" >';
$colorRangeOutput .= '<tr bgcolor="#D3D3D3"> <td></td> <td style="padding: 5px; text-align: center;">Colours</td> <td style="padding: 5px; text-align: center;">Min Value</td> <td style="padding: 5px; text-align: center;">Max Value</td> </tr>';
$c = true;

foreach ($colorlist as $color){

$selectedCheck = '';
$rowMinValue = '';
$rowMaxValue = '';

//loop row colors
if ($c = !$c) {
$bgcolor = '#FFFFFF';
} else {
$bgcolor = '#F2FAF8';
}

$rowColorId = $color->color_id;
$rowColorName = $color->color_name;

//looping saved records to generate value
for ($i=0; $i<$noOfSelected; $i++)
{
$arrItem = $arraySelectedColors[$i];

$rowSelectedColorId = $arrItem[0];
$rowFileId = $arrItem[1];
$rowMinValue = $arrItem[2];
$rowMaxValue = $arrItem[3];

if ($rowSelectedColorId = $rowColorId)
{
$selectedCheck = " checked ";
$selectedMinValue = $rowMinValue;
$selectedMaxValue = $rowMaxValue;

} //if $rowSelectedColorId = $rowColorId

//do not display checkbox if value is not set
if (isset($rowColorId)) {
//looping checkboxes
$colorRangeOutput .= '<tr bgcolor="'. $bgcolor .'">';
$colorRangeOutput .= '<td> <input type="checkbox" id="color_id" name="color_id['. $rowColorId .']" value="' . $rowColorId . '" '. $selectedCheck .' ></td> ';
$colorRangeOutput .= '<td>' . $rowColorName . ' </td> ';
$colorRangeOutput .= '<td> <input class="text_area" type="text" name="minRange['. $rowColorId .']" size="15" value="'. $selectedMinValue .'" /> </td>';
$colorRangeOutput .= '<td> <input class="text_area" type="text" name="maxRange['. $rowColorId .']" size="15" value="'. $selectedMaxValue .'" /> </td>';
$colorRangeOutput .= '</td></tr>';
}

}

}

$colorRangeOutput .= '</table>';

PHP looping to save into database

alwinc — Tue, 05 Feb 2013 10:31:27 +0800

Tried to loop the following data & save into database. Need advices on looping to get the correct data to save.

QUOTE

//looping checkboxes
$colorRangeOutput .= '<table>';
foreach ($colorlist as $color)
{

$rowColorId = $color->color_id;
$rowColorName = $color->color_name;

$selectedCheck = '';
$selectedMinValue = '';

$colorRangeOutput .= '<tr>';
$colorRangeOutput .= '<td> <input type="checkbox" id="color_id" name="color_id[]" value="' . $rowColorId . '" '. $selectedCheck .' ></td> ';
$colorRangeOutput .= '<td>' . $rowColorName . ' </td> ';
$colorRangeOutput .= '<td> <input class="text_area" type="text" name="minRange[]" size="20" value=" '. $selectedMinValue .' " /> </td>';
$colorRangeOutput .= '<td> <input class="text_area" type="text" name="maxRange[]" size="20" value=" '. $selectedMaxValue .'" /> </td>';
$colorRangeOutput .= '</td></tr>';

}

$colorRangeOutput .= '</table>';
echo $colorRangeOutput ;

QUOTE

$color_ids = $_POST['color_id'];
$minRange = $_POST['minRange'];
$maxRange = $_POST['maxRange'];

print_r($color_ids);
print_r($minRange);
print_r($maxRange);

Outputs:
Array ( [0] => 7 [1] => 6 )
Array ( [0] => [1] => 12 [2] => 56 [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => [13] => [14] => [15] => [16] => [17] => )
Array ( [0] => [1] => 34 [2] => 78 [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => [13] => [14] => [15] => [16] => [17] => )

   //color_ids index no. is not the same as minRange/maxRange's, the for loops seems not suitable, need advice on this
for ($i=0;$i<count($color_ids);$i++)
   {

$colorId = $color_ids[$i];
$min = $minRange[$i];
$max = $maxRange[$i];

   $sqlstat = "INSERT INTO files_colors_map (colour_id, files_id, min_range, max_range ) VALUES ( $colorId, $selectedFileId, $min, $max)";
$db->setQuery($sqlstat);
if (!$db->execute())
   {
   return false;
   }
   }

Php IF statement inside Switch condition

alwinc — Sat, 26 Jan 2013 14:43:30 +0800

Hi guys,

Please advice if the syntax is wrong. Very much appreciated!

QUOTE

switch ($rowAccess) {

case "1":
if ( $rowColorId == 32 )
{
echo '<tr><td> <img border="0" src="/images/small/pdf-icon-file.png"><a target="_blank" href="userfiles/file/' . $rowFname . '">' . $rowFileName . '</a></td> <td> <div class="color-box" style="background-color:' . str_replace(',',';"></div><div class="no-color-box" style="background-color:',$rowColorCode) . ';"></div></td></tr> ';
}

else
{
echo '<tr><td> <img border="0" src="/images/small/pdf-icon-file.png"><a target="_blank" href="userfiles/file/' . $rowFname . '">' . $rowFileName . '</a></td> <td> <div class="color-box" style="background-color:' . str_replace(',',';"></div><div class="color-box" style="background-color:',$rowColorCode) . ';"></div></td></tr> ';
}

break;

default:

if ( $rowColorId == 32 )
{
echo '<tr><td><img border="0" src="/images/small/restricted-file-icon.png"><img border="0" src="/images/small/pdf-icon-file.png"> <a target="_blank" href="userfiles/file/' . $rowFname . '">' . $rowFileName . '</a></td> <td> <div class="color-box" style="background-color:' . str_replace(',',';"></div><div class="no-color-box" style="background-color:',$rowColorCode) . ';"></div></td></tr> ';
}

else
{
echo '<tr><td><img border="0" src="/images/small/restricted-file-icon.png"><img border="0" src="/images/small/pdf-icon-file.png"> <a target="_blank" href="userfiles/file/' . $rowFname . '">' . $rowFileName . '</a></td> <td> <div class="color-box" style="background-color:' . str_replace(',',';"></div><div class="color-box" style="background-color:',$rowColorCode) . ';"></div></td></tr> ';
}
break;
}

Remove duplicated elements from array and re-index

alwinc — Thu, 10 Jan 2013 13:51:32 +0800

Hi, how do i remove all the duplicated and remains only the unique value/elements in array.

e.g.

Array with duplicated elements :

QUOTE

print_r($arrCatList);

Array ( [0] => 32 [1] => 32 [2] => 32 [3] => 32 [4] => 42 [5] => 41 [6] => 41 [7] => 41 [8] => 41 [9] => 41 [10] => 41 [11] => 32 )

Have tried the array_unique() method, it seems like it displaying only unique elements but not removing it by looking at the array index numbers.

QUOTE

$distinctCatList = array_unique($arrCatList);
print_r($distinctCatList );
------------------------------------------------------
Array ( [0] => 32 [4] => 42 [5] => 41 )

Encode ™ as ™ in php mysql databases

alwinc — Thu, 10 Jan 2013 11:10:15 +0800

Hi guys,

i have a problem displaying ™ from database. In order to make ™ display properly on html page, it must be in ™ form when saved to database.

Am not sure how PHP or MYSQL encodes the ™ before saving to database.

Please advice

Loop DB results to Remove duplicated elements

alwinc — Sun, 23 Dec 2012 12:23:32 +0800

Want to ask how to loop to remove duplicated DB results and to generate better listing results.

QUOTE

$con = mysql_connect("localhost", "root", "");

if (!$con)
{
die('Could not connect: ' . mysql_error());
}

$db_selected = mysql_select_db("db_products_com",$con);

$sql = "SELECT jc.title, f.fname, c.color_code, f.file_id FROM product_files f, product_colors c, product_files_colors_map fcm, categories jc where
c.color_id = fcm.colour_id AND fcm.files_id = f.file_id AND f.product_id = $productId AND
jc.extension = 'product.file' AND f.cat_id = jc.id AND f.published = '1' AND f.access IN ($user_levels) ";

$result = mysql_query($sql,$con);

while ($row = mysql_fetch_object($result))

{
    $arrRecordList[] = array($row->title, $row->fname, $row->color_code, $row->file_id );
}

mysql_close($con);

//loop the files
    $output .= '';

for($i=0;$i<count($arrRecordList);$i++) {

$arrItem = $arrRecordList[$i];

    $rowTitle = $arrItem[0];
    $rowFname = $arrItem[1];
$rowColorCode = $arrItem[2];
$rowFileId = $arrItem[3];

$output .= ' '. $rowTitle . ' : <a href="' . $rowFname . '">' . $rowFname . '</a> ' . $rowColorCode . ' <br/>';
}
$output .= '';

echo $output;
?>

Currently, my codes above generating the following results. Those highlighted were duplicated records but with different colors which the particular file ties to. How can i loop the files listing to show only distinct file with its respective color codes tie to?

e.g. : File 1 #c6033 #feef00 #ec8500 #de2405 #c6033f

QUOTE

Attachments : File1 - Catalogue-v5 #de2405
Attachments : File1 - Catalogue-v5 #c6033f
Attachments : File1 - Catalogue -v3 #feef00
Attachments : File1 - Catalogue -v3 #ec8500
Attachments : File1 - Catalogue -v3 #de2405
Attachments : File1 - Catalogue -v3 #c6033f
Attachments : File2 - Catalogue-v4 #1469b8
Attachments : File2 - Catalogue-v4 #52b20c
Attachments : Mini DomiLED AlInGaP DNP-SJS-NP2-1-I3 - Catalogue-v6 #98dc2e
Attachments : File3 - Catalogue-v4 #feef00
Attachments : File3 - Catalogue-v4 #de2405
Attachments : File3 - Catalogue-v4 #ca0303

SQL statement select DISTINT need help

alwinc — Mon, 10 Dec 2012 11:57:23 +0800

my sql query :

QUOTE

SELECT DISTINCT (
c.color_name
), c.color_id, f.file_id
FROM atjm_dominantproduct_files f, atjm_dominantproduct_colors c, atjm_dominantproduct_files_colors_map fcm
WHERE f.product_id = '1'
AND f.file_id = fcm.files_id
AND fcm.colour_id = c.color_id
LIMIT 0 , 30

SQL Results:

QUOTE

color_name color_id file_id
Hyper Red 6 2
Super Red 7 2
Hyper Red 6 1
Super Red 7 1
Reda 9 2
Amber 10 2

mysql_fetch_object retrieve database records

alwinc — Thu, 06 Dec 2012 10:44:32 +0800

I fetching database records using this way:

QUOTE

$sql = 'SELECT id, name FROM products WHERE catid = "26"';
$result = mysql_query($sql,$con);

while ($row = mysql_fetch_object($result))
{
$arraydbRecord1[] = array($row->id, $row->name);
}

and the output is :

QUOTE

Array ( [0] => Array ( [0] => 6 [1] => Product1 ) [1] => Array ( [0] => 5 [1] => Product2 ) [2] => Array ( [0] => 4 [1] => Product3 ) [3] => Array ( [0] => 7 [1] => Product4 ) )

Is it possible to convert the output format into an array like this ?

QUOTE

array(array('6','Product1'),array('5','Mini Product2'),array('4','Product3'),array('7','Product4'))

Please advice guys..

Joomla Php syntax

alwinc — Tue, 04 Dec 2012 22:42:23 +0800

Anyone can help to see if any syntax error as quoted below? I just couldn't figure out what's wrong causing the data storing into database fails.

QUOTE

$db =& JFactory::getDBO();
$lastinsertid = $db->insertid();

$color_ids = $_POST['color_id'];

foreach($color_ids as $color) {

$sqlstat = "INSERT INTO file_color_map (colour_id, files_id) VALUES ( $color, $lastinsertid )";
echo $sqlstat;
$db->setQuery($sqlstat);

}

When i echo-ed the $sqlstat that shows :
INSERT INTO file_color_map (colour_id, files_id) VALUES ( 3, 32 )
INSERT INTO file_color_map (colour_id, files_id) VALUES ( 4, 32 )

It seems like no problem with the sql query part... anyone can help?

Jquery make radio button disabled

alwinc — Tue, 27 Nov 2012 15:18:56 +0800

Hi..

How to make all checked radio buttons disabled after submitting form.

This is my attempts:

QUOTE

p/s: i have 5 radio buttons having same id.

Anyone knw changing password regex?

alwinc — Mon, 19 Nov 2012 09:35:52 +0800

From : /^\S[\S ]{2,98}\S$/

requirements: at least 1 number and 1 UPPER case in more than 8 digits length

Jquery question

alwinc — Mon, 12 Nov 2012 12:31:03 +0800

closed--

How to make "submit" button disappear after click

alwinc — Mon, 08 Oct 2012 10:52:33 +0800

I have tried..

QUOTE

It works! the button disappear immediately upon clicking.. but after the php form action loading.. the button appears again

CSS specifically to IE

alwinc — Thu, 20 Sep 2012 16:51:06 +0800

I have these in my html page :

<style>body{
background: #3aa43c url(bg.png) no-repeat top center}
img{position: fixed; top: 50%; left: 50%; margin-top: -105px; margin-left: -185px;}

</style>

But when i open it with internet exporer, the image seems went wrong, the image is not listening to the css that i have put. How can i make make specifically css for IE?

Jquery image onclick event to create cookie

alwinc — Tue, 11 Sep 2012 22:31:40 +0800

As following is my 1st attempt, hope to get advices from sifu here on how to get it working ..

On Firsttimepopup.php

QUOTE

<?php
//store the country in a cookie (ajax)
/** if(isset($_POST['Goto']))
{
setcookie('country',$_POST['Goto'],time()+365*24*60*60);
} **/
?>

<html xmlns="http://www.w3.org/1999/xhtml"><head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" href="templates/theme708/scripts/countrypopup/firsttimepopup.css" type="text/css" />
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.js"></script>
</head>

<script type="text/javascript">
$(document).ready(function(){
$("#Malaysia a").click(function(e){
e.preventDefault();
$.post('../setCookie.php',{'Goto':'Malaysia'},
function() {
setTimeout ("window.parent.location = \"http://www.abc.com/v2\"", 2*1000 );
}
);
});

$("#Singapore a").click(function(e){
e.preventDefault();
$.post('../setCookie.php',{'Goto':'Singapore'},
function() {
setTimeout ("window.parent.location = \"http://www.abc.com.sg\"", 2*1000 );
}
);
});
});
</script>

<body>
<div id="ftpopup">
<div id="ftmain">

<?php

echo $Goto;
/**
if(isset($_POST['Goto']))
{
   echo "Redirecting...";
   if ($_POST['Goto'] == "Malaysia")
   {
echo '<script language="javascript">'."\n";
echo 'setTimeout ("window.parent.location = \"http://www.abc.com/v2\"", 2*1000 );' ."\n";
echo '</script>'."\n";
   }
   if ($_POST['Goto'] == "Singapore")
   {
echo '<script language="javascript">'."\n";
echo 'setTimeout ("window.parent.location = \"http://www.abc.com.sg\"", 2*1000 );'."\n";
echo '</script>'."\n";
   }
}

else {
**/
?>
<form name="testform">
<table id="Table_01" width="724" height="438" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="5">
   <img src="templates/theme708/scripts/countryselection/countryselection_01.gif" width="724" height="179" alt=""></td>
</tr>
<tr>
<td>
   <img src="templates/theme708/scripts/countryselection/countryselection_02.gif" width="422" height="70" alt=""></td>
<td>
   <a href="http://www.abc.com/v2"><img id="Malaysia" src="templates/theme708/scripts/countryselection/countryselection_03.gif" border="0" width="79" height="70" alt="Malaysia"></a></td>
<td>
   <img src="templates/theme708/scripts/countryselection/countryselection_04.gif" width="45" height="70" alt=""></td>
<td>
   <a href="http://www.rockwills.com.sg"><img id="Singapore" src="templates/theme708/scripts/countryselection/countryselection_05.gif" border="0" width="76" height="70" alt="Singapore"></a></td>
<td>
   <img src="templates/theme708/scripts/countryselection/countryselection_06.gif" width="102" height="70" alt=""></td>
</tr>
<tr>
<td colspan="5">
   <img src="templates/theme708/scripts/countryselection/countryselection_07.gif" width="724" height="189" alt=""></td>
</tr>
</table>
</form>

<?php
//}
?>

</div>
</div>

</body></html>

On setCookie.php

QUOTE

<?php
if(isset($_POST['Goto']))
{
setcookie('Country',$_POST['Goto'],time()+365*24*60*60);
}
?>

Lowyat.NET: Latest topics by alwinc

[WTS] BRAND NEW SURFACE PRO 4 ITEM SOLD!

Need help in php

S&P Agreement + Loan Agreement Fees

how to get current checked radio button value?

---solved

php looping error to display saved data on form

PHP looping to save into database

Php IF statement inside Switch condition

Remove duplicated elements from array and re-index

Encode ™ as &trade; in php mysql databases

Loop DB results to Remove duplicated elements

SQL statement select DISTINT need help

mysql_fetch_object retrieve database records

Joomla Php syntax

Jquery make radio button disabled

Anyone knw changing password regex?

Jquery question

How to make "submit" button disappear after click

CSS specifically to IE

Jquery image onclick event to create cookie

Encode ™ as ™ in php mysql databases