Date: 02/22/06 (PHP Community)    Keywords: php, mysql, rss, css, html, database, sql, java, web, linux, apache

I hope job postings are welcome here.

We are looking to hire a PHP/MySQL Applications Developer at our offices in Charlestown, MA (part of Boston). This is a full-time, on-site position. If you are interested in applying, please send your resume, links to successful projects, and a code sample (100 or more lines showing your coding abilities and standards) to mo at smarterliving dot com.


PHP/MySQL Applications Developer

We are looking for a smart, creative, motivated self-starter who wants to join a strong team of developers in a rapidly growing company, building some of the leading consumer websites in the travel industry.

The PHP/MySQL Applications Developer will be a part of our Applications Development team developing scalable, database-driven web applications for our production websites (www.smartertravel.com and www.bookingbuddy.com) in a LAMP (Linux, Apache, MySQL, PHP) environment.

We offer competitive salary & benefits and a great work environment in T-accessible office space with parking on the Charlestown/Somerville line.

Job Qualifications:

The ideal candidate has 2-5 years experience developing with PHP 4-5 in a professional team environment using Object-Oriented Design principles. A strong understanding of XHTML, CSS, MySQL and JavaScript is also required. Experience with AJAX, JSON, RSS or other emerging technologies is a plus.

The successful candidate will communicate well, be committed to delivering quality work on an aggressive schedule, and must be able to function independently as well as part of a team. Must document code faithfully and take good coding practices seriously.

To apply:

To apply please provide a resume and cover letter including links to successful projects and summarize your participation. A code sample sufficiently long to show coding style and design methodology is also required. In addition, please indicate the best time to contact you, between the hours of 9:00 a.m. and 6:30 p.m., Monday through Friday.

IMPORTANT: Any submission not including code samples and links to working online applications that the candidate has written will be ignored.

The location for this position is in Charlestown, MA. It is a full-time, on-site position.


X-posted.

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

Date: 02/22/06 (PHP Community)    Keywords: templates, mysql, database, sql

New additions to the languages, support and templates... and changes in the database, sessions and parser...

Changes:
Database:

• updated version

• added small-script codes for more language strings in site


• updated the german descriptions

• added small-script parser for the language strings

• added cookies to remember skin, language and login


• added failsafe sessions

• removed strings now in the small-script


• overviewed and cleared of errors

• normal site


• skin: HWCompany


• skin: Electric


• language: English


• language: Dutch


• language: German

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

Date: 02/22/06 (PHP Development)    Keywords: php, mysql, rss, css, html, database, sql, java, web, linux, apache

I hope job postings are welcome here.

We are looking to hire a PHP/MySQL Applications Developer at our offices in Charlestown, MA (part of Boston). This is a full-time, on-site position. If you are interested in applying, please send your resume, links to successful projects, and a code sample (100 or more lines showing your coding abilities and standards) to mo at smarterliving dot com.


PHP/MySQL Applications Developer

We are looking for a smart, creative, motivated self-starter who wants to join a strong team of developers in a rapidly growing company, building some of the leading consumer websites in the travel industry.

The PHP/MySQL Applications Developer will be a part of our Applications Development team developing scalable, database-driven web applications for our production websites (www.smartertravel.com and www.bookingbuddy.com) in a LAMP (Linux, Apache, MySQL, PHP) environment.

We offer competitive salary & benefits and a great work environment in T-accessible office space with parking on the Charlestown/Somerville line.

Job Qualifications:

The ideal candidate has 2-5 years experience developing with PHP 4-5 in a professional team environment using Object-Oriented Design principles. A strong understanding of XHTML, CSS, MySQL and JavaScript is also required. Experience with AJAX, JSON, RSS or other emerging technologies is a plus.

The successful candidate will communicate well, be committed to delivering quality work on an aggressive schedule, and must be able to function independently as well as part of a team. Must document code faithfully and take good coding practices seriously.

To apply:

To apply please provide a resume and cover letter including links to successful projects and summarize your participation. A code sample sufficiently long to show coding style and design methodology is also required. In addition, please indicate the best time to contact you, between the hours of 9:00 a.m. and 6:30 p.m., Monday through Friday.

IMPORTANT: Any submission not including code samples and links to working online applications that the candidate has written will be ignored.

The location for this position is in Charlestown, MA. It is a full-time, on-site position.


X-posted.

Source: http://community.livejournal.com/php_dev/66526.html

Date: 02/25/06 (MySQL Communtiy)    Keywords: mysql, sql

Server timezone is GMT-6.
What is the fast way to get GMT date using current_date() function or any other in request?
Server version is MySql 4.0 so ADDTIME(), CONVERT_TZ(), UTC_DATE(), DATEDIFF() and other cool MySql 4.1 functions does'nt work :(

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

Date: 02/26/06 (PHP Community)    Keywords: cms, php, mysql, database, sql, hosting

I programmed a CMS for one of my client and put it up on my own site in a test directory while it was in development. It was working just fine. They finally got their own hosting set up with Network Solutions so I uploaded all my files, set up the database and changed the username, password and db name in my scripts. Now I'm getting the following error: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock'

I've double checked that I have the right username and the right password.

I'm using the following code to connect: $link = mysql_connect('localhost', $user, $pass) or die("Could not connect : " . mysql_error());

When I log into phpMyAdmin I see the following: MySQL 4.1.16-log running on localhost as eclipse@localhost so I'm assuming that 'localhost' is right. What else could be wrong? I've tried emailing tech support at Network Solutions but I doubt anyone there will get back to me. It's a pretty basic error but i can't figure out what else I would've needed to change when switching the site from my server to theirs.

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

Date: 02/26/06 (MySQL Communtiy)    Keywords: cms, php, mysql, database, sql, hosting

I programmed a CMS for one of my client and put it up on my own site in a test directory while it was in development. It was working just fine. They finally got their own hosting set up with Network Solutions so I uploaded all my files, set up the database and changed the username, password and db name in my scripts. Now I'm getting the following error: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock'

I've double checked that I have the right username and the right password.

I'm using the following code to connect: $link = mysql_connect('localhost', $user, $pass) or die("Could not connect : " . mysql_error());

When I log into phpMyAdmin I see the following: MySQL 4.1.16-log running on localhost as eclipse@localhost so I'm assuming that 'localhost' is right. What else could be wrong? I've tried emailing tech support at Network Solutions but I doubt anyone there will get back to me. It's a pretty basic error but i can't figure out what else I would've needed to change when switching the site from my server to theirs.

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

Date: 02/26/06 (IT Professionals)    Keywords: mysql, sql, linux

How can I limit the number of mysqld processes (threads)? Under Linux.

I have the following options in my.cnf:

set-variable = max_connections=3
set-variable = thread_concurrency=3

But I still have 11 child threads of mysqld-max. How can I limit this number?

Source: http://community.livejournal.com/itprofessionals/34451.html

Date: 03/01/06 (PHP Community)    Keywords: mysql, database, sql

Hey all,


I'm trying to build a form that submits its contents to a database, with the exception of two file fields that are supposed to be emailed to someone. I can get the form working fine as usual, but for whatever reason, the file emailing section is not working. It acts like the files don't exist. Any suggestions? Also, I can't upload these files to my server because my admins are nazis - is there any way I can store a word doc or pdf in a mySQL db?

<?php // Connect to Database include('functions/mail_attached.php'); //connect info omitted if ($_POST['submitted'] == "yes") { //are the files there? echo "Submission if works<br />"; //files are there, let's fix the HTML and newlines $newOffAdd = strip_tags($_POST['office_address']); // remove all HTML $newOffAdd = nl2br($newOffAdd); // make the line breaks in to br tags $newHomeAdd = strip_tags($_POST['home_address']); // remove all HTML $newHomeAdd = nl2br($newHomeAdd); // make the line breaks in to br tags $newPolBack = strip_tags($_POST['political_background']); // remove all HTML $newPolBack = nl2br($newPolBack); // make the line breaks in to br tags //prepare the data to be inserted $insert_string = "insert into fellowsapp (`fellowship_date`,`fellow_name`,`fellow_title`,`office_address`,`home_address`,`office_phone`,`home_phone`,`assistant_name`,`office_fax`,`home_fax`,`fellow_email`,`fellow_ssn`,`recommended_by`,`political_background`) VALUES(\"" . $HTTP_POST_VARS['fellow_date'] . "\",\"" . $HTTP_POST_VARS['fellow_name'] . "\",\"" . $HTTP_POST_VARS['fellow_title'] . "\",\"" . $newOffAdd . "\",\"" . $newHomeAdd . "\",\"" . $_POST['office_phone'] . "\",\"" . $_POST['home_phone'] . "\",\"" . $HTTP_POST_VARS['assistant_name'] . "\",\"" . $HTTP_POST_VARS['office_fax'] . "\",\"" . $HTTP_POST_VARS['home_fax'] . "\",\"" . $HTTP_POST_VARS['fellow_email'] . "\",\"" . $HTTP_POST_VARS['fellow_ssn'] . "\",\"" . $HTTP_POST_VARS['recommended_by'] . "\",\"" . $newPolBack . "\");"; //insert the data $result = mysql_query($insert_string); //mail $mail_to = "jessica_jacobs@ksg.harvard.edu"; $message = "Dear Eric, Here are the files that go with " . $_POST['fellow_name'] . "'s fellow application. Enjoy! Jess"; $result2 = mail_attached($mail_to,$webmaster_email,"Fellows Application Files",$message,$_FILES); //tell them they succeeded echo "<span class=\"message_text\"><b>Thank you for your submission! We'll be contacting you shortly.</b></span><br /><br >"; } else {} //tell them they don't have any files //echo "<span class=\"message_text\"><b>You must supply a bio and study group topic information.</b></span><br /><br />"; //} ?> AND MY INCLUDE IS BELOW: <? /* Shamelessly stolen from http://www.theukwebdesigncompany.com/articles/php-file-attachments.php, then adjusted to my needs, found not to work and modified using ideas from http://www.phpdiscuss.com/article.php?id=423&group=php.lang and elsewhere. $filenames is designed basically to just be $_FILES; otherwise, use an array of the form: $filenames = array( "key1" => array( "error" => "0", "tmp_name" => "full_path_to_file", "name" => "file_name", "size" => "size", "type" => "type")); */ function mail_attached($to, $from, $subject, $message, $filenames, $headers = '') { $unique_sep = md5(uniqid(time())); // Set up the top headers $headers .= "From: $from\n"; $headers .= "MIME-Version: 1.0\nContent-Type: multipart/mixed;boundary=\"$unique_sep\";\n"; $headers .= "charset=\"iso-8859-1\"\nContent-Transfer-Encoding:7bit\n\n"; $headers .= "If you are reading this, then your e-mail client does not support MIME.\n"; $headers .= "Sent with mail_attached() (c) 2002 John Coggeshall\n\n"; $headers .= "--$unique_sep\n"; // Include the text portion of the e-mail $headers .= "Content-Type: text/plain; charset=\"iso-8859-1\"\n"; $headers .= "Content-Transfer-Encoding: 7bit\n\n"; $headers .= $message . "\n\n"; // Now the attachment foreach($filenames as $val) { if($val['error'] != 4 && file_exists($val['tmp_name'])) { $headers .= "--$unique_sep\n"; $headers .= "Content-Type: {$val['type']}; name=\"{$val['name']}\"\n"; $headers .= "Content-Transfer-Encoding: base64\n"; $headers .= "Content-Disposition: attachment\n\n"; $linesz= $val['size']+1; $fp= fopen($val['tmp_name'], 'rb'); $headers .= chunk_split(base64_encode(fread($fp,$linesz))); } } $headers .= "--$unique_sep--\n"; if(!mail($to, $subject, $message, $headers)) return false; else return true; } /* End of mail_attached() function */ ?>

Thanks!

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

Date: 03/02/06 (Java Web)    Keywords: mysql, database, sql

Mambo / Joomla passwords cannot be recovered as they are set using a one-way hash function (MD5). However they can be reset to new values. The user information is stored in the MySQL database (obviously) in the mos_users (for MAMBO) or jos_users (for JOOMLA). The prefix (mos or jos) can be configured and may be named [...]

Source: http://blog.taragana.com/index.php/archive/mambo-joomla-password-how-to-reset-recover/

Date: 03/04/06 (MySQL Communtiy)    Keywords: mysql, sql

Does anybody know method to view all locks, hold by concrete thread?
"show engine innodb status" shows only "waiting for this lock"...
I need info such as "Last detected deadlock"(part "holds these locks:"), but for each current thread.
Can't find that neither standard man or "mysql internals"...

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

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

A friend of mine is writing a comic book and he wants to post it online and make it a subscription based thing where every month or so he adds new content.

I'm going to be using php/mysql to make this happen, but beyond that the details are knda fuzzy. I've got most of it mapped out, the place I am having problems is when subscriptions come into play (this is only because I have never taken on this kind of project before).

Any suggestions as to the tools I would need to create a subsciption based site? I'm also trying to keep this as inexpensive as possibe >< Chances are he'll be using paypal.

Anything to point me in the proper direction would be much appreciated!
Thanks!

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

Date: 03/09/06 (SQL Server)    Keywords: php, mysql, sql

Hi guys,

I'm wondering if it's possible to validate the output of an sql query?

I have the following query/code (using PHP5, and MSSQL):

		$sql = "SELECT TOP 100 PERCENT Mem_Number, Title_1, Name_1, Surname_1, Email, Date_Sent_Renewal, EmailList, Renewal_Date FROM BTCMembers WHERE (DATEDIFF(d, Renewal_Date, GETDATE()) > ".$cutoff.") AND (DATEDIFF(d, Renewal_Date, Date_Sent_Renewal) < 0) AND (Email <> '') AND (Date_Sent_Renewal <> '') AND (EmailList = 1) ORDER BY Mem_Number ASC";



		$result = odbc_exec($contact, $sql); // Run the query

php

sqlserver

mysql

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

Date: 03/09/06 (PHP Community)    Keywords: php, mysql, sql

Hi guys,

I'm wondering if it's possible to validate the output of an sql query?

I have the following query/code (using PHP5, and MSSQL):

		$sql = "SELECT TOP 100 PERCENT Mem_Number, Title_1, Name_1, Surname_1, Email, Date_Sent_Renewal, EmailList, Renewal_Date FROM BTCMembers WHERE (DATEDIFF(d, Renewal_Date, GETDATE()) > ".$cutoff.") AND (DATEDIFF(d, Renewal_Date, Date_Sent_Renewal) < 0) AND (Email <> '') AND (Date_Sent_Renewal <> '') AND (EmailList = 1) ORDER BY Mem_Number ASC";

$result = odbc_exec($contact, $sql); // Run the query

php

sqlserver

mysql

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

Date: 03/09/06 (MySQL Communtiy)    Keywords: php, mysql, sql

Hi guys,

I'm wondering if it's possible to validate the output of an sql query?

I have the following query/code (using PHP5, and MSSQL):

		$sql = "SELECT TOP 100 PERCENT Mem_Number, Title_1, Name_1, Surname_1, Email, Date_Sent_Renewal, EmailList, Renewal_Date FROM BTCMembers WHERE (DATEDIFF(d, Renewal_Date, GETDATE()) > ".$cutoff.") AND (DATEDIFF(d, Renewal_Date, Date_Sent_Renewal) < 0) AND (Email <> '') AND (Date_Sent_Renewal <> '') AND (EmailList = 1) ORDER BY Mem_Number ASC";



		$result = odbc_exec($contact, $sql); // Run the query

php

sqlserver

mysql

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

Date: 03/09/06 (Java Web)    Keywords: mysql, database, sql

The MySQL database supporting this blog was consuming massive amount of CPU, which effectively lead to site going down 3-4 times this week. I knew an obvious culprit. However reality differed. I knew for sometime I had a jumbo query, which was not cached, and is likely to contribute to MySQL server load: [...]

Source: http://blog.taragana.com/index.php/archive/mysql-performance-optimization-a-lesson/

Date: 03/10/06 (Web Development)    Keywords: php, mysql, asp, sql, web, microsoft

Wow, there are 776 members in this community. I thought we could introduce ourselves. What work you currently do, levels of experience, and what your career plan for the future is. I'm just curious about all my fellow web developers. ;)

Me: I'm a PHP/MySQL web developer in Seattle, working at a design firm that specializes in corporate identity (logos/brochures/websites/etc). I have two years of "professional" work experience, though I've been coding and building websites since I was a kid. I taught myself everything through personal side projects. I'm looking at getting into C#/ASP/.NET and trying for some Microsoft certification (MCAD/MCSD.NET?) since web applications seem to be the growing thing, and was wondering if anyone else is along the same path, or has any advice.

Okay, your turn, share, share, share! =)

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

Date: 03/12/06 (PHP Community)    Keywords: mysql, database, sql

Hi,

I'm sure there's a better way than the one I'm using to do what I want to do.
I'm trying to select items from a database and order them by "category", which is one of the columns of the table I use.
Then, I want the page to display the items with the category as a title, appearing only once.
Hopefully someone can help me improve my code :)


Here's what the table looks like :
____________________________
| category | year | title | stuff |
------------------------------------------
| theatre | year1 | title1| ... |
-----------------------------------------
| movie | year2 | title2 | ... |


Here's what I want :

$categorie = mysql_query("SELECT categorie FROM $nom",$connexion) or die(mysql_error());
$nb = mysql_num_rows($categorie);
for ($i = 0; $i<$nb; $i++) {
	$perf = mysql_result($categorie,$i);
	$item[] = $perf;
}
$reduc = array_unique($item); 
	foreach($reduc as $genre) {
		echo "
";
		echo "\n
$genre
";
		echo "\n";
			$liste = mysql_query("SELECT * FROM $nom WHERE categorie LIKE '" . $genre . "' ORDER BY annee DESC",$connexion);
			while ($row = mysql_fetch_assoc($liste)) {
				$annee = $row['annee'];
				$titre = $row['titre'];
				$complement = $row['complement'];
				echo "\n ";
				}
				echo "\n
$annee
$titre
$complement
";
				echo "
";
			}

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

Date: 03/16/06 (Apache)    Keywords: php, mysql, browser, sql, web, apache

Hello All

I'm sorry if this is a painfully stupid question, but I've tried looking everywhere on the interweb for an answer, but to no avail.

I'm running apache 1.3 in XP at the moment, and am using it as a development server, as I'm currently trying to make and test a little pet project of mine using php and mysql. When I try to connect to the server through a browser (by typing "http:/ /localhost"), it loads the index page fine, but if I try any of the links off of that page, IE insists I connect to the internet, despite the fact they are locally hosted, and are in the htdocs folder. I'm certain the server is running, it just won't let ne access them through a browser. I'm pretty sure It's something blatently obvious, so any help would be greatly appreciated.

Thankyou greatly

Sam

Source: http://community.livejournal.com/apache/31079.html

Date: 03/17/06 (PHP Community)    Keywords: mysql, browser, sql

I've writen a function


auto_populate($file_name)
{
    $file=file($file_name);
    foreach($file as $sql)
    {
       mysql_query($sql);
       echo $sql."< br >"; // To test the file is being processed
    }
}

if I call it with a filename (eg. auto_populate("test.txt");) I see the lines in the browser but the db still remains empty.

each line is in the format

insert into 'area' values(0, 'Yorkshire')

am I missing something?

Tia

Pual

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

Date: 03/23/06 (PHP Community)    Keywords: mysql, sql

Need some help with this - I made an external table for the categories in my blog, and now I want to join the blog and the blog_cat table, so it selects the name from the cat table where the category equals the catID. *Something* works already, but it just keeps selecting only one category one, instead of the equal one it should be selecting. I'm pretty much a noob =_=


$sql = "SELECT * FROM $tableblog ORDER BY timestamp DESC LIMIT 5";
$result = mysql_query($sql) or
print ("Unable to select data.
" . $sql . "
" . mysql_error());
while ($row = mysql_fetch_array($result))
{
$date = date("l, F dS, Y - h:ia",$row["timestamp"]);
$category = $row["category"];
$entry = $row["entry"];
$id = $row["id"];
// ....

$result3 = mysql_query("SELECT category, catID, catname FROM $tableblog, $tableblogcat WHERE category=catID") or
print ("Unable to select data.
" . $sql . "
" . mysql_error());
while ($row = mysql_fetch_array($result3))
{
$catID = $row["catID"];
$catname = $row["catname"];
}

print "<.a href=\"categories.php?c=$category\">$catname";
}

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