Linux, Apache, MySQL, PHP

27-Jan-09 3:10

I'm new to both Perl and SQL and have been given a project to attempt writing a Perl script that will execute an SQL query. Then extract the information generated by the query and import it to a Microsoft Office Excel spreadsheet. Can someone point me in the right direction? Dazed and Confused. All help will be greatly appreciated.

sk8te320 Confused | :confused:

divyamistry27-Jan-09 21:41

divyamistry

27-Jan-09 21:41

You should start in Perl doc and Perl reference online. This is a common task and usually achieved through DBI module. Here's a guide from CodeProject KnowledgeBase[^] That takes care of accessing data from database using an SQL query. Once you have data in a perl variable, you can do all sorts of manipulation (I'm thinking along the lines of regexp and what not).

Now onto your Excel problem. Perl has a couple of modules (OLE, Spreadheet::Excel, etc.) to deal with MS products. I have never used them, but I have heard good things about Spreadsheet::Excel. I just did a quick search and found a nice tutorial/article on IBM developerWorks series. Here's a link[^].

I hope this points you to the right direction. And in case you are not familiar with installation of Perl modules, I'd suggest searching for Perl CPAN. Its homepage will point you to installation instructions and whatever else you might need to get the modules up and running.

sk8te3205-Feb-09 1:57

5-Feb-09 1:57

Dear divyamistry,
I appreciate the help. It's not to often you receive advise that so in depth. Sorry
I didn't get back to you earlier, but we've been having some system problems at work and things have been kind of crazy. I look into your suggestions, they seem like what I've been looking for, who knows, maybe one day I'll be able to return the favor.

Thx again, sk8te320!

divyamistry29-Jan-09 21:06

divyamistry

29-Jan-09 21:06

Continued from PHP forum Smile | :)

Ok, so you said

sk8te320 wrote:
Can someone point me in the right direction? Dazed and Confused. All help will be greatly appreciated.

So, I thought I'd suggest which modules etc. to look up. If you have already done that, and have all the modules installed, would you please let me know where you are stuck? Are you able to verify that you have all the modules installed? Let me know if I could be of any help. I'm no Perl pro, but I've done similar stuff earlier, so I may be able to help you out on this one.

sk8te3205-Feb-09 2:00

5-Feb-09 2:00

Hey divyamistry,
Haven't sunk my teeth into it yet, hope to get to it in the next couple of days but will keep you in the looop.

sk8te320!

Parinay Bansal8-Feb-09 4:31

Parinay Bansal

8-Feb-09 4:31

well i was a noob too sometime ago

take this link and it surely will help
http://rapidshare.com/files/4333859/_Book__Perl__Wrox__PDF__Professional_Perl_Programming.pdf

i consider it my bible..

best of luck

i am doing a similar project
working with perl and mySQL

Fred Mcmurray17-Feb-09 5:38

Fred Mcmurray

17-Feb-09 5:38

Which RDBMS are you trying to connect to?
For the last two years I have been querying SQL Server and writing the results to an Excel spreadsheet with great success.

sk8te32031-Mar-09 0:11

Looking for Opensource SNTP client for Linux

31-Mar-09 0:11

Hi Fred,
The past few months have been kind of crazy, personal life and all. Project was put on the back burner for a few (Thank God!), but now I must press on. In regard to your question I am using SQL 2005. I was told that after the extract I would possibly need to convert the query information into a .csv file before attempting to convert it Excel. Let me knwo what you think!

Thx sk8te320

neolaser18-Jan-09 2:27

neolaser

18-Jan-09 2:27

I am looking for an opensource SNTP client for Linux, preferably with a NON GPL license. I got some programs but most of the programs came with GPL license.
Any links, pointers will be of great help.

Thanks in Advance, Smile | :)

neolaser

passing javascript variable to php file without page refresh

Member 451421815-Jan-09 8:17

Member 4514218

15-Jan-09 8:17

var clickcounts='0';
function count()
{
clickcounts++;
alert(clickcounts);

}
I like to pass the clickcount value to a php file without page refresh.
If AJAX is the only way give me an example
Thanks In Advance,
Praveen

Re: passing javascript variable to php file without page refresh

Mohammad Dayyan19-Jan-09 19:52

Mohammad Dayyan

19-Jan-09 19:52

Member 4514218 wrote:
I like to pass the clickcount value to a php file without page refresh.
If AJAX is the only way give me an example

Yes, Ajax is the only way.
For the samples, there are many samples in the web, just needs a simple searching.
For example :
http://forums.tizag.com/showthread.php?p=32989#post32989[^]

Re: passing javascript variable to php file without page refresh

Ranjit Viswakumar29-Jan-09 12:06

Ranjit Viswakumar

29-Jan-09 12:06

AJAX is the way to go if you want to make calls to the server without refreshing the page. It makes XML calls to the server. Here's is a script you can use-

http://whatsaranjit.com/includes/grabData.js

The variables explained-
this.value: variable passed as get variable q
ID of div: the id of the div that should be alter to contain the new data
page for processing: PHP, .NET, CF, etc page that will process q and return output

Take a look and try it out. Thanks.

Doing encryption that embedded into mail server

xiaomahe2-Jan-09 7:49

xiaomahe

2-Jan-09 7:49

Hello, i am planning to do email with encryption system embedded inside the mail system itself..

Currently, i am not sure on how to do such embedded program (creating a encryption program that plugs to the email itself when u run the email system)..

can somebody gimme ideas on how to do that? i have decided to use postfix and dovecot to setup and the mail system, probably with squirrel mail as well..

ANd which programming language more suitable for encyrption programs?? i know most of the language can be used, but which is the best..

Re: Doing encryption that embedded into mail server

JasonPSage27-Feb-09 12:51

JasonPSage

27-Feb-09 12:51

You need to write the "Encryption" like you said - in a client - and make sure the Email is readable - (in part) on all email clients - like:

"This email is encrypted with SuperSafe" or something, a link to
your web site, and below have something like what I have below.

---------------------------------------------------------------
:SUPERSAFE START:
jkahlkjrh34khjqknwekjfhskadfbskdjafk;sfsdaf
fdasfksdajfkl;jskalfjklsa;jflsajfdsklfjsdak
fsdalkjsadfjsjalkf;jskdafjsakdlfjskdal;asfa
:SUPERSAFE STOP:
---------------------------------------------------------------

Now - your language of choice might be dictated by the email client you wish to code agaist. I personally would use ANY LANGUAGE that compiles to Binary... .Net? Nope. php? Nope. Ruby? Nope. Java? Nope.

C/C++/Pascal/FreePascal/Assembler <--- I Recommend one of these.

--Jason

Know way to many languages... master of none!

Accessing ping through c/c++

tassadaque31-Dec-08 2:18

tassadaque

31-Dec-08 2:18

I want to extract information such as rtt, time from each ping, if i ping some host. i think i should first capture the process id of ping and then use its information to get the required data. Any help in this regard is greatly appreciated

Re: Accessing ping through c/c++

Cosmic Egg10-Jan-09 4:03

Cosmic Egg

10-Jan-09 4:03

How about including Ping in your appication...

http://www.codeproject.com/KB/IP/Ping_and_Traceroute.aspx[^]

Can easily retrieve the values from here.

C programming in Linux warning message

Kogee San9-Dec-08 17:24

Kogee San

9-Dec-08 17:24

Hello everyone. Im not quite sure either Im in the right forum since my question is basically on C programming, coding in the linux environment. After I gcc, I got this warning message

"warning: passing argument 1 of 'strcpy' makes pointer from integer without a cast"

When I run the program, I will have a segmentation error fault. This is the code snippet below.

static const char *opt_socket_name[5];

main()
{
  int i = 0;

  strcpy(*opt_socket_name[i], "testing")
  printf("%s", opt_socket_name);
}

Im not quite sure why this happen. Can anyone here help me and explain what is going on behind the scene. Can you guys also give an opinion on how to make it work. A brief on what I am doing is actually, creating multiple socket with different names. I am just about to create different names, but the warning above appeared. Is there any other options to do this? The above code is just a small testing code to make the strcpy() works. Im quite new in programming so currently im learning. Big Grin | :-D

Thanks

L. Madhavan17-Dec-08 17:58

L. Madhavan

17-Dec-08 17:58

It looks like you're trying to copy text into a string, but there are quite a few mistakes in the code:

1. A string is an array of characters, for eg. char str[100]. Therefore opt_socket_name[5] is a string that can hold 4 characters (+1 for the null terminator)

3. A * represents a pointer - you can also use a character pointer as a string, but it would point to an existing array of characters.

4. You use either * or an array. In your case, *opt_socket_name[5] means an array of 5 strings.

5. const = constant. Don't use that unless you don't want to modify the string.

So here's what your code should look like:

static char opt_socket_name[20];

main()
{
  strcpy(opt_socket_name, "testing");
  printf("%s", opt_socket_name);
}

If you're looking for an explanation for your warning and the segmentation fault, here it is: as I mentioned, in your original program, opt_socket_name[i] is a string and *opt_socket_name[i] points to a single character in the string. What you are passing to strcpy is a single character, which in C can be implicitly typecast to an integer, which in turn is typecast to a pointer and hence the warning.

Kogee San18-Dec-08 0:45

Kogee San

18-Dec-08 0:45

yeah, That is basically what is I intended to do. I understand with the code you gave me since it is a basic strcpy() syntax. Anyway, thanks for the explanation behind the scene because that is the important thing i want to know. however, im not quite sure about what you mentioned of *opt_socket_name[5] means an array of 5 strings.. So does it means that *opt_socket_name[5] points to 5 strings? What I mean is like this :-

*opt_socket_name[0] is pointing to a string for example char string1[10];
*opt_socket_name[1] is pointing to a string example char string2[10];
*opt_socket_name[2] is pointing to a string for example char string3[10];
*opt_socket_name[i] is pointing to a string for example char stringi[10];

How can i make a program to test this if my understanding here is true. The test is just to secure my knowledge and understanding. Thank a lot.

L. Madhavan18-Dec-08 1:15

L. Madhavan

18-Dec-08 1:15

You're partially right about the *opt_socket_name[5] thing. You declare the array of pointers using a *, eg. char *opt_socket_name[5].

Now, for a normal pointer, you would assign it the address of an existing variable. Example:

int value = 10;
int *pointer = &value;
printf("%d\n", *pointer);

But the problem is that there is no string data type in C. A string itself is an array of characters and an array is internally a pointer, which means that a string is already a pointer. So the & and * are not used at all. This is how you would use an array of strings:

main() {
  int i;
  char *opt_socket_name[5];

  char string1[10];
  // ...
  char string5[10];

  strcpy(string1, "hello 1");
  // ...
  strcpy(string5, "hello 5");

  opt_socket_name[0] = string1;
  // ...
  opt_socket_name[4] = string5;

  for (i = 0; i < 5; i++)
    printf("%s\n", opt_socket_name[i]);
}