 |
|
Index ‹ php-general
|
- Previous
- 8
- [PHP] I need an opion!!! Thanks!Sebastian Dieser wrote:
> Hi, we have been using the following codes on our site for a year and I wanted to know if these codes are just spaghetti or its actual usable code. I know it can be bettered a lot I just need opinions if the codes can be used a while more until we reprogram everything as a complete CMS system.
>
> Thanks a lot! my superiors want to know because there is another coder that says these codes are just spaghetti.
>
> There is more codes but i am able to access the database fine and everything else. Of course the codes can be bettered but i dont believe its just spaghetti!!!!! I used these codes because there was no need to reinvent the wheel. I apreciate your help!
I hope you have indenting in your code and it's just the email that came
through badly.
I wouldn't say it's spaghetti code but it could do with a clean-up.
--------
if ($loginConnector->getNumRows($getUser)> 0){
// Login OK, store session details
// Log in
$_SESSION["user"] = $user;
$_SESSION["pass"] = $this->userdata['pass'];
$_SESSION["thegroup"] = $this->userdata['thegroup'];
if ($goodRedirect) {
header("Location: ".$goodRedirect."?".strip_tags(session_id())) ;
}
return true;
}else{
--------
If you're returning out of the function there why do you need an else?
PHP will automatically skip that block if it's not going to process that
code path.
--------
// If user is already logged in then check credentials
if ($_SESSION['user'] && $_SESSION['pass']){
--------
...
reverse that:
if (!isset($_SESSION['user']) || !isset($_SESSION['pass'])) {
return false;
}
You remove a huge if block which isn't needed.
--------
query('SELECT * FROM vendors WHERE ID = '.$HTTP_GET_VARS['id']);
--------
Go to this website and read everything you can find:
http://phpsec.org/projects/guide/
You have sql injection here that needs attention (and if it's here I'm
sure there could be other spots too).
Also HTTP_GET_VARS is old, change it to the newer $_GET['id'] syntax.
--
Postgresql & php tutorials
http://www.designmagick.com/
- 11
- Checking for marked checkboxWhen cycling through a MySQL database I made a table the first column
of the table I made a checkbox so that if a user checks that checkbox
they can modify the information in that row. I don't know if this is
the best way to present a user information so that they can edit it.
Anyway, these checkboxes are labelled user[0], user[1] and so on. I was
wondering if there would be an easy way to check to see if any or all
of these are checked without manually doing if...else statements for
each one.
Thanks
- 13
- smarty for ajaxIs there any framework or plugin for smarty which can be used with Ajax?
M
- 14
- [PHP-DB] REMOVE MEgo to news.php.net and subscribe your self.
On 9 Oct 2003 at 15:47, Muzzamil wrote:
>
> Plzzzz remove me from this mailing list
> Thanks
> email***@***.com
>
>
> > php-db Digest 8 Oct 2003 19:41:35 -0000 Issue 2071
> >
> > Topics (messages 30898 through 30907):
> >
> > Re: Is it possible to access MySQL table on server A from server B?
> > 30898 by: ramki
> > 30900 by: Cesar Schneider
> >
> > My SQL update one table, using reference from another...
> > 30899 by: Tristan.Pretty.risk.sungard.com
> >
> > Re: support to palm db
> > 30901 by: Cesar Schneider
> >
> > mysql_error() returning nothing
> > 30902 by: Ben Edwards
> > 30904 by: Ben Edwards
> >
> > PHP APACHE Database
> > 30903 by: Paul Ciba
> >
> > Problem with uploadscript
> > 30905 by: Ruprecht Helms
> > 30906 by: George Patterson
> >
> > Php433 running on RedHat73 with support to OCI8
> > 30907 by: Adriano Rocha
> >
> > Administrivia:
> >
> > To subscribe to the digest, e-mail:
> > email***@***.com
> >
> > To unsubscribe from the digest, e-mail:
> > email***@***.com
> >
> > To post to the list, e-mail:
> > email***@***.com
> >
> >
> > ----------------------------------------------------------------------
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
- 15
- Is there any special way for variable++?Say I have a table in a MySQL server
ID USERNAME COUNT
0 JOHN 2
1 JANE 3
2 HOMER 3
3 MOE 2
If I want to increase Homer's count by 1,
The plain way would be;
1)$TEMP=SELECT COUNT WHERE ID=2
2)$TEMP++
2)UPDATE .. SET COUNT=$temp...
I guess if there is any special way to increase the int value by one?
For increasing 1 is so commonly used (that's why c,c++,java,C# has the
operator ++).
- 15
- [PHP] Where can I get the Printer extension?Chuck Anderson wrote:
> It thought it would be bundled with my Windows version pf Php 4.4.1, but
> it is not.
>
> I've searched for it and can't find it at php.net.
You didn't search very hard.
On this page:
http://php.net/printer
Read the bit under "Installation".
"This PECL extension is not bundled with PHP."
and
"You may obtain this unbundled PECL extension from the various PECL
snaps pages (select the appropriate repository for your version of PHP):
PECL for PHP 4.3.x, PECL for PHP 5.0.x or PECL Unstable."
--
Postgresql & php tutorials
http://www.designmagick.com/
- 15
- Help with Flat File Database Image GalleryI don't have a database available, so i'm writing an Image Gallery with
a flat file database.
I have an Add Page:
Uploads Image file, and saves $filename and $caption to text file:
captions.txt
Captions.txt is in format:
photofilename.jpg|caption to do with photo here.
I can easily read out each individual part from the captions.txt file to
display the photo and caption on a display page. I also have a delete
file that unlinks the photo, using the info in the captions.txt file,
but i can't figure out how to remove the entire line from the database
file based on the filename...??? Basically I want to click on an image
like this:
<a href=delete.php?filename=phototodelete.jpg> and have the delete.php
file unlink the picture, and then erase the line in the text file, that
begins with the filename (phototodelete.jpg).
I guess i need to search through the data file and when i match the
filename, erase the line... I'd appreciate any help with that!
Cheers
Matt
- 15
- \n \t don't work!!!Guys,
These codes are copied from the manual:
*****************************************************
echo ("this is the simplest, an SGML processing instruction\n");
echo "This spans
multiple lines. The newlines will be
output as well";
echo "This spans\nmultiple lines. The newlines will be\noutput as well.";
******************************************************
None of them works. I mean there're not any new lines generated in my
browser and I have to use the echo"<br>" to print a new line. But why
doesn't the \n work? BTW, the \t doesn't work either.
(WindowsXP Pro + PHP Version 4.1.1)
Please advise.
cheers,
feng
- 15
- what 's wrong of the syntax<html>
<?
$code=0001;
$name="hello";
<a herf="../"+$code+"/profile.htm" title=$name target="_top">$name</a>
?>
</html>
i suppose the output is a hyper link , but why i can do that?
thanks!
- 15
- M'I-5,Perse cution ' harassm ent at wo rk-=-=-=-=-=-=-=-=-=-=-=-=
-= harassment at. work -=
-=-=-=-=-=-=-=-=-=-=-=-=
Once I stopped watching television and listening to. the radio at the end of
1990, "they" had to find other ways of committing. abuses. So they took what
must be for them a tried and tested route; they get at you by. subversion of
those around you. Since they wouldn't be able to do that. with my family or
friends, that meant getting at people in the workplace to. be their
mouthpieces and do. their dirty work for them.
They supplied my employers in Oxford with details from what was going. on in
my private life, and what I and other people. had said at my home and
accommodation in Oxford. So people at work repeated verbatim words. which
had been said in my home, and repeated what I'd been. doing recently. Often
the most. trivial things, the ones from your domestic life, are the ones
which hurt most. One manager in particular at. Oxford continuously abused me
for ten months with verbal sexual abuse, swearing, and threats to. terminate
my employment. After ten months. I was forced to seek psychiatric help and
start taking medication, and was away. from work for two months. I spoke
later with a. solicitor about what had happened at that company; he advised
it was only possible to. take action if you had left the company as a result
of harassment, and such an action would have to be started very soon. after
leaving.
Over. a year later the same manager picked on another new worker, with even
more serious results;. that employee tried to commit suicide with an
overdose as a result of the ill-treatment, and was forced. to leave his job.
But he didn't take action. against the company, either. Abuse at work is
comparable to. that elsewhere in that tangible evidence is difficult to
produce,. and the abusers will always have their denials ready when
challenged. And even if a court accepts what you say happened, it. still
remains to prove that abuse causes the. type of breakdown I had at the end
of 1992. In a recent case before a. British court, a former member of the
Army brought a case against others who. had maltreated him ten years
previously. Although the. court accepted that abuse had occurred, it did not
agree that depressive illness necessarily followed, and denied. justice to
the. plaintiff.
4315
- 16
- php to generate java-scriptAnyone have a good method of grabbing the current page and reading data
from it?
For example:
<?PHP
// find all form fields for current page
function FindFormFields( $page ) {
if( empty( $page ) ) {
$data = -1;
} else {
if( ( $fh = @fopen( $page, "r" ) ) === FALSE ) {
$data = -1;
} else {
while( !feof( $fh ) ) {
$line = fgets( $fh, 512 );
if( eregi( "<input type=\"", $line ) ) {
$data[] = $line;
}
}
fclose( $fh );
}
}
return $data;
}
echo FindFormFields( "http://php.net" );
?>
The above code would output the following:
Array
(
[0] => <input type="text" name="pattern" value="" size="30"
accesskey="s" />
[1] => <input type="image"
)
Now for the problem I am having and a description of what I am trying to
accomplish:
I want to dynamically generate a form and in doing so I would like to
dynamically generate the following javascript features for said page
- javascript form validation
- javascript form field focus
The problem is if I call the current page that is being generated such as
<?PHP
echo FindFormFields( "http://" . $_SERVER['SERVER_NAME'] .
$_SERVER['REQUEST_URI'] );
?>
Not only does it take a helluva long time to load the page but it also
creates a nested array with duplicate values.
My best guess is that the order in which the page is being generated has
something to do with the lag as well as the nested array with duplicate
values.
Could anyone help me or point me in a better direction for performing
these actions?
Thanks in advance,
Jas
- 16
- $$$$$$$$make money online$$$$$$$$50,000 for only $5 in two months? You gotta be crazy! How can you
make $50,000 for only $5? Well, that's what I was wondering too until
I came across this letter.
First of all, IT'S PERFECTLY LEGAL! (Call 1-800-725-2161) if you have
any questions about the following opportunity to make $50,000.00 and
that probably WITHIN LESS THAN TWO MONTHS!
Well, here it goes: A little while back, I was browsing these
newsgroups, just like you are now, and came across an article similar
to this that said you could make thousands of dollars within weeks
with
only an initial investment of $5.00! So I thought, "Yeah, right, this
must be a joke," but like most of us I was curious, so I kept reading.
Anyway, it said that you send $1.00 to each of the 5 names and
address
stated in the article. You then place your own name and address in
the
bottom of the list at #5, and post the article in at least 200
newsgroups. (There are thousands) No catch, that was it.
As I mentioned before, like most of us I was a little skeptical and a
little worried about the legal aspects of it all. So I checked it out
with the U.S. Post Office (1-800-725-2161) and they confirmed that it
is indeed legal!
What are the basics of each system and why are they legal? Each
system
follows the same basic steps which define a business by offering
others
the ability to get involved using the system you advertise in
newsgroups
on the Internet and accepting a small fee for the requests of those
who
respond to be added to your mailing list. Yes, you will be in the
business of creating your own mailing list. Their requests to be
added
to your mailing list which is sent with a $1 fee for your service
define
a legal business opportunity under U.S. Postal and Lottery Laws --- a
legal business opportunity for you which is covered in title 18,
sections 1302 and 1342 of the U.S. Postal and Lottery Laws.
Now, what one does, or does not do, with the mailing list being
constructed is a personal decision. One could decide to do nothing
with this list, to use it as a tool in building another business or
expanding an existing business. This decision is up to the creator of
the mailing list -- this decision is up to you.
Make sure you print a copy of this article NOW, so you can get the
information off of it as you need it. The process is very simple and
consists of 3 easy steps:
STEP 1: Get 5 separate pieces of paper and write the following on
each
piece of paper "PLEASE PUT ME ON YOUR MAILING LIST." Now get 5 $1.00
bills and place ONE inside EACH of the 5 pieces of paper so the bill
will not be seen through the envelope to prevent thievery. Next,
place
one paper in each of the 5 envelopes and seal them. You should now
have
5 sealed envelopes, each with a piece of paper stating the above
phrase
and a $1.00 bill. What you are doing is creating a service by this.
THIS IS PERFECTLY LEGAL! Mail the 5 envelopes to the following
addresses:
#1 G. Duchacek
1825 Lee Janzen Drive,
Kissimmee Bay,
Kissimmee, FL. 347347
#2 T. Roberts
4810 Meadow Lark Lane
Paso Robles, CA 93446-4220
#3 D. Wild
32 Ridgeview Circle
Milan, Oh 44846
#4 Smith
935 E. South
Independence, MO 64050
#5 t. rojas
42-40 212st apt 3a
bayside, ny 11361
STEP 2: Now take the #1 name off the list that you see above, move
the
other names up (2 becomes 1, 3 becomes 2, etc.....) and add YOUR Name
as number 5 on the list.
STEP 3: Change anything you need to, but try to keep this article as
close to original as possible. Now, post your amended article to at
least 200 newsgroups. (There are over 35,000 groups with more being
added all the time) All you need is 200, but remember, the more you
post, the more money you make! Don't know HOW to post in the
newsgroups?
Well do exactly the following:
FOR NETSCAPE USERS:
1) Click on any newsgroup, like normal. Then click on "To News",
which
is in the top left corner of the newsgroup page. This will bring up a
message box.
2) Fill in the SUBJECT with a flashy title, like the one I used,
something to catch the eye!!!
3) Now go to the message part of the box and retype this letter
exactly
as it is here, with exception of your few changes. (remember to add
your
name to number 5 and move the rest up)
4) When your done typing in the WHOLE letter, click on 'FILE' above
the
send button. Then, 'SAVE AS..' DO NOT SEND YOUR ARTICLE UNTIL YOU
SAVE
IT. (so you don't have to type this 200 times :-)
5) Now that you have saved the letter, go ahead and send your first
copy! (click the 'SEND' button in the top left corner)
6) This is where you post all 200! OK, go to ANY newsgroup article and
click the 'TO NEWS' button again. Type in your flashy subject in the
'SUBJECT BOX', then go to the message and place your cursor here. Now
click on 'ATTACHMENT' which is right below the 'SUBJECT BOX'. Click
on
attach file then find your letter wherever you saved it. Click once
on
your file then click 'OPEN' then click 'OK'. If you did this right,
you
should see your filename in the 'ATTACHMENT BOX' and it will be
shaded.
NOW POST AWAY!
FOR INTERNET EXPLORER:
It's just as easy, holding down the left mouse button, highlight this
entire article, then press the 'CTRL' key and 'C' key at the same
time
to copy this article. Then print the article for your records to have
the names of those you will be sending $1.00 to.
Go to the newsgroups and press 'POST AN ARTICLE' type in your flashy
subject and click the large window below. Press 'CTRL' and 'V' and the
article will appear in the message window. **BE SURE TO MAKE YOUR
ADDRESS CHANGES TO THE 5 NAMES.** Now re-highlight the article and
re-copy it so you have the changes.... then all you have to do for
each
newsgroup is 'CTRL' and 'V' and press 'POST'. It's that easy!! THAT'S
IT! All you have to do is jump to different newsgroups and post away,
after you get the hang of it, it will take about 30 seconds for each
newsgroup!
**REMEMBER, THE MORE NEWSGROUPS YOU POST IN, THE MORE MONEY YOU WILL
MAKE!! BUT YOU HAVE TO POST A MINIMUM OF 200**
**If these instructions are too complex to follow, try Forte's "Free
Agent." It is freeware for noncommercial use. To download it, simply
use a search utility and type "Forte Free Agent". You should be able
to
find it.**
That's it! You will begin receiving money from around the world within
days! You may eventually want to rent a P.O. Box due to the large
amount
of mail you receive. If you wish to stay anonymous, you can invent a
name to use, as long as the postman will deliver it. **JUST MAKE SURE
ALL THE ADDRESSES ARE CORRECT.**
Now the WHY part: This entire principle works because it is in a
format
of an upside down tree with thousands of branches. Everyone below you
will see to it that the tree continues because they want to get
money.
Those below THEM will continue because THEY want to get the cash
etc.
Out of 200 postings, say I receive only 5 replies (a very low
example).
So then I made $5.00 with my name at #5 on the letter. Now, each of
the
5 persons who just sent me $1.00 make the MINIMUM 200 postings, each
ith my name at #4 and only 5 persons respond to each of the original
5,
that is another $25.00 for me, now those 25 each make 200 MINIMUM
posts
with my name at #3 and only 5 replies each, I will bring in an
additional $125.00! Now, those 125 persons turn around and post the
MINIMUM 200 with my name at #2 and only receive 5 replies each, I will
make an additional $626.00! OK, now here is the fun part, each of
those
625 persons post a MINIMUM of 200 letters with my name at #1 and they
each only receive 5 replies, that just made me $3,125.00!!! With a
original investment of only $5.00! AMAZING! And as I said 5 responses
is actually VERY LOW! Average is probable 20 to 30! So lets put those
figures at just 15 responses per person. Here is what you will make:
at #5 $15.00
at #4 $225.00
at #3 $3,375.00
at #2 $50,625.00
at #1 $759,375.00
Your name is no longer on the list, you just take the latest posting
in
the newsgroups, and send out another $5.00 to names on the list,
putting
your name at number 5 and start posting again. The thing to remember
is
that thousands of people all over the world are joining the Internet
and
reading these articles everyday, JUST LIKE YOU are now!! And this will
go on and on and on and on.... get the picture? Well, there's over
5,000,000,000 people on the world and most of them will eventually end
up being hooked into the Internet. So there are virtually unlimited
resources. Of course this will work the best at the very beginning so
the faster you post, the better for YOU!
So can you afford $5.00 and see if it really works?? I think so!
People
have said, "what if the plan is played out and no one sends you the
money? So what! What are the chances of that happening when there are
tons of new honest users and new honest people who are joining the
Internet and newsgroups everyday and are willing to give it a try?
Estimates are at 20,000 to 50,000 new users, every day, with thousands
of those joining the actual Internet. Remember, play FAIRLY and
HONESTLY and this will work. You just have to be honest. Make sure
you
print this article out RIGHT NOW, also. Try to keep a list of everyone
that sends you money and always keep an eye on the newsgroups to make
sure everyone is playing fairly.
Remember, HONESTY IS THE BEST POLICY. You don't need to cheat the
basic
idea to make the money!! GOOD LUCK to all and please play fairly and
reap the huge rewards from this, which is tons of extra CASH. **By the
way, if you try to deceive people by posting the messages with your
name
in the list and not sending the money to the rest of the people
already
on the list, you will NOT get as much. Someone I talked to knew
someone
who did that and he only made about $150.00, and that's after seven or
eight weeks! Then he sent the 5 $1.00 bills, people added him to their
lists, and in 4-5 weeks he had over $10k. This is the fairest and most
honest way I have ever seen to share the wealth of the world without
costing anything but our time!!! You also may want to buy mailing and
e-mail lists for future dollars. Please remember to declare your
extra
income. Thanks once again.
- 16
- security compromisedHi newsgroup,
it appears someone has broken into my site. This morning I found about 20
files (each called index.htm) suddenly featured this line:
<IFRAME SRC="url-of-bad-site" WIDTH=1 HEIGHT=1></IFRAME>
and their last modified date was set to today between midnight and 1 GMT. In
some files, this line was placed directly after the body opening tag, in
others it was just before </body>. In one file where the whole document is
written in javascript, they had even escaped their quotes!
The malicious url is www.b00gle.com/fa/?d=get
I have no access to the raw server logs and my own log script shows no
strange hits around that time.
How have they done this? And what can I do about it? I ask here because the
site uses PHP a lot but I guess there are more appropriate places to ask.
Thanks
Ivo
- 16
- How much execution time is left?I'm using set_time_limit() to set maximum execution time. Is there a
way to check how much time is left at any time during the execution
itself?
- 16
- Flash+PHP photo album: which one??Hi there guys!!
I'm looking for a Flash photo album to put my pics online.
That album should be like the great http://www.imagevuex.com/imagevue
which has a PHP admin script that allows to upload pictures and
automatically create thumbs and pages.
Unfortunately, imagevue is quite an hassle if you have to upload high
resolution pictures (i.e. 8megapixel) because it doesn't resize the
original images, instead you have to upload them at 640x480.
Do you know of any good flash album with PHP script?
Thanks in advance!!
Enrico
|
| Author |
Message |
john_blakley
|
 Posted: 2003-10-18 3:21:28 |
Top |
php-general, Dynamic SQL query help
Hi all,
First off, I'm a newbie.
Can someone help? I have been fighting this for 3 days now and can't
figure out what's wrong.
I'm trying to create a SQL query based off of $HTTP_POST_VARS. Here's
the code:
foreach($HTTP_POST_VARS as $key => $value)
{
$sStr=array($key . "=" . $value . ", ");
$search=join(",",$sStr);
echo $search; //echoing here to print $search values.
$query="Select * from employee where"."?".$search;
}
echo $query;
The problem is: I have 7 fields on a search form. I never know what
and in what combination someone will search with. I was wanting to
build a query based off of the values that HTTP_POST_VARS receives. I
can get the full 'query' string up to the echo $search statement. But
2 problems happen. What I want to search on is there, but, when I add
it to the $query= statement, I only get the last value of
HTTP_POST_VARS!!! Nothing else. I'm frustrated. Maybe someone could
help me with the code to be able to build the SQL statement on the
fly. The other thing that happens is my $search=join statement leaves
a comma at the end of the last HTTP_POST_VARS which would (when it
works) create an error in the SQL statement and I need to strip that
last comma out so the statement doesn't fail.
Thanks for your help!
|
| |
|
| |
|
john_blakley
|
| Posted: 2003-10-20 21:33:00 |
Top |
php-general >> Dynamic SQL query help
Hi all,
First off, I'm a newbie.
Can someone help? I have been fighting this for 3 days now and can't
figure out what's wrong.
I'm trying to create a SQL query based off of $HTTP_POST_VARS. Here's
the code:
foreach($HTTP_POST_VARS as $key => $value)
{
$sStr=array($key . "=" . $value . ", ");
$search=join(",",$sStr);
echo $search; //echoing here to print $search values.
$query="Select * from employee where"."?".$search;
}
echo $query;
The problem is: I have 7 fields on a search form. I never know what
and in what combination someone will search with. I was wanting to
build a query based off of the values that HTTP_POST_VARS receives. I
can get the full 'query' string up to the echo $search statement. But
2 problems happen. What I want to search on is there, but, when I add
it to the $query= statement, I only get the last value of
HTTP_POST_VARS!!! Nothing else. I'm frustrated. Maybe someone could
help me with the code to be able to build the SQL statement on the
fly. The other thing that happens is my $search=join statement leaves
a comma at the end of the last HTTP_POST_VARS which would (when it
works) create an error in the SQL statement and I need to strip that
last comma out so the statement doesn't fail.
Thanks for your help!
|
| |
|
| |
|
| |
|
Index ‹ php-general |
- Next
- 1
- sending variable to include fileHi, I'm pretty new to php but I've been working on a site and have a
problem I can't fix, though it's probably pretty simple.
Basically I have an index.php file that includes a header.php file. I
attempt to pass a variable to it as follows:
<?include("header.php?page=Home");?>
Then the header.php file contains this code:
<?php
$page = $_GET['page'];
?>
<html><head><title><?$page?></title>
I want $page to contain the string "Home" of course, but it ends up
being nothing but an empty string.
Thanks in advance for your help.
Matt
- 2
- Help with scripts to add records to a databaseI am following the tutorial at
http://www.freewebmasterhelp.com/tutorials/phpmysql/
The source code is on the website on the left hand side
http://www.freewebmasterhelp.com/static/tutorials/phpmysql/example.zip
My software:
PHP version 4.3.4 on Windows 2000
MYSQL version 4.0.16 on Windows 2000
Apache version 1.3.29 on Windows 2000
The problem is I cannot get the database to add a new records aside from
the auto-increment field. All the other fields are left blank when the
add.html is subitted.
I have the add.html with the following code exactly the same as the
source code.
<form action="insert.php" method="post">
First Name: <input type="text" name="first"><br>
Last Name: <input type="text" name="last"><br>
Phone: <input type="text" name="phone"><br>
Mobile: <input type="text" name="mobile"><br>
Fax: <input type="text" name="fax"><br>
E-mail: <input type="text" name="email"><br>
Web: <input type="text" name="web"><br>
<input type="Submit">
</form>
The insert.php
<?
include("dbinfo.inc.php");
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = "INSERT INTO contacts VALUES
('','$first','$last','$phone','$mobile','$fax','$email','$web')";
mysql_query($query);
mysql_close();
?>
Any help would be much appreciated.
Regards,
Mark
- 3
- Identifying user's pick from selection listI have an application that uses PHP to access a MySQL table and
extract rows which match the user's search entry. Data from the
matching rows are loaded into an HTML selection list, and the user can
scan the list and highlight a selected item.
My question: In PHP, what is the syntax for identifying which row is
highlighted?
My goal is to pass the unique row ID of the selected item to a
subsequent form where all the fields will be displayed for the user to
edit.
I already have the code that loads the selection list and the code
that displays the fields. I just need to know how to determine the
highlighted item.
I have two PHP books, and both discuss loading the selection list, but
there is no mention of what to do next.
Thanks!!
Mark Jones
- 4
- Php or Perl for CGI?Hi. I'm trying to learn how to implement CGI on my site, and would like to
know what are the advantages of using Perl over PHP, if any. Thanks in
advance.
Ziggi
- 5
- Solaris 9: Can't build libjpeg shared object for php useI realize this is the php group, but I have a question that recurses
back to my php install.
My objective is a pure 64 bit shared object installation of php 5.0 on
UltraSparc Solaris 9 compiled with the Sun Compiler version 8.
My problem is that EVERYTHING builds great EXCEPT that the 6b
distribution of JPEG will NOT build a shared object, thus gd cannot
include support for JPEG, thus php loses that functionality.
** Configuration summary for gd 2.0.28:
Support for PNG library: yes
Support for JPEG library: no
Support for Freetype 2.x library: yes
Support for Xpm library: yes
Support for pthreads: yes
Yes, I've seen the install.doc from jpeg-6b:
"* If you want to build libjpeg as a shared library, say
./configure --enable-shared"
Here's that output:
1 [gis 9] ~/jpeg-6b > ./configure --enable-shared
2 checking for gcc... /opt/SUNWspro/bin/cc
3 checking whether the C compiler (/opt/SUNWspro/bin/cc -fast
-xarch=v9a -xO5 ) works... yes
4 checking whether the C compiler (/opt/SUNWspro/bin/cc -fast
-xarch=v9a -xO5 ) is a cross-compiler... no
5 checking whether we are using GNU C... no
6 checking how to run the C preprocessor... /opt/SUNWspro/bin/cc
-E
7 checking for function prototypes... yes
8 checking for stddef.h... yes
9 checking for stdlib.h... yes
10 checking for string.h... yes
11 checking for size_t... yes
12 checking for type unsigned char... yes
13 checking for type unsigned short... yes
14 checking for type void... yes
15 checking for working const... yes
16 checking for inline... inline
17 checking for broken incomplete types... ok
18 checking for short external names... ok
19 checking to see if char is signed... yes
20 checking to see if right shift is signed... yes
21 checking to see if fopen accepts b spec... yes
22 checking for a BSD compatible install...
/usr/local/bin/install -c
23 checking for ranlib... ranlib
24 LTSHARED is yes
25 ------------> I am using libtool in /usr/local/bin/libtool
26 checking host system type... sparc-sun-solaris2.9
27 checking for ranlib... ranlib
28 checking whether we are using GNU C... no
29 checking for /opt/SUNWspro/bin/cc option to produce PIC...
-KPIC
30 checking if /opt/SUNWspro/bin/cc PIC flag -KPIC works... no
31 checking if /opt/SUNWspro/bin/cc static flag -Bstatic works...
none
32 checking whether ln -s works... yes
33 checking for non-GNU ld... /usr/ccs/bin/ld
34 checking if the linker (/usr/ccs/bin/ld) is GNU ld... no
35 checking whether the linker (/usr/ccs/bin/ld) supports shared
libraries... yes
36 checking for BSD-compatible nm... /usr/ccs/bin/nm -p
37 checking command to parse /usr/ccs/bin/nm -p output... yes
38 checking how to hardcode library paths into programs...
immediate
39 checking for /usr/ccs/bin/ld option to reload object files...
-r
40 checking dynamic linker characteristics... solaris2.9 ld.so
41 checking if libtool supports shared libraries... no
42 checking whether to build shared libraries... no
43 checking whether to build static libraries... yes
44 checking for objdir... .libs
45 creating libtool
46 checking libjpeg version number... 62
47 creating ./config.status
48 creating Makefile
49 creating jconfig.h
50 jconfig.h is unchanged
51 [03:35 - 0.21]
As you can see from line 41 above, configure is convinced libtool
cannot support shared libraries. I modified the configure script to
output the location of the libtool being used (line 25) and the value
of LTSHARED (line 24).
Has ANYONE out there successfully milked out a shared object from the
6b distribution of libjpeg ?? This is the only thing holding up my
build.
Thanks in advance,
Phil
- 6
- Getting MySQL Generated KeysHi,
I am a Java/JSP developer by trade but am currently developing a
MySQL/PHP solution.
In JSP when I run an INSERT statement on the db I am able to
automatically get back a list of any generated keys (without having to
do some sort of subsequent query to get the information).
Is there a PHP equivilent of this?
Thanks
- 7
- [PHP] how do I get a remote db connection?Irvin Amoraal wrote:
> I have two independent websites, both with their own mySQL db's. I would
> like to run a query in site A against site B's database. I am trying to
> establish a connection using something like:
> $conn = mysql_connect("abc.com:3306", $user, $pass);
>
> A warning is returned to the browser :
> Access denied for user: 'email***@***.com' where my_web_host.net is the
> name of the host server.
>
> The db's name would be abc_com (This is not the actual name but the form is
> consistent with the real db name).
>
> If I try port 3307 I get "Can't connect to MySQL server on 'abc.com'(111),
> so I assume that I am able to communicate with the msSQL server itself, but
> is a permissions issue. I know that the username and password are correct.
>
> Could it be that remote acccess to the db is disabled? Or am I omitting
> something?
Yes, more than likely. You need permission within the grant tables for
Site A to connect to it from host Site B.
--
---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
PHP|Architect: A magazine for PHP Professionals ?www.phparch.com
- 8
- PHP + MySQLif i do this:
mysql_query("SELECT id,game,release, from nexus order by release ASC");
it will print a table like this:
id game release
6 gangland 04.03.2004
7 sacred 23.03.2004
8 far cry 23.03.2004
So it orders them by date and by ID...
tried something like withouth success ('coz i'm a newb)
mysql_query("SELECT id,game,release, from nexus order by release ASC AND
order by game ASC");");
How can i get far cry to be before sacred (alphabetically)??
Thanks in advance ;)
-jK-
- 9
- #40581 [NEW]: Pass Struct type to COM object from PHPFrom: elvir at innvue dot com
Operating system: Windows Server 2003
PHP version: 5.2.1
PHP Bug Type: COM related
Bug description: Pass Struct type to COM object from PHP
Description:
------------
hello,
I have a COM object created in c++. One of methods accept a struct as a
parameter. I have to call this method from PHP script.
Reproduce code:
---------------
object accepted:
typedef [uuid(5A0CB3A7-798A-42ff-B864-F8D90B55DB7C)] struct mystruct
{
LPSTR var1;
LPSTR var2;
LPSTR var3;
LPSTR var4;
} mystruct
$newCom = new COM("classname.methodname") or die (" COM exeption");
if(method_exists ($newCom, "ResetS"))
// this retun true
Expected result:
----------------
what i want is:
call my method with the following param from php:
$newCom->mymethod(mystruct sructPHP, GUID sku);
Please can you help me?
Actual result:
--------------
I tryed to create an object in PHP and call method i get the following
error:
'com_exception' with message 'Error [0x80028019] Old format or invalid
type library.
--
Edit bug report at http://bugs.php.net/?id=40581&edit=1
--
Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=40581&r=trysnapshot44
Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=40581&r=trysnapshot52
Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=40581&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=40581&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=40581&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=40581&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=40581&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=40581&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=40581&r=support
Expected behavior: http://bugs.php.net/fix.php?id=40581&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=40581&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=40581&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=40581&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=40581&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=40581&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=40581&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=40581&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=40581&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=40581&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=40581&r=mysqlcfg
- 10
- [PHP] PHP 4.4.6 RC1 ReleasedOn Thu, 22 Feb 2007, bruce wrote:
> just out of curiousity. are these changes also automatically rolled into the
> php 5.x stream?
Yes, they will be there as well. However, the session issue is not a
problem in that branch.
regards,
Derick
- 11
- PHP is rendered like a txt fileI am new to PHP, trying to learn the ropes if you will. Now, I
published a .php file to a web server through FTP about an hour ago,
expecting it to be rendered like an HTML file, except with a .php
extension. I was surprised to see it came out looking like a text file.
Can anyone help me with this, or tell me what I did wrong? Thanks.
Aaron Kinney
- 12
- Reccomendations for a good file manager script.
Hi!
I would like a nice php based file manager script so when someone goes
to a directory they can see the contents and be able to download
files.
Currently my Apache can do this but the rows are limited to 25-30
characters long and that makes identification of files a little hard.
I know there are an array of files out there which is why i am asking
for recommendations. :)
Thanks in advance for any help.
Engelkott
- 13
- piping php-generated xml to flash
Hello,
I'm building a photo gallery using flash as a front-end to a mysql
database. I use php to query the database.
I was wondering if it was possible to generate xml into a stream that
would be directly piped to flash.
See, normally one would use php to write an xml file that would then be
read by flash eg.
xmlData = new XML();
xmlData.load("query_results.xml")
what I want is this: xmlData.load("query.php") where query.php would be
something like
<?php
echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>"
echo "<images>";
echo "<img_data>";
echo "<val title=\"$title\"/>
echo "<val path=\"$path\"/>
echo "</img_data>
echo "</images>
?>
Henri
--
The Dude once said,
"Yeah, well, you know, that's just, like, your opinion, man."
- 14
- Example from www.php.netI was trying Example 2147, which reads:
-------------------------------
<?php
$string = <<<XML
<a xmlns:b>
<foo name="one" game="lonely">1</foo>
</a>
XML;
$xml = simplexml_load_string($string);
foreach($xml->foo[0]->attributes() as $a => $b) {
echo $a,'="',$b,"\"\n";
}
?>
-------------------------------
It says that 'The above example will output:
name="one"
game="lonely"'
However, in my case it outputs nothing.
(I'm running php-5.1.6 under Fedora-6.)
Is there an error in the example;
or is the error mine?
--
Timothy Murphy
e-mail (<80k only): tim /at/ birdsnest.maths.tcd.ie
tel: +353-86-2336090, +353-1-2842366
s-mail: School of Mathematics, Trinity College, Dublin 2, Ireland
- 15
- Get error when I add new theme & select it in setting. Error shuts down postnukeWhether i purchase a new theme or add a free theme the result is the
same. I up load the new theme to my director fine. I go to admin
control and select it click save and immediately get the following
errow message:
Fatal error: Call to undefined function: themeheader() in /home/
virtual/site925/fst/var/www/html/postnuke/header.php on line 188
|
|
|
