Hi,
I've made a nice working skript for managing MySQL database of
about 300 records (this is my first PHP script). But I don't know
how to split search results on pages? Does anyone have an
example of such script for me to work on it and understand how it
works?
My script is done as if: el
I tried PHPEd and PHP Coder but still came back to my favorite
AceHTML4 Pro from visicom.com They have quite good
customizable PHP wizard so you should try this one it's not
expencive but MUCH more featured then HomeSite.
BRACK
--
PHP General Mailing List (http://www.php.net
AceHTML4 Pro http://www.visicommedia.com/
On 1 Aug 2001, at 12:08, Kyle Smith wrote:
> --=_NextPart_000_0018_01C11A82.B809B880
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Does it really exist? If so could someone post some URL
Hi,
I'm in a process of doing site with MySQL database, and most of
the code I plased in index.php3 (in one file) but I've got some
problems with statements:
I have:
if (isset(...)) {
...
}
elseif (isset(...)) {
...
}
elseif (isset(...)) {
...
}
else {
...
}
IT DOESNT WORK!
but when I do:
i
Thank you everyone who replied on my treat "Syntax" There was
just a typo and problem is solved
Youri
<>< <>< <>< <>< God is our provider ><> ><> ><> ><>
http://www.body-builders.org
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional com
I just wanned to bring the issue of security of MySQL connection:
Let us imagine that SQL server was down for some hours (of
course without us knowing it) and at the same hours our SQL site
was visited by some kind of hacker, he can see on his screen all
our SQL connection info like username,
Hi,
>
>
> I think BRACK a.k.a. Jouri means that the connection
> string (from the PHP pages) would be visible in the
> client's browser once the SQL server stops running.
> However, I am not so sure about this as all commands
> are processed on the server - it will, howev
xist.
>
> Tyler Longren
> Captain Jack Communications
> [EMAIL PROTECTED]
> www.captainjack.com
>
>
> On Tue, 7 Aug 2001 21:35:58 +0200
> "BRACK" <[EMAIL PROTECTED]> wrote:
>
> > I just wanned to bring the issue of security of MySQL connection:
to how the "hacker" would see all this information (the
> username.. password, etc..) just by going to a site where the SQL backend
> was down?
>
> Ryan
>
> > -Original Message-
> > From: BRACK [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, August
Is there any function that can fetch a time of last modification of the
remote document.
For example I have a links based on the MySQL database, and I
want to know what linked site was most resently renewed.
Thank you
Youri
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe,
oing to get:
> >
> > Warning: Unknown MySQL Server Host...
> > Warning: MySQL Connection Failed...
> >
> > No usernames/passwords. I have to say however that I
> > always include my connect.php file. Maybe that's a
> > secure way to connect without
I'm tired...
I finished English version of my site and wanted to start Russian
part but realized that MySQL server returnes all data in koi-8r
charset which is not very comfortable for some of the users,
specially I know that A LOT of russians using Opera brawser older
versions of which do no
27;t be made.
> > No code is shown, just a line number. If, in your
> > case, PHP dumps the
> > source code to the browser window when the db
> > connection won't work,
> > then something has to be wrong. :)
> >
> > --Matt
> >
> >
> &g
Hi Maxim,
You are probably only one in this mailing list with experiance of
work with russian language in PHP, I have another qwestion
concerning Opera and textarea - I can't make Opera to accept
cyrillic text in textareas, I mean I can type in Russian but can't
insert russian text (tried var
Hi
I'm doing the script for searching the mySQL db in Russian
language. but output of textform
http://localhost/indexr.php3?search_idea=%E6%E2%E0%F7%EA
%E0 is not the same as
http://localhost/indexr.php3?search_idea=%C6%C2%C0%D7%CA
%C0 (this is the same word but first is lower case and second
tin2', `sjis', `swe7', `tis620', `ujis', `usa7', or
> `win1251ukr'. *Note Character sets::.
>
> --
> Canaan Surfing Ltd.
> Internet Service Providers
> Ben-Nes Michael - Manager
> Tel: 972-4-6991122
> http://si
Hi
thanx to everyone I solved the problem by updating my php and
inserting upper() in queries. Now I can insert whatever case in
search field and get case insensitive result.
Youri
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional com
Hi,
I'm on virtual hosting that lets me configure anything with .htaccess
file. I was recomended by provider to specify location of sendmail in
case I want to use php mail() function I know that I may do it in
.htaccess file by adding php_value sendmail_path
/usr/sbin/sendmail The qwestion is
Hi
I'm getting strange errors if I add
"LoadModule php4_module ../php/sapi/php4apache.dll" to http.conf
If I don't load it everything is working with php.exe without any errors but as I
load it as a modul I get for example -
Warning: Undefined variable: page in d:\abria
sql\apache\htdocs\inc\
Thank you for advise, I think I'll use .htaccess and that would be
fine. But why do I need to include ""? I'm using in on my local
Apache win32 without "" even though I understand what is "string"
Youri
On 19 Aug 2001, at 16:01, Richard Lynch wrote:
> > I'm on virtual hosting that lets me con
d it.
>
> Two ways around this - either set the variable $page to something first, or
> fix the php.ini file to stop being so fussy... try setting error_reporting
> to 7.
>
> (Newbie advice only, so take with a pinch of salt)
>
> - Original Message -
> From:
if you have structure like
then you need to insert "}" before "
or if you use syntax
you have to insert "endif;"
If you think you did it but still have an error, try to count your "if"
statements and "endif;" maybe something is missing.
Youri
--
PHP General Mailing List (http://www.php
I have a script with combination:
$ins_u = @mysql_query("INSERT INTO users (name,email)
VALUES ('$u_name','$u_email')");
$userid = @mysql_insert_id($ins_u);
It's working fine on local server but now I put it on the web and it
sais:
Warning: Supplied argument is not a valid MySQL-Link res
ith
> http://php.net/mysql_error like sending it to http://php.net/error_log or
> something.
>
> --
> WARNING [EMAIL PROTECTED] address is an endangered species -- Use
> [EMAIL PROTECTED]
> Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
> Volunteer a little
Hi
Can someone explain to me what "$i % 2 ? 0:" means or what it
does step by step? I was looking in PHP docs for "?" and ":" and
didn't find it there. I use this line in my script to assign different
value for $bgcolor variable to color rows in result, but I want to
understand what does it m
> In article <3B8A1D6A.4295.2947D@localhost>, [EMAIL PROTECTED]
> (Yura) wrote:
>
> > How to sort search results of php-mysql site by relevance?
>
> See the mysql manual's chapter on FULLTEXT indexes.
I indexed column 'text' and tried to add "ORDER BY text DESC" in
query and deleted wildcards
On 29 Aug 2001, at 9:18, Mark Maggelet wrote:
> On Wed, 29 Aug 2001 13:58:34 +0200, BRACK ([EMAIL PROTECTED]) wrote:
> >> In article <3B8A1D6A.4295.2947D@localhost>, [EMAIL PROTECTED]
> >> (Yura) wrote:
> >>
> >> > How to sort search results of
Oh yeah!
I just had old MySQL manual but I have upgraded MySQL and this
function is working in my version, just was not described in docs
Okay, thank you for help, I managed to do it.
> On Wed, 29 Aug 2001 13:58:34 +0200, BRACK ([EMAIL PROTECTED]) wrote: >>
> In article <3B8A
I have query -
$res = mysql_query("SELECT
skits.*,category.cat_id,category.cat_name FROM skits,category WHERE
MATCH (title,descr,skits) AGAINST ('%$search_idea%') and skits.lang
like 'English' and skits.category like category.cat_id limit $limit,10 ");
I expect to get results sorted by relev
Works fine, thank you
Youri
> On Sat, 1 Sep 2001 14:01:57 +0200, BRACK ([EMAIL PROTECTED]) wrote: >I
> have query - > >$res = mysql_query("SELECT
> >skits.*,category.cat_id,category.cat_name FROM skits,category WHERE
> >MATCH (title,descr,skits) AGAINST ('%$
I have made a detetor of relevance in found results in form of
colored ine od length depended on relevance. I did it this way:
In query I inserted match (...,...,...) against ('%$var%') as relevance
in while loop I inserted
$relevance = $row["relevance"];
$rel = round($relevance);
print "\n";
Hi,
I asked recently to help with the selection for FULLTEXT search
and now with your help I found how to do that but I still have
problem with advansed search.
This is what I have right now:
$result = mysql_query("SELECT skits.*,category.* from
skits,category where (skits.title like '%$tit
category.kat_name like '%$category_search%') and
(skits.category like category.cat_id) ORDER by relevance desc
limit $limit,10");
Works fine, (I actually changed '&&' with 'and' as you see)
Youri
> On Mon, 3 Sep 2001 19:33:38 +0200, BRACK ([EMAIL PR
I have a site where ppl can upload their text-based ideas in real
time, so that I have new records in db every day. When I did
uploading by hands and had over 200 files on that site I distributed
all site content in downloadable for of zipped win-help formate.
Well, I don't think that I can do
I have a website URL www.body-builders.org and users have URLs
like www.body-builders.org/user According to the virtual hosting
rules I can do any configuration tweaks by .htaccess file.
What I want to do is to offer my users URLs like users.body-
builders.org Is it possible to do with rewrite
>
> Subdomains are first a DNS issue... The first place you have to go is
> your DNS config, since users.body-builders.org wouldn't exist without
> an A or CNAME record.
My subdomains do not have DNSs =(( and I'm not sure if I can
change this issue with .htaccess
>
> I don't know if mod_rewrit
Like Music? Buy a CD:
> http://l-i-e.com/artists.htm Volunteer a little time:
> http://chatmusic.com/volunteer.htm - Original Message - From:
> Brack <[EMAIL PROTECTED]> Newsgroups: php.general To:
> <[EMAIL PROTECTED]> Sent: Saturday, September 08, 2001 6:57 AM
37 matches
Mail list logo
