Date: 11/27/07 (PHP Community)    Keywords: php, mysql, html, sql, apache

This is an update from this post last week. So far, I've had no luck with it. To recap my config settings:

PHP 5.2
Installed on Windows XP, C:/php
php.ini file copied to c:/windows/system32
doc_root = "E:\public_html"
extension_dir = "C:/php/ext"
extension=php_mysql.dll uncommented

Apache 2.2.4
Installed under C:/Apache
php5 running as a module
document root, E:\public_html

Source: http://community.livejournal.com/php/598969.html

Date: 12/04/07 (PHP Community)    Keywords: php, mysql, sql, security

I've been trying to understand, SQL Injection ... and reading this.
http://www.phpbuilder.com/columns/ProPHPSecurity_excerpt_part3.php3

      $sql = "INSERT INTO table
      (unit1, unit2, unit3, unit4)
        VALUES
      (\"$value1\", \"$value2\", \"$value3\", \"$value4\")
		";
        mysql_query($sql,$conn) or die(" Error 1: ".mysql_error());	

Source: http://community.livejournal.com/php/601327.html

Date: 12/11/07 (Java Web)    Keywords: php, mysql, sql, linux

We are looking for a full-time Linux system administrator to manage our dedicated servers and our internal servers, computers and network. He will also have to manage the MySQL server and other servers in-house. He / She will be trained as necessary. Experience in scripting (perl / php) is a plus. He should be a [...]

Source: http://blog.taragana.com/index.php/archive/linux-administrator-required/

Date: 12/12/07 (PHP Community)    Keywords: php, mysql, sql

I want to make a site with adobe flex 2 as the GUI and then have php and mysql for the server side of things. I have been converting lots of my code over to take more advantage of OOP and am really liking the new feel of it all. Now my question is this, when actionscript/flex sends info to php, what is the best way to capture it?

There are several ways I can think to set this up. I have several small files like login.php and getUser.php or even saveUser.php. ie, basically a php file for most of the commands I want to be able to deal with, but it seems like alot of files and kind of a waste of time. But then I could have one php file and pass in a mode variable which would allow that one .php file to have multiple funcitons. In the end, I do want all of the data verification to be done on the server side and the interface to do very little other than display the data. I want to be able to swap out the front end without having to redo the back end.

This is my first time trying a N-Tier setup and just want to bypass any long and painful learning curves. Thanks.

Source: http://community.livejournal.com/php/603263.html

Date: 12/12/07 (MySQL Communtiy)    Keywords: mysql, sql, linux

[cross posted to linux]
  I keep getting the MySQL AB emails about training coming to my town, but never go.  I'd like to formalize my knowledge with the MySQL but at the sametime I've got a pretty bad impression of almost all certification and training courses, and the one provided by AB seems like a top gun program ( 5 days to learn how to be a Admin) which makes me wonder if it will be effective.   Anyone here actually ever taken one of their courses?

Source: http://community.livejournal.com/mysql/122231.html

Date: 12/15/07 (Web Development)    Keywords: php, mysql, sql, web, spam

I'm not really proficient in using mysql/php, and in my website I noticed that either people/spambots are inputing suspicious words into my mysql parameter things (not sure what to call them).

For example, I use mysite.com/avatars.php?series=seriesName to sort my avatars. But I see people entering urls of a completely different website after the equal sign. The URLs are really weird ones, so I think they're either porn websites or some other unsavory site. I'm not about to visit them and find out.

When I try entering a random thing after the equal sign, or a website url after the equal sing, nothing seems to happen. Except it returns an empty page. So is this something I should worry about?

Source: http://community.livejournal.com/webdev/453045.html

Date: 12/15/07 (PHP Community)    Keywords: php, mysql, xml, database, sql

Okay, so while I'm relatively good with PHP, I'm not so good with PHP 4's XML handling, and I'm having some problems creating an XML parser that will read tag attributes (which I'm then putting into a MySQL database).

I've tried a half-dozen different examples of parsers that others have done, and none seem able to pull the attributes out. I have no say in how it's structured, so I have to find a way to deal with it as is. My XML looks something like this:

Source: http://community.livejournal.com/php/603991.html

Date: 12/15/07 (WebDesign)    Keywords: mysql, sql, web

I am currently with Powweb. Are any of you really happy with your webhost? Why do you like them so much? I am disliking Powweb at this point because they have a MySQL problem that has been going on for over 3 months and they seem either incapable or unwilling to fix it. The result is that they have speed problems on their sites that utilize MySQL and it's a big issue. I'm talking 1 to 3 minute loading times. So I'm about to take a loss on the money I just paid them last month for a year of service and go elsewhere.

I had been dealing with them since they were a small company (since about 2000) and they were great then, but since they've been taken over by Endurance, they are horrid. I was unaware because I spent a couple of years just maintaining the account and not putting a site up and now that I'm trying to put a site up, I encounter the nightmare that they have become.

I had heard good things about siteground.com, but after doing some research, they seem really limited and quick to shut you down so I don't want to trade one migraine for another. bluehost.com also seems to have a good reputation. Does anyone have an opinion?
Here are some opinions on Powweb at epinions.
Share your good experiences! Also, if you've got a bad situation that you'd like to get off your chest, share that as well.

Source: http://community.livejournal.com/webdesign/1341954.html

Date: 12/20/07 (PHP Community)    Keywords: php, mysql, sql, apache

Hey guys, not sure if this is entirely the right place, but I'm having issues compiling PHP. I downloaded the 5.2.5 source tarball to my CentOS box this morning, compiled with gcc using:

./configure \
--with-apxs=/usr/local/apache/bin/apxs \
--with-libdir=lib64 \
--prefix=/usr/local/custom \
--enable-bcmath \
--enable-calendar \
--enable-ftp \
--with-gd \
--with-jpeg-dir=/usr/local \
--with-png-dir=/usr \
--with-xpm-dir=/usr/X11R6 \
--enable-magic-quotes \
--with-mysqli \
--with-mysql=/usr \
--enable-discard-path \
--with-pear \
--enable-sockets \
--enable-zip \
--with-zlib \
--enable-soap

=====================================================================
FAILED TEST SUMMARY
---------------------------------------------------------------------
Bug #16069 (ICONV transliteration failure) [ext/iconv/tests/bug16069.phpt]
iconv stream filter [ext/iconv/tests/iconv_stream_filter.phpt]
Bug #41567 (json_encode() double conversion is inconsistent with PHP) [ext/json/tests/bug41567.phpt]
=====================================================================

=====================================================================
FAILED TEST SUMMARY
---------------------------------------------------------------------
Bug #16069 (ICONV transliteration failure) [ext/iconv/tests/bug16069.phpt]
iconv stream filter [ext/iconv/tests/iconv_stream_filter.phpt]
Bug #41567 (json_encode() double conversion is inconsistent with PHP) [ext/json/tests/bug41567.phpt]
Bug #31422 (No Error-Logging on SoapServer-Side) [ext/soap/tests/bugs/bug31422.phpt]
IPv6 Loopback test [ext/sockets/tests/ipv6loop.phpt]
Test array_reverse() function : usage variations - assoc. array with diff. value for 'array' argument [ext/standard/tests/array/array_reverse_variation5.phpt]
Test array_unshift() function : usage variations - assoc. array with diff values for 'array' argument [ext/standard/tests/array/array_unshift_variation5.phpt]
Test vsprintf() function : usage variations - string formats with non-string values [ext/standard/tests/strings/vsprintf_variation8.phpt]
=====================================================================

Source: http://community.livejournal.com/php/604903.html

Date: 12/22/07 (PHP Community)    Keywords: php, programming, mysql, software, database, sql, postgresql, web, hosting

Hello Friends

I am interested in exploring web programming via Lisp, Ruby on Rails, and several of the popular Python frameworks.

Here are the features I am interested in:

* Lisp hosting including access to web servers and/or mod_lisp
* Ruby on Rails hosting
* Python hosting
* Configurable source control repository with public and private areas (SVN/Trac or better)
* SSH access
* MySQL or PostgreSQL database
* PHP support (for third-party software packages)

Has anyone here had similar needs? Would you recommend any particular hosting solution?

Thanks,
jkndrkn

Source: http://community.livejournal.com/php/605765.html

Date: 12/26/07 (Web Development)    Keywords: php, mysql, sql, web

I'm new to the community! Nice to meet you.

I want to create an index page on my domain that has a box that requires a login and password before allowing users to see any other pages. I can password protect directories on my domain's cpanel, but when I use that a grey box pops up asking for the username and password over and over again. I'd like users of my website to only have to login once. I've found a few free scripts that almost do what I am wanting but most of them are community oriented with member profile pages. It looks like the easiest way to do what I am wanting to do it by using php and mysql. I've found a few tutorials but I can never seem to get them to work for me. I'm relatively new to sql and php so I'm trying to be patient with myself but I am getting frustrated. Any suggestions? Thank you

edit: here are some links

the tutorial I am using

where I am trying to implement this

Source: http://community.livejournal.com/webdev/454708.html

Date: 12/28/07 (PHP Community)    Keywords: php, mysql, sql

hello everyone. after a couple of training classes, i felt i was ready to repair my first php/mysql site. anyway, when i downloaded the site to my machine for testing. these little things started causing problems on my testing server:

require_once ($_SERVER['DOCUMENT_ROOT'].'/Connections/foo_db.php');

the $_SERVER['DOCUMENT_ROOT'] on the site, of course, takes you back to the root of the whole server and then gets the file from the folder you requested. on my testing server it goes all the way back to the C drive, i.e., it won't find: C:/wamp/www/Connections/foo_db.php because it's going too far back. is there any way to set up my testing server so it assumes a certain folder is the root? i don't feel like going through and changing all the requires and includes. thanks.

x posted in php_mysql

Source: http://community.livejournal.com/php/606507.html

Date: 01/06/08 (PHP Community)    Keywords: php, mysql, sql

Hi,

I'm not very experienced with PHP/MYSQL, so I'll try and keep this as simple as possible. :P


I have dates stored in MySQL as DATETIME.

In my script, I'm trying to get it to display all the results for week #. Week # being 1-52. (I know in PHP it's displayed with "W")

... I have no idea how to do this. :| That is, extract the "W" from the DATETIME.

I'm guessing I might have to strtotime() it and then date() but then that confuses me because I'd have to be doing it in the calling query itself?

Eep. Help much appreciated. :)

Source: http://community.livejournal.com/php/608664.html

Date: 01/08/08 (WebDesign)    Keywords: php, mysql, sql, web, hosting

Powweb gave me my money back. I guess I was no longer worth the trouble. Bless them :o).

I had given up on getting my money back. I was searching for class action lawsuits online to participate in and I posted bad reviews about them every time I came across a legitimate review site. I was always in good company with the exception of epinions where I was the first one to post an entry about them. No, I was not obsessed with them, but every day they did something that further aggravated and inconvenienced me. As you all know, I had decided to just keep the account because it was paid for and I didn't believe I'd get my money back anyway. No way they get to keep my money AND shut me down!

They also had a pending charge on my account for November of 2008 when the account would have expired, an auto renewal. I asked them to remove that charge from my account because there was no way I was going to renew anything with them. I made the request twice with no response. On the 3rd request, they closed the account with no warning and no notice. I simply went to sign into the account and got an error. So then I spent over an hour on chat where I told them that I had paid for the account and I wanted it on even though at this point, I was pointing my domain to my new webhost anyway and was in the process of transferring the domain. They said that I had requested that the account be closed it could not be reversed but I could sign up for a new account. I told them that I had not made that request and I explained that I had requested that the auto renewal be turned off. The account didn't expire until 11/08. It was like talking to a robot. She kept repeating the same thing. It was 90 minutes that I was on with her until I just finally got so sick of her that I just disconnected the chat and decided to release this struggle. It wasn't even worth the money. I realised at that point, that I just needed to let it go.

Please be clear that at this point, I am with another company. Unfortunately, Powweb still has their talons in my domain names. My new webhost has been trying to transfer the domain for about 2 weeks now and has been unsuccessful. The new host is telling me the process is taking a while because Powweb won't release their hold on my account. Powweb says this isn't the case. Even though checking with an independent source, I can see that Powweb really doesn't have my domain locked, for whatever reason the new host has been unable to complete the transfer. I don't know what's going on, but it's taking a while and I want my domain names completely moved because I really believe that Powweb is a sinking ship and they will be gone soon and when it's time to renew my domains, I don't want any problems. So I'm paying the cost to get my domains transferred to a different reseller. The whole thing has been a pain in the ass.

I really appreciate that Powweb returned my money, but make no mistake about it, until they fix the MySQL issue, they will still remain a 0 in a rating of 1 to 10 with 1 being the lowest. Also, what I had to go through to get them to give me my money back is an outrage and at the least, I'd say I earned about $5 per hour of my total refund just in the time I spent first of all, trying to resolve this problem that they were never going to resolve for me and then the actual process of trying to get my money back. So they get no cookies, but I do like having my money back. It puts a period on the situation.


P.S. This guy sums up the issues with Powweb much better than I did.
http://www.webhostingtalk.com/showthread.php?p=4893525&highlight=powweb#post4893525

Source: http://community.livejournal.com/webdesign/1350017.html

Date: 01/10/08 (WebDesign)    Keywords: php, mysql, sql, spam

I'm curious what people here see as the current best practice for email forms.

Lately it seems that the standard Form2Mail cgi (Matt's scripts) that I've had in place for years, has started generating a lot of empty messages, or messages from "nobody@isp.com"... i'm interpreting this to mean that they are getting more attempted attacks from spammers. Or they stop working periodically (!)

What is the current preferred method of sending secure email from a form, without the mailto address being visible to spambots? I've seen more php out there these days- But it's hard to decide at face value if any of the purported free php things out there are any good.

At one bulk host, i tried the wizard to set up a php-MySQL "php form generator" (phpformgen.sourceforge.net) but that proved really difficult to set up and i never did get it working.

Suggestions? I'm looking for free, or cheap license for a bunch of different sites.

Source: http://community.livejournal.com/webdesign/1352817.html

Date: 01/10/08 (MySQL Communtiy)    Keywords: mysql, database, sql

What kind of Collation setting should I use for my Comments section in my MySQL database?

It defaulted to:  latin1_swedish_ci

is this right?

Signed:  Frustrated

-------------
Update
------------

It IS right...and indeed I am a lummox!

-------------
/Update
------------

Source: http://community.livejournal.com/mysql/122656.html

Date: 01/11/08 (Open Source)    Keywords: mysql, sql

By using mySQL to do it, and buying mySQL support contracts, Virgin Mobile is calling mySQL enterprise-ready.

Source: http://feeds.feedburner.com/~r/zdnet/open-source/~3/215028762/

Date: 01/11/08 (Data Management)    Keywords: mysql, database, sql

Virgin Mobile's decision to base its SMS database on mySQL is an important milestone for the GPL database. This was not Virgin's first entry into open source. Virgin Mobile also runs Red Hat. Virgin Mobile is a scaled enterprise. Even though SMS messages are...

Source: http://blogs.zdnet.com/open-source/?p=1878

Date: 01/13/08 (Web Development)    Keywords: php, mysql, sql

I am currently with Startlogic and I've unfortunately learned the hardware that they aren't as good as they once were or people said they are. As of October 16, Startlogic started 'migrating' users to a new platform. My migration date has come and gone. I am still not able to manually migrate my site to the new platform either. Tech Support still hasn't gotten back to me.

I was wondering if there is anyone out there that could give me some recommendations.

I'm looking for a provider with these features:

• >50 GB Storage
• >1TB Bandwidth
• PHP 5
• AJAX
• MySQL 5
• FTP
• SSH
• Word Press
• Photo Gallery
• Multiple domains
• cPanel

Source: http://community.livejournal.com/webdev/458169.html

Date: 01/15/08 (MySQL Communtiy)    Keywords: mysql, sql

A table exists where the same id can be issued more than once. Each id has an accompanying color.

SQL to build table:

 CREATE TABLE `xorder` (
`id` INT( 3 ) NOT NULL ,
`color` VARCHAR( 20 ) NULL ,
) ENGINE = MYISAM 

 INSERT INTO `xorder` (
`id` ,
`color`
)
VALUES (
'1', 'green'
), (
'2', 'red'
), (
'3', 'black'
), (
'1', 'yellow'
), (
'2', 'blue'
), (
'1', 'orange'
), (
'2', 'white'
), (
'2', 'purple'
), (
'4', 'blue'
), (
'5', 'gray'
)

id	color
1	green
1	yellow
1	orange
2	red
2	blue
2	white
2	purple
3	black
4	blue
5	gray

Source: http://community.livejournal.com/mysql/122903.html