Lowyat.NET: Latest topics by transfield

D'Quince @ Damansara Perdana by Exsim

transfield — Sat, 17 Aug 2019 23:11:31 +0800

I came across this topic here which aroused my curiosity as I live nearby. Finding the actual location was a challenge. I had to go to the Exsim showroom in Empire City & they pointed me across the LDP to the concrete batching plant on the road leading towards Flora Damansara. Yes, that's the actual location of the site.

Well, I'm not particularly impressed with the access road neither am enthusiastic to stay close to Flora Damansara.

However, the price is a steal starting from RM270k onward for a 550sf unit. Another attractive feature is the price remains that same regardless of whether you buy a unit on the lower floor or higher floor.

Therefore, the early bird catches the worm! I got the sign-up link from the people at the Exsim showroom. within 24 hours of signing up, a representative of the developer called me to make an appointment to view the show unit. They are super efficient, polite & professional I must say. I'll be visiting the show unit tomorrow...

In summary, I would say that this "starter" property would be quite affordable for unmarried people below the age of 30. My motivation to buy? Well, my 21 year old son just started working..I might want to help him own one by paying the down-payment for him...

Here are some pictures sourced from Facebook. Hope it helps someone & perhaps we might end up being neighbours :-)

BTW, just before I make a final decision, would I be able to get something better in the same area for RM270k? Thanks for any advice.

MySql Query for Wordpress

transfield — Sun, 24 May 2015 23:49:49 +0800

Hi,
I am editing a Wordpress plugin. I basically want to query the Wordpress database & do something with the results. I've figured out the 1st part which is:

CODE

<?php
global $wpdb;
$my_table = $wpdb->prefix."users";
$my_query = "Select user_login from $my_table where user_login LIKE '%z%' ";
$my_results = $wpdb->get_results($my_query);
?>

I don't know how to get the second part done. I want to put the search results into the foreach loop.

CODE

<?php
foreach($my_results as $user_data)
{
/*Lets assume that I have 100 records from the search results. How do I put all the 100 records into the code below? This means that the search results needs to go into michael_jackson, joe_bugner, etc*/
if($user_data -> user_login === 'michael_jackson' || $user_data -> user_login === 'joe_bugner' )
// do something
}
?>

Wordpress Customisation Advice

transfield — Wed, 22 Apr 2015 21:16:37 +0800

Hi,
I have a Wordpress 4.0.2 site. I engaged a programmer to do some customization to it. He wrote all the php code into the functions.php of my theme. I didn't realize that this was a bad move as I was new to Wordpress customization & I relied upon him for his 'expert' advice.

While the codes are all working fine the side effect of his work is as follows:
1. The site is sluggish
2. It throws up some hidden javascript errors that prevents other Wordpress plugins from functioning
3. WordPress' admin-ajax.php has been blocked from loading
4. It is loading jquery multiple times from an external google api link
5. I can't update / change my theme anymore for fear that the functions.php file will no longer work on the new theme
6. The searchability is unstable
7. I dare not upgrade my version of Worpress for fear that something might get messed up

Additional Info
One of the core functions of this Wordpress site is to query an external Mysql database containing approximately 20 million records. Could this be a contributory factor to the sluggishness of the site?

Under such circumstances, what is the best way to maintain all the customization but improve the performance of this site?

Thanks for your advice.

Excel VBA Macro

transfield — Mon, 01 Sep 2014 00:01:52 +0800

Hi,
I'm using Excel 2013.

I would like to copy every 150 rows of data from column A of Sheet 1 & paste special in a transpose manner into Sheet 2. I would like this process to go on until there is no more data in Sheet 1 to copy. The end result should be all data is pasted in Sheet 2 in a transpose manner & there should no longer be any data in Sheet 1.

I've gone as far as creating this macro which works fine but doesn't seem to loop. Could you please help me to edit this code so that it loops until there is no more data in Sheet 1 to copy?

Thanks.

CODE

Sub test()
ActiveSheet.Name = "Sheet1"
Dim wsData As Worksheet
Dim wsNew As Worksheet
Dim rng As Range
Dim I As Long

Set wsData = Worksheets("Sheet1")
Set wsNew = Worksheets("Sheet2")

Set rng = wsData.Range("A1")
While rng.Value <> ""
I = I + 1
rng.Resize(150).Copy
wsNew.Range("A" & I).PasteSpecial xlPasteValues, Transpose:=True
Set rng = rng.Offset(150)
Wend
End Sub

MS Access Export Table to Text File

transfield — Sat, 16 Aug 2014 09:09:50 +0800

Hi,
I have a table of thousands of records in MS Access 2007. I want to export it to a text file consisting of 500 records per text file. I'm looking for a macro which can do this. The macro should ideally create the text files automatically.

I've gone as far as using the following code which works well to export the entire table into one text file. I don't know how to break up this big text file into smaller files of 500 records per file automatically during the import.

Thank you for your advice.

CODE

Sub ExportToText()
Dim rst As DAO.Recordset
Open "C:\Users\a\Desktop\test.txt" For Output As #1
Set rst = CurrentDb.OpenRecordset("SELECT [Name] FROM [Australian Non Duplicate Names]", dbOpenSnapshot)
Do While Not rst.EOF
Print #1, rst!Name
rst.MoveNext
Loop
rst.Close
Set rst = Nothing
Close #1
End Sub

PHP Delete Folder

transfield — Thu, 06 Jun 2013 15:52:18 +0800

Hi,
I've got an empty folder on my web server. Permissions are set to 0777. I can't delete it using the code below. I've created other folders too. None of these folders can be deleted using the same code. I can easily delete them manually by right-clicking on my mouse & selecting Delete. However, I don't want to delete them manually. I want to use a php code. Please help.

CODE

<?php
// Path to directory you want to delete
$directory = '/home/website/domains/website.com.my/public_html/download3';

// Delete it
if (rmdir($directory))
{
echo "{$directory} has been deleted";
}
else
{
echo "{$directory} could not be deleted";
?>
}

Import Emails into Mysql

transfield — Mon, 20 Aug 2012 13:03:54 +0800

Hello,

I'm hosting my website on a Linux server. My web host gives me unlimited email accounts. I access my emails using either Horde or Squirrel Mail which is provided to me by my web host as part of my hosting package.

I want to import all my incoming emails into a Mysql database. The Mysql database is also provided to me by my web host as part of my hosting package. How do I do that? I am looking for a PHP solution, if possible.

I have looked at the control panel provided to me by my web host. There is a feature to 'pipe my emails to a program', whatever that means. A screen shot is attached. Can I use this feature to do what I want to do? If so, how do I do it?

[attachmentid=3008018]

Want to Shut Down PC from Command Line

Thu, 01 Jan 1970 07:30:00 +0800

Forbidden. You don't have permission to access

transfield — Sun, 03 Jun 2012 09:40:22 +0800

Hi,

I have a php script & a cgi perl script to upload files into my server. Both scripts worked fine for many months. Recently, I'm getting an error when I run my file upload script. The message is:-

Forbidden
You don't have permission to access /myscript.php on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

My webhost claims that this is due to their upgrading from php 5.2 to php 5.3. I don't believe them because even my cgi perl script generates the same message.

Error Log Messages from my hosting's control panel:-

[Mon Jun 04 01:08:59 2012] [error] [client 60.51.19.102] File does not exist: /home/xxx/public_html/xxx/404.shtml
[Mon Jun 04 01:08:59 2012] [error] [client 60.51.19.102] File does not exist: /home/xxx/public_html/xxx/favicon.ico
[Mon Jun 04 01:08:59 2012] [error] [client 60.51.19.102] File does not exist: /home/xxx/public_html/xxx/403.shtml, referer: http://www.xxx/file_upload.html
[Mon Jun 04 01:08:58 2012] [error] [client 60.51.19.102] File does not exist: /home/xxx/public_html/xxx/404.shtml
[Mon Jun 04 01:08:58 2012] [error] [client 60.51.19.102] File does not exist: /home/xxx/public_html/xxx/favicon.ico
[Mon Jun 04 01:08:56 2012] [error] [client 60.51.19.102] File does not exist: /home/xxx/public_html/xxx/404.shtml
[Mon Jun 04 01:08:56 2012] [error] [client 60.51.19.102] File does not exist: /home/xxx/public_html/xxx/favicon.ico

Any help will be greatly appreciated.

Update One Table from Data in Another Table

transfield — Sat, 10 Mar 2012 23:49:11 +0800

Hello,

I have 2 tables. The structures are below:-

CODE

CREATE TABLE IF NOT EXISTS `dcp_reports_raw` (
`id` int(6) NOT NULL auto_increment,
`club_num` int(10) NOT NULL,
`club_name` varchar(60) NOT NULL,
`mship_base` int(3) NOT NULL,
`mship_todate` int(3) NOT NULL,
`dcp_todate` int(2) NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0;

CREATE TABLE IF NOT EXISTS `dcp_reports` (
`id` int(6) NOT NULL auto_increment,
`club_num` int(10) NOT NULL,
`club_name` varchar(60) NOT NULL,
`mship_base` int(3) NOT NULL,
`mship_todate` int(3) NOT NULL,
`dcp_todate` int(2) NOT NULL,
`mship_lastweek` int(3) NOT NULL,
`dcp_lastweek` int(2) NOT NULL,
`to_email` varchar(100) NOT NULL,
`from_email` varchar(50) NOT NULL,
`message` varchar(1000) NOT NULL,
`database_lastupdated` date NOT NULL,
`email_lastsent` date NOT NULL,
`expiry` date NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0;

I want to :-

1. update dcp_reports.mship_todate with the data from dcp_reports_raw.mship_todate provided that the values of dcp_reports.club_num and dcp_reports_raw.club_num are the same.

2. update dcp_reports.dcp_todate with the data from dcp_reports_raw.dcp_todate provided that the values of dcp_reports.club_num and dcp_reports_raw.club_num are the same.

If both item 1 and 2 can be combined in 1 query, so much the better. Otherwise, I'm okay with 2 separate queries.

Kindly provide me with the Mysql or PHp code please.

Thanks.

download excel file from the web

transfield — Sun, 12 Feb 2012 23:30:39 +0800

Hello,
There is an excel file on the web. The url to the excel file is something like this:- http://reports.something.org/reports_new/s...ime=1&d=51&xl=1

I want to use a php code to download this excel file. I want to download this excel file to a folder in my server. The path to the folder in my server is something like this:-
/home/xxx/public_html/xxx.ORG/the folder

Could you provide me the code to save the excel file in my server?

Thanks.

Javascript Form Validation

transfield — Fri, 20 Jan 2012 19:40:16 +0800

Hi,
I've got a Javascript that works perfectly well for Internet Explorer. However, it does not work for Firefox & Google Chrome. How do I make it work for Firefox & Google Chrome too?

The Javascript.

CODE

The html form that it's supposed to validate.

CODE

In the case of Internet Explorer, all 4 text boxes(email1,email2,url1 & url2) are succesfully validated. However, in the case of Firefox & Google Chrome, only email1 is validated.

I want all 4 text boxes to be validated. How do I achieve this?

Thanks.

PHP Email Message Headers

transfield — Wed, 18 Jan 2012 21:05:37 +0800

Hello,
I used Yahoo Mail to send an email to my secret WordPress posting email, and a post was created and published automatically. Hooray :-)

However, when I sent an email to the same address using PHP, nothing happened - no posts created, none published....Using PHP, I can succesfully send the same email to my secret Blogspot posting email. Therefore, I don't think there is anything wrong with my PHP code.

I suspect that there is something 'unfriendly / missing' in my message headers. My message headers are below. Are there any additional headers that I need to add to make my email Wordpress friendly?

CODE

<?php
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=utf-8' . "\r\n";
$headers .= 'From: noreply@mywebsite.org' . "\r\n";
$headers .= 'Return-Path: me@mywebhost.com' . "\r\n";
$headers .= 'Reply-to: noreply@mywebsite.org' . "\r\n";
$headers .= 'Errors-To: noreply@mywebsite.org' . "\r\n";
$headers .= 'X-AntiAbuse: Primary Hostname - mywebhost.com' . "\r\n";
$headers .= 'X-AntiAbuse: Sender Address Domain - mywebhost.com' . "\r\n";
?>

My emails consists of text, pictures, videos & other stuff.

Thanks for your advice.

Find Cells Which Do Not Contain a Particular Str

transfield — Sun, 01 Jan 2012 01:45:19 +0800

Hi,
I would like to modify the macro below in order to find cells that do not contain */*/20*

How do I achieve this? Kindly show me the code please.

Thanks.

CODE

Sub delete_oldads()
Dim cel As Range, cfind As Range
ActiveSheet.UsedRange.Select
For Each cel In ActiveSheet.UsedRange
If cel = "" Then GoTo nextcel
Set cfind = cel.Find(what:="*/*/20*", lookat:=xlPart)
If Not cfind Is Nothing Then
cfind.Copy Cells(cfind.Row, "A")
cfind.Clear
End If
nextcel:
Next cel
End Sub

Excel 2003 VB Macro Question

transfield — Fri, 30 Dec 2011 21:51:01 +0800

Hi,
I have a worksheet with data in it. The data could be in any column or row. I am looking for data which contains the numbers 01. If I find such data, I want to move all the data in that particular cell it to column A.

My code(which is not working) is below. Could you help me to make it work please?

CODE

Sub delete_oldads()
'the code to find 01
Dim cel As Range
ActiveSheet.UsedRange.Select
For Each cel In Selection
If cel = "" Then GoTo nextcel
If Cells.Find("*01*") = True Then

move_ad_to_left

End If
nextcel:
Next cel
End Sub

CODE

Sub move_ad_to_left()
'the code to move the data from anywhere to column A
Dim LR As Long, c As Range
LR = Cells.Find("*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row
For Each c In Range("B1:Z" & LR)
If c.Value <> "" Then c.Cut Destination:=Range("A" & Rows.Count).End(xlUp).Offset(1)
Next c
End Sub

Batch Rename of Files

transfield — Tue, 27 Dec 2011 02:17:31 +0800

Hi,
I've got hundreds of html files in a folder. I want to rename them using an Excel VB macro. The new names could be something simple like 1.htm, 2.htm, 3.htm, etc.

The html files are located at C:\Documents and Settings\b\Desktop\files

I am using Excel 2003.

Could you provide me with the macro please?

Thanks.

PHP Mysql Question

transfield — Sun, 18 Dec 2011 19:07:22 +0800

Hello,
This is my code:-

CODE

<?php
$query2=mysql_query("SELECT * FROM blogger") or die(mysql_error());
while($row2 = mysql_fetch_array($query2)){
$current_posting_date = $row2["next_posting_date"];
$posting_frequency = $row2["posting_frequency"];
$future_posting_date = date('Y-m-d', strtotime($current_posting_date.'+'.$posting_frequency.' day'));
}
$query4=mysql_query("UPDATE blogger SET next_posting_date = '$future_posting_date'") or die(mysql_error());
?>

In $query4, I'd like to update next_posting_date with the results of $future_posting_date bearing in mind that $future_posting_date for each record would be different. How do I achieve this?

Explained slightly differently, the results of $future_posting_date could be as follows:-
2011-12-18(for record 1)
2011-12-19(for record 2)
2011-12-20(for record 3)

How do I update record 1 of next_posting_date with 2011-12-18, record 2 of next_posting_date with 2011-12-19 and record 3 of next_posting_date with 2011-12-20?

Thanks for your help.

strtotime php question

transfield — Fri, 16 Dec 2011 16:24:24 +0800

Hello,

CODE

<?php
//this code does not work
$test_date = "2011-12-25";
$ts = strtotime('$test_date +90 days');
echo date('Y-m-d', $ts), '<br />';
?>

CODE

<?php
//this code works :-)
$ts = strtotime('2011-12-25 +90 days');
echo date('Y-m-d', $ts), '<br />';
?>

I want to put the date(2011-12-25) into a variable($test_date) like the 1st example. How do I do it?

Thanks.

<option selected> Question </option>

transfield — Tue, 04 Oct 2011 15:21:04 +0800

Hi,
This is my simple html code:-

CODE

<select size="1" id="program_name" name="program_name">
<option value="PP">Parliamentary Procedure in Action</option>
<option selected="selected" value="SC">Speechcraft</option>
<option value="EE">The Art of Effective Evaluation</option>
</select>

I want the user to determine the default <option selected> instead of me having to hardcode it into the webpage. This means that today the default <option selected> could be Speechcraft & tomorrow it could be The Art of Effective Evaluation.

Is there a php / javascript solution to this?

Thanks for your help.

Insert Emails Into MySQL

transfield — Mon, 03 Oct 2011 02:07:48 +0800

Hi,
I want to extract emails from a textarea & insert it into a mysql database comma delimited. My code below is working fine. It's just that I don't know how to comma delimit the email addresses before inserting them into the database.

CODE

<?php
$text = $_REQUEST['textarea1'];

// parse emails
if (!empty($text)) {
$res = preg_match_all(
"/[a-z0-9]+([_\\.-][a-z0-9]+)*@([a-z0-9]+([\.-][a-z0-9]+)*)+\\.[a-z]{2,}/i",
$text, $matches );

if ($res) {
foreach(array_unique($matches[0]) as $email3) {
$result8=mysql_query("INSERT INTO `public_event_admin` (`email`) VALUES ('$email3')") or die(mysql_error());
}
}
else {
echo "No emails found.";
}
}
?>