Here are 2 options
indigostar.com perl2exe
Perl's own PAR::Packer
RonB
Joined: Jun 3 '09
Location:
-
I don't know how much experience you have in forums like this, but the best way to ask for help and receive a solution is to post a short but complete (self contained) test script that demonstrates the problem so that we can duplicate and troubleshoot the issue.
You should also post the errors and warnings that your posted code produces so that we can verify that it matches up with our results. And, if those messages differ from what...Last edited by RonB; Sep 22 '17, 02:54 AM.Leave a comment:
-
Since I don't have a copy of your database, I can't actually run any tests. Looking at raw code will only get you so far and rarely is enough to do proper troubleshooting . Can you provide us with a dump of a test db that has a few test records?
The error message you're receiving suggests that $row['passwords'] is NULL. However, the line number it gives is not even close to where you call the password_verify () function, which leads...Leave a comment:
-
What part is failing? Is the string replacement failing or is that part ok but fails later when you try to use that modified string?
Can you post the content of $curl_result so I can run some tests to get the replacement portion working?
I should point out that manually parsing html is a bad idea. You should be using an html parser designed for this purpose. Manual parsing is very fragile and is only semi ok when the...Leave a comment:
-
Why do you have (string) in that conditional?Code:if (password_verify($password, (string)$row['passwords']))
Remove it and see if that helps.Leave a comment:
-
It's been awhile since I was last forced to use php and forgot that it had a password_verify (). I was thinking is was from your imported config.php script.
I'll take another look at your script later when I have more free time.Leave a comment:
-
Why are you using str_replace instead of a regex?
You should clean up the code formatting to make it more readable and maintainable so that it will be easier to troubleshoot. Line lengths of 500+ characters is a very poor coding practice.
For example, your $pattern and $replace var assignments would be much more readable and maintainable if you put each array element in its own line, like this:
...Code:$pattern =
Last edited by RonB; Sep 19 '17, 02:55 PM.Leave a comment:
-
I do work with php a little, only if I have to, but I'm not an expert in it.
The password_verify function is not in the code you posted so I can't explain why it's failing.
If you haven't already done so, you should add some debug print statements to verify that the vars hold the values you expect.
When troubleshooting things like this, it's best to write a short but complete test script that that duplicates...Last edited by RonB; Sep 19 '17, 02:36 PM.Leave a comment:
-
Do not put multiple statements on 1 line.
Put each statement on separate lines and add proper indentation.Leave a comment:
-
Start by fixing your formatting so that the code is readable. In doing so, you might find the problem.Last edited by RonB; Sep 18 '17, 03:25 PM.Leave a comment:
-
RonB replied to perl script will generate html file, converting this to excel is not happening helpmein PerlDrop your logging routines and instead use the Log::Log4perl module.
Your getCurrentDateT imeStr() sub is not doing what you think. You should use the strftime() function from the POSIX module, which you are already loading.
Don't use TitleCase for multi word vars and subs. Use an _ underscore to separate the words and use lowercase.
Your indentation is inconsistent which makes it difficult to follow...Leave a comment:
-
RonB replied to perl script will generate html file, converting this to excel is not happening helpmein PerlGet rid of the prototypes. Perl's prototypes don't work the same way as some other languages and are almost always not what you should be doing.
Far More than Everything You've Ever Wanted to Know about Prototypes in Perl -- by Tom ChristiansenLeave a comment:
-
RonB replied to perl script will generate html file, converting this to excel is not happening helpmein PerlYou can't post 500+ lines of code and expect someone to troubleshoot it and fix it for you.
What part of the script is failing and in what way is it failing? What errors and/or warnings is it giving you?
Try to write a SHORT but complete script which demonstrates the problem.Leave a comment:
-
That's where a combination of backups and the binlog come in. You first restore from the backup then use the binlog files to "replay" each action from there upto but not including the point where the deletion occurred.
Point-in-Time (Incremental) Recovery Using the Binary LogLeave a comment:
-
mysqldump is used to create the backup (which you said you don't have) and should be run daily as a cron job.
Doing a rollback only works if you are inside a transaction and didn't execute a commit.Leave a comment:
-
There is no "undelete" function.
You need to restore the data from your backup.
Do you have a backup of the data?Leave a comment:
-
RonB replied to Add the numbers of Array ‘A’ and Array ‘B’ in each position and check whether the sumin PerlYou need to do your own homework assignment.
If you need help troubleshooting your script AND have a specific question regarding your code, then post your code and question and we'll help but not do your assignment for you.Leave a comment:
-
Your question as posed is not really related to sql. it's a question related to the scripting language you're using to run your query.
Within that language you need to build the FROM clause of the select statement based on your low and high column names/numbers. The syntax required to do that will depend on your scripting language.
If that approach isn't going to work for you, then you'll need to provide more details about...Leave a comment:
-
That's a really bad design.
The solution to your problem would be to fix the layout of your database.
Do a google search on "database design" and/or "database normalization".Leave a comment:
-
Did you read the documentation for the date_add function? It has an example doing exactly what you want.
https://dev.mysql.com/doc/refman/5.5...ction_date-add
Here's another example.
http://www.w3schools.com/sql/func_date_add.asp...Leave a comment:
No activity results to display
Leave a comment: