Date: 11/20/07 (PHP Community)    Keywords: php, mysql, database, sql, web

Regards,

This is situation, i have a task on my work to update group of ours sites with using of web2.0 technologies

Engine writed on php5.2 & mysql5

It's simple MVC engine, that i have used over a one year in my projects.
So, now i need to rewrite it and i must do it in any cases.

I thin, somebody may interesting on it to have community project?

I need some help with ajax and sql databases designing.
U can help me with translation if u want - u see - my english is wery bad ;) (i'm from russia)

with any questions please contacts me with my icq 480.814.094
thanks

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

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

I have PHP5.2 running under Apache 2.2 on Windows XP, and followed all directions to enable the mySQL library for PHP, but it's not working. Here's what I did:

Uncommented the extension lines for php_mysql.dll in c:php\php.ini
Enabled c:\php into the Windows PATH variable
Copied the mysql library DLL to windows/system32


Here is my phpMyAdmin config against this (Apache's port is 8080, also):

$cfg['Servers'][$i]['host'] = '127.0.0.1:8080';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'xxxxxx';


Any other pointers would be greatly appreciated.

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

Date: 11/23/07 (Java Web)    Keywords: mysql, sql

In MySQL you can use the GRANT statement to create users and assign privileges to them at the same time. It is extremely convenient and beats create user or directly hacking the mysql.user table. I learned few things about GRANT the hard way. MySQL allows you to create users associated with a particular host name [...]

Source: http://blog.taragana.com/index.php/archive/mysql-creating-users-granting-access-simplified/

Date: 11/27/07 (Java Web)    Keywords: mysql, database, sql

To delete duplicates from a MySQL database table I normally copy the duplicate data first to a temporary table and then use the copied id’s to delete from the original table. Delete using the temporary can take two forms. First is the slow way: delete from target where id in (select id from temp); This can be [...]

Source: http://blog.taragana.com/index.php/archive/mysql-sql-delete-notes/

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: 11/28/07 (SQL Server)    Keywords: sql, microsoft

Anyone ever work with Microsoft's Live Communication Server (LCS) from the SQL side?  I'm interested in the scalability of it and I'm having trouble digging up very much information from the vendor... 

Source: http://community.livejournal.com/sqlserver/64773.html

Date: 12/03/07 (SQL Server)    Keywords: database, sql

I'd like input on what is considered SQL Server developer tasks vs. SQL Server DBA tasks. I know there's a lot of overlap and would like to identify which task truly falls into which bucket and which tasks truly apply to both.



I'm a bit "stuck between a rock and a hard place," SQL Server-wise. I've done a lot of database design, creation, administering, writing complex ANSI SQL and T-SQL and the like in Access since 1994 (when you didn't get fluffy cute wizards to help you and had to learn to program and normalize data and plan db's the hard way!) :-p

I now have a little over 3 yrs experience in SQL Server (v.2000 and 2005). Unfortunately, both places where I did SQL work did not allow for me to get into the fun developer tasks (barely had the chance to work with or edit stored procedures or do any real performance tuning or query optimization).

I did get to do a lot of complex T-SQL coding, including detailed CASE statements. I did various tasks that fall under ETL (importing flat files, spreadsheets, cleaning the data, pulling random samples) as well as Decision Support (pulling a variety of counts and other aggregate data post-project for the Project Managers and Exec. Mgmt).

My goal is to get the new 2005 version of the MCDBA certification and be a 2005 SQL Developer. It's a bit hard to get in anywhere except as a SQL Server Analyst at the moment. Any advice in that area would be appreciated.

Source: http://community.livejournal.com/sqlserver/65221.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/07/07 (Web Development)    Keywords: database, sql

How do I get a datareader to compare a number entered in a text box with the information in a database? I have the datareader connected, but I think the problem may lie in my SQL statement: here's the whole code:

Source: http://community.livejournal.com/webdev/451053.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/17/07 (PHP Community)    Keywords: database, sql, web

I have 15 random paragraphs of text, each a couple sentences long, nothing major. I want to display a random one on the main page of a website every time the page loads. I am not terribly concerned with the flexibility or expandability of this script, I just don't want it to slow anything else down... I once took down a sql server because I had way too many queries on a web page, and since then I've been a little paranoid about using tons of database-driven stuff. Then again if I just hard-code all the text into the script, my 500 byte script or whatever will be 10x the size it once was, since it'll have to load all the text.

Source: http://community.livejournal.com/php/604385.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