SQLite "database table is locked" error
1. Is there a better place to ask this question?
2. If not:
I read that reading and writing in a sqlite table cannot be done 'at the same time' and that is why I get this error.
My code goes something like this:
$query="SELECT * FROM (bestanden) WHERE...
Hi there,
sorry if this question has been asked before, but I cannot find an answer.
I am writing a newsfeed for RSS and the <link></link> tag needs to contain a url like:
http://www.kralingen.nl/index.php?rub=12&pag=114
Some readers do not accept the &, how do I code this, please?
Hi Folks,
To find whole words I have got this working:
$pattern[]="/\\b(" . trim($a) . ")\\b/i";
Instead of \\b I also tried \\w and \\W
This nicely captures whole words as expected, but:
I would like to avoid for example word in <word and word=
because they could be tags or attributes.
I...
Hi There
I am looking to replace ... #contentX:x# ... with
... Somethingorother firstarg=$1 secondarg=$2 ...
where X and x are single characters, where, in the example, S1='X' and $2='x'
preg_replace is the best solution, but I cannot fin the right searchargument.
I know my explanation is...
Is this at all possible in any way or form?
$query="SELECT title,id,date FROM `content` WHERE `user`='$user' ORDER BY SUBSTRING(title,(INSTR(title,';;')+2)) ASC ";
Is this at all possible?
In any way or form?
$query="SELECT title,id,date FROM `content` WHERE `user`='$user' ORDER BY SUBSTRING(title,(INSTR(title,';;')+2)) ASC ";
Interesting problem?
$_SERVER['QUERY_STRING'] returns all variables, but never the # position in the file, as in:
http://index.php?page=1&sub=6#SUBJECT
I cannot find a global variable that does return it either.
Any suggestions?
Hi there,
I have $pattern='/\*pag:([^\]]*):([^\]]*):([^\]]*)\*/';
that works well for three arguments like:
*pag:first:second:third*
But I would like one that works also for fewer arguments, and simple returns an empty string for the patterns missing.
so other patters could be...
Hi all,
Suppose I have two coordinates like
Lat 28,00123 E Long 33,00001 S
and
Lat 28,00123 E 34,76501 S
How could I calculate the bearing in degrees of that track?
The math is simply to hard for me!:(
Hello,
I have put a number of options into one binary number.
Now I am looking for a query that selects rows that have one option, Not have another option while a third option is irrelevant.
For instance:
If a bicycle has handbrakes, I OR the options with 4
If it has a rear light I or it with...
Hi, I am new to this, so probably a 'stupid' question:
My website is on a shared server.
I want to create a directory where I can put .jpg files from:
1. my ftp connection
2. a piped email
3. a webpage (php)
When I have the webpage create the dir I can give it a chmod 0755 and still upload...
Hello,
function CyOpen(a,y1) {
S = "window.html?../fotos/a" + a;
X=window.open(S ,"sill","width=500,height=" + y1 + ",top=10,left=10,resizeable=yes,scrollbars=yes")
X.focus()
My problem with this code is, that it seems to always open the window with the height that I defined the first time...
Hello,
I'm trying to write automated page-makeup and therefore I need to be able to count the number of words in a text that countains html tags.
I want to split up the text into columns, but, suppose the break occurs in the middle of '<b>this ^ bold tekst</b>', then I would run the risk of...
Hi,
I send mail from my (shared) server in response to forms.
(I never send unsollicited mail or spam)
When a visitor enters a hotmail address, the mail ends at best up in the Bulk Mail Map.
Often they never receive anything.
I think the problem may be the return path, but all attempts to...
$a="text<amg ||something||something_else||a_number|| >more text";
Hi, I am looking voor a piece of preg_replace code that will give me:
$b="text<img src=something alt=something_else id=a_number>more text";
Thanks in advance!
Hi,
A class returns an object (MailResult).
I can print_r the result which looks like this:
stdClass Object
(
[headers] => Array
(
[from stip@il.com wed dec 14 15] => 35:41 2005
[received] => Array
(
[0] => from...
Hi there,
Suppose I have a text like this:
$a="Hi there, suppose [I have:a text] like this, [can:you] help me?";
Now I would like to have an array consisting of:
$b[0] : "Hi there, suppose ";
$b[1] : "~I have";
$b[2] : "~~a text";
$b[3] : " like this, ";
$b[4] : "~can";
$b[5] ...
Hello.
In order to allow my visitors to uload .jpg pictures to my site I have created a directory with access rights set to 0777.
This is the only setting that I got working.
Now this directory is a target for hackers.
They managed to create a directory under that directory and put stuff there...
Hello.
I cannot seem to get rid of the white line between frames.
I never had this problem.
Could you please have a look?
(Please check first the replies below to see if the problems is solved)
My site is at:
http://robbertjandonker.kralingen.nl/
Hi there,
I tried GET, POST import_request_variables and everything works fine.
But then, all of a sudden, sometimes after weeks, things get messed up, only from my clients computer.
I suspect a virus or other malware.
This is what I get back from the form
request uri ...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.