Date: 07/08/05 (MySQL Communtiy)    Keywords: php

hey guys, this is my first post in here - i'm also a member of php and flashdev

this seems simple, but i hope i don't bungle it up - i don't have a concrete example for this, just something i've been thinking about

let's say i have 2 tables, categories and items and there exists items.categoryID and category.ID;

is there an easy way to select only the categories that have associated items?


for instance:

if i have:
categories
----------
1. Category A
2. Category B
3. Category C
4. Category D
(1, 2, 3 and 4 being categories.id)

and

items
-----
1. Item A (items.categoryID = 1)
2. Item B (items.categoryID = 4)


can I, with just 1 select query, pull ONLY Category A (id = 1) and Category D (id = 4) to say, build a menu of categories, selecting only those categories that are "populated"?

in the past, how i've done this has been select ALL categories, then one at a time loop through the categories and do a SELECT statement for each ID and check for at least 1 result; then flag each category that has associated "stuff"; this is allright if the page you're building has to list all the products AND categories, but let's say I just want to build a menu of only available categories and not display any items (or not ALL the items) on a given page

any help is appreciated; let me know if that makes any sense...

Source: http://www.livejournal.com/community/mysql/61688.html

Date: 07/09/05 (WebDesign)    Keywords: php, programming, css, html, web, hosting

hello. i'm new here. kind of new with webdesign as well (been doing it for almost a year just as a hobby; mostly with css and html).

1. i'm just curious as to how many of you actually have made webdesign/programming your career, and if so, what route did you take in college (certificate, associates, bachelors, etc). i'm a second year community college student, and i'm interested in persuing webdesign as a career, technical side and design side, so i guess im just confused as to what i should do in school to get where i'm wanting to be (job as a webdesigner for a company). any tips, suggestions?

2.also, i'm sure this has been asked a million times before, but in the userinfo, " Affordable & Reliable Webhosts" was left blank. so i'm going to ask you guys for some reccomendations on hosts. ive done godaddy, and 1and1.com before.. and neither have what i want for a low enough price. i'm looking for something that will allow me to have multiple ftp accounts, php, a decent amount of bandwidth, multiple domain hosting, etc. any suggestions?

3. last but not least, i'm looking into using moveable type as a blog for my website. i would like to achieve something like this. does anyone have any experience with this? is it fairly easy? is there something better i should be using. as you can tell, i'm kind of a beginner, and i would love if you would point me in the right direction if i'm missing out on something better.

any help would be awesome. thanks!

Source: http://www.livejournal.com/community/webdesign/924848.html

Date: 07/08/05 (WebDesign)    Keywords: php, mysql, html, asp, sql

Hope this isn't a bother.

I'm trying to find a random quote generator that uses HTML or PHP. If it's possible to do it without MySQL, ASP, etc etc etc. Anybody? Beuller?

Rock on. <3 

Source: http://www.livejournal.com/community/webdesign/924390.html

Date: 07/09/05 (PHP Community)    Keywords: php

I know that some things are faster in PHP then others, like echo and print for example off my head. As every like is like that of course. Though there is also bit functionality different from them too but, factor of common use of them is the same. Anyhow, if's are pretty much based on freedom choice, meaning there is so much you can do with them and I want to know which is most fastest by server.

1.
if(statement)
{
   code;
}
else
{
   code;
}

2.
if(statement) code;
else code;

3.
if(statement):
   code;
else:
   code;
endif;

4.
(statement) ? code : code;

Source: http://www.livejournal.com/community/php/316577.html

Date: 07/09/05 (Computer Help)    Keywords: php, software, java, virus, antivirus, web, yahoo, microsoft

I finally got around to re-installing Norton Anti-Virus, after over a year without it. Of course, it was too late. I did a scan, and a lot of viruses weren't able to be deleted. Also, I keep getting a virus alert for W32.Desktophijack and Trojan.Desktophijack.B it says Unable to repair this file and Access to the file was denied. So how do I go about getting rid of those? And also, here's a list of the things that failed to delete from the scan:
-1.exe
msbb321.dll
msiaih.dll
msnimk.gif
P2P-p2p-10460.exe
quykw.dat
redit.cpl
supdate.dll
tool4_b2seach.exe

And just incase...

Logfile of HijackThis v1.99.1
Scan saved at 2:00:42 PM, on 7/9/2005
Platform: Windows XP (WinNT 5.01.2600)
MSIE: Internet Explorer v6.00 (6.00.2600.0000)

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\Explorer.EXE
C:\Program Files\Common Files\Symantec Shared\ccSetMgr.exe
C:\Program Files\iTunes\iTunesHelper.exe
C:\WINDOWS\System32\rzapuv.exe
C:\Program Files\Java\jre1.5.0_02\bin\jusched.exe
C:\Program Files\Common Files\Symantec Shared\ccApp.exe
C:\WINDOWS\System32\olepro32.exe
C:\Program Files\MSN Messenger\msnmsgr.exe
C:\Program Files\Logitech\MouseWare\system\em_exec.exe
C:\Program Files\Common Files\Symantec Shared\ccEvtMgr.exe
C:\Program Files\ArcSoft\Media Card Companion\MCC Monitor.exe
C:\Program Files\AIM\aim.exe
C:\WINDOWS\system32\LEXBCES.EXE
C:\WINDOWS\system32\spoolsv.exe
C:\WINDOWS\system32\LEXPPS.EXE
C:\Program Files\Norton AntiVirus\navapsvc.exe
C:\Program Files\AIM\aim.exe
C:\WINDOWS\System32\svchost.exe
C:\Program Files\Common Files\Symantec Shared\CCPD-LC\symlcsvc.exe
C:\Program Files\iPod\bin\iPodService.exe
C:\unzipped\hijackthis\HijackThis.exe
C:\Program Files\Internet Explorer\iexplore.exe
C:\Program Files\Messenger\msmsgs.exe

R1 - HKCU\Software\Microsoft\Internet Explorer,SearchURL = http://searchmiracle.com/sp.php
R0 - HKCU\Software\Microsoft\Internet Explorer\Main,Start Page = http://www.yahoo.com/
R1 - HKLM\Software\Microsoft\Internet Explorer\Main,Default_Page_URL = http://www.e4me.com
R0 - HKCU\Software\Microsoft\Internet Explorer\Toolbar,LinksFolderName =
O2 - BHO: NAV Helper - {BDF3E430-B101-42AD-A544-FADC6B084872} - C:\Program Files\Norton AntiVirus\NavShExt.dll
O3 - Toolbar: Norton AntiVirus - {42CDD1BF-3FFB-4238-8AD1-7859DF00B1D6} - C:\Program Files\Norton AntiVirus\NavShExt.dll
O4 - HKLM\..\Run: [StartAOL] "C:\Program Files\America Online 6.0\AOL.EXE"
O4 - HKLM\..\Run: [Logitech Utility] Logi_MwX.Exe
O4 - HKLM\..\Run: [C2K] C:\WINDOWS\Cyb2k.exe
O4 - HKLM\..\Run: [hscraps] C:\WINDOWS\System32\hscraps.exe
O4 - HKLM\..\Run: [netppi] C:\WINDOWS\System32\netppi.exe
O4 - HKLM\..\Run: [iTunesHelper] C:\Program Files\iTunes\iTunesHelper.exe
O4 - HKLM\..\Run: [QuickTime Task] "C:\Program Files\QuickTime\qttask.exe" -atboottime
O4 - HKLM\..\Run: [DeadAIM] rundll32.exe "C:\PROGRA~1\AIM\\DeadAIM.ocm",ExportedCheckODLs
O4 - HKLM\..\Run: [2YfUx5R] C:\windows\2YfUx5R.exe
O4 - HKLM\..\Run: [regsync] C:\WINDOWS\System32\regsync.exe
O4 - HKLM\..\Run: [C:\WINDOWS\VCMnet11.exe] C:\WINDOWS\VCMnet11.exe
O4 - HKLM\..\Run: [PSof1] C:\WINDOWS\System32\PSof1.exe
O4 - HKLM\..\Run: [us4O3mg] ksupxl32.exe
O4 - HKLM\..\Run: [checkrun] C:\windows\system32\eliteoke32.exe
O4 - HKLM\..\Run: [KavSvc] C:\WINDOWS\System32\rzapuv.exe reg_run
O4 - HKLM\..\Run: [Media Access] C:\Program Files\Media Access\MediaAccK.exe
O4 - HKLM\..\Run: [laltin] C:\WINDOWS\System32\L90112201.Stub.exe
O4 - HKLM\..\Run: [vidctrl] C:\WINDOWS\System32\vidctrl\vidctrl.exe
O4 - HKLM\..\Run: [PSGuard] C:\Program Files\PSGuard\PSGuard.exe
O4 - HKLM\..\Run: [SunJavaUpdateSched] C:\Program Files\Java\jre1.5.0_02\bin\jusched.exe
O4 - HKLM\..\Run: [ccApp] "C:\Program Files\Common Files\Symantec Shared\ccApp.exe"
O4 - HKLM\..\Run: [NAV CfgWiz] C:\Program Files\Common Files\Symantec Shared\CfgWiz.exe /GUID NAV /CMDLINE "REBOOT"
O4 - HKLM\..\Run: [Symantec NetDriver Monitor] C:\PROGRA~1\SYMNET~1\SNDMon.exe
O4 - HKLM\..\RunServices: [SchedulingAgent] mstask.exe
O4 - HKCU\..\Run: [MoneyAgent] "C:\Program Files\Microsoft Money\System\Money Express.exe"
O4 - HKCU\..\Run: [olepro32] C:\WINDOWS\System32\olepro32.exe
O4 - HKCU\..\Run: [msnmsgr] "C:\Program Files\MSN Messenger\msnmsgr.exe" /background
O4 - HKCU\..\Run: [Yahoo! Pager] C:\Program Files\Yahoo!\Messenger\ypager.exe -quiet
O4 - HKCU\..\Run: [fBvERgMFg] kdcepl40.exe
O4 - HKCU\..\Run: [180ClientStubInstall] "C:\temp\stubinstaller6480.exe"
O4 - Global Startup: Media Card Companion Monitor.lnk = C:\Program Files\ArcSoft\Media Card Companion\MCC Monitor.exe
O4 - Global Startup: Microsoft Office.lnk = C:\Program Files\Microsoft Office\Office10\OSA.EXE
O8 - Extra context menu item: E&xport to Microsoft Excel - res://C:\PROGRA~1\MICROS~3\Office10\EXCEL.EXE/3000
O9 - Extra button: (no name) - {08B0E5C0-4FCB-11CF-AAA5-00401C608501} - C:\Program Files\Java\jre1.5.0_02\bin\npjpi150_02.dll
O9 - Extra 'Tools' menuitem: Sun Java Console - {08B0E5C0-4FCB-11CF-AAA5-00401C608501} - C:\Program Files\Java\jre1.5.0_02\bin\npjpi150_02.dll
O9 - Extra button: AIM - {AC9E2541-2814-11d5-BC6D-00B0D0A1DE45} - C:\Program Files\AIM\aim.exe
O12 - Plugin for .spop: C:\Program Files\Internet Explorer\Plugins\NPDocBox.dll
O13 - WWW. Prefix: http://
O16 - DPF: {00B71CFB-6864-4346-A978-C0A14556272C} (Checkers Class) - http://messenger.zone.msn.com/binary/msgrchkr.cab31267.cab
O16 - DPF: {5E943D9C-F8DC-4258-8E3F-A61BB3405A33} - http://www.imagestation.com/common/classes/batchdwnl.cab?version=4,3,2,20802
O16 - DPF: {6414512B-B978-451D-A0D8-FCFDF33E833C} (WUWebControl Class) - http://v5.windowsupdate.microsoft.com/v5consumer/V5Controls/en/x86/client/wuweb_site.cab?1104454191546
O16 - DPF: {74D05D43-3236-11D4-BDCD-00C04F9A3B61} (HouseCall Control) - http://a840.g.akamai.net/7/840/537/2004061001/housecall.trendmicro.com/housecall/xscan53.cab
O16 - DPF: {8E0D4DE5-3180-4024-A327-4DFAD1796A8D} (MessengerStatsClient Class) - http://messenger.zone.msn.com/binary/MessengerStatsClient.cab31267.cab
O17 - HKLM\System\CCS\Services\Tcpip\..\{EBECDEA9-F6A1-422D-A959-5F60C2AD65A0}: NameServer = 192.168.0.1,4.2.2.2
O20 - Winlogon Notify: NavLogon - C:\WINDOWS\System32\NavLogon.dll
O23 - Service: Symantec Event Manager (ccEvtMgr) - Symantec Corporation - C:\Program Files\Common Files\Symantec Shared\ccEvtMgr.exe
O23 - Service: Symantec Password Validation (ccPwdSvc) - Symantec Corporation - C:\Program Files\Common Files\Symantec Shared\ccPwdSvc.exe
O23 - Service: Symantec Settings Manager (ccSetMgr) - Symantec Corporation - C:\Program Files\Common Files\Symantec Shared\ccSetMgr.exe
O23 - Service: iPod Service (iPodService) - Apple Computer, Inc. - C:\Program Files\iPod\bin\iPodService.exe
O23 - Service: LexBce Server (LexBceS) - Lexmark International, Inc. - C:\WINDOWS\system32\LEXBCES.EXE
O23 - Service: Norton AntiVirus Auto Protect Service (navapsvc) - Symantec Corporation - C:\Program Files\Norton AntiVirus\navapsvc.exe
O23 - Service: SAVScan - Symantec Corporation - C:\Program Files\Norton AntiVirus\SAVScan.exe
O23 - Service: ScriptBlocking Service (SBService) - Symantec Corporation - C:\PROGRA~1\COMMON~1\SYMANT~1\SCRIPT~1\SBServ.exe
O23 - Service: Symantec Network Drivers Service (SNDSrvc) - Symantec Corporation - C:\Program Files\Common Files\Symantec Shared\SNDSrvc.exe
O23 - Service: Symantec Core LC - Symantec Corporation - C:\Program Files\Common Files\Symantec Shared\CCPD-LC\symlcsvc.exe

How do I get rid of these? Thanks in advance.

Source: http://www.livejournal.com/community/computer_help/441102.html

Date: 07/10/05 (Apache)    Keywords: php, html, apache

I've set up content negotiation according to http://httpd.apache.org/docs-2.0/content-negotiation.html (using Options MultiViews in my Directory sections), and it all sort of works. Kind of.

To test things, I've created a file in the root of my server called phpinfo.php. In it, I'm calling PHP's phpinfo() function. If I call the file with its extension, I get the expected results. However, if I call the file without its extension, I get a prompt to download a file of type appliation/x-httpd-php named phpinfo.

Here is the relevant section of /etc/apache2/sites-enabled/000-default (which is a link to /etc/apache2/sites-available/default):

        DocumentRoot /var/www/
        
                Options Indexes FollowSymLinks MultiViews
                AllowOverride None
                Order allow,deny
                allow from all
                # This directive allows us to have apache2's default start page
                # in /apache2-default/, but still have / go to the right place
                RedirectMatch ^/$ /apache2-default/
        

AddCharset shift_jis   .sjis

AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps

AddType application/x-tar .tgz

cross-posted to cparker

Source: http://www.livejournal.com/community/apache/22070.html

Date: 07/12/05 (PHP Community)    Keywords: php

Hey there,

Quick question. I'm trying to create something akin to a deck of cards, where an item is removed from an array through a random value. This stops being a factor in future selections until it is repopulated.

The problem is that after scouring my PHP manual, I can't see a thing about this specifically. I probably missed something, which is why I want to see if there are options that you are aware of.

This is what I have so far;

$test = array('1','2','3','4','5');

$testFront = array_slice($test, 0, 2);
$testEnd = array_slice($test, 3, count($test));

foreach ($testFront as $key => $value) { $testResult[] = $value; }
foreach ($testEnd as $key => $value) { $testResult[] = $value; }

?>

Any suggestions or hints?

Source: http://www.livejournal.com/community/php/317902.html

Date: 07/11/05 (PHP Community)    Keywords: php

How would one go about determining a file's MIME type with PHP?

I've seen a few solutions that all involve maintaining a discrete list somewhere and updating it--in addition to any other local MIME type lists--as needed. I'd rather use a less "clumsy" way of doing this if one exists.

EDIT: Nevermind! The function was hiding on me on php.net: mime_content_type. I realize that this has been deprecated by the PECL fileinfo extension, but it works for me for now.

Source: http://www.livejournal.com/community/php/317687.html

Date: 07/11/05 (PHP Community)    Keywords: php, templates, web

I've dabbled in building a small site or two with PHP, but my friend has asked me to help with a large scope project. It'll be a site that helps companies stay in touch with clients, posting progress reports on the web. (There are a few sites that already provide this service, but we're looking to start this ourselves, if only for the learning experience.)

Conceptually, I have no problem with most of the project, but it just seems like too much coding to get done in a reasonable time-frame. Surely there are some template code-blocks out there for things like: creating user-accounts with passwords & password hints; file upload scripts that check whether filetypes and sizes are valid; juggling filetypes between pdf's and images; etc.

Do sites with templates for this exist, or is this just wishful thinking on my part?

Source: http://www.livejournal.com/community/php/317321.html

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

I need some help with a query I'm trying to create to send to MySQL. The problems are on the PHP side, so I'm posting here rather than at mysql.

I have an array of starting letters. I'm trying to select all projects that start with a letter in an array. The array will have at least one letter, possibly more.

Here is the code that's causing me confusion:

foreach ($startlet as $let){
   $sql.=" $projectcolumn[title] LIKE '".$let."%'";
}

$i=0;
	while ($i<(count($startlet)-1)){
		$sql.=" $projectcolumn[title] LIKE '".$startlet[$i]."%' OR";
		$i++;
	}
	$sql.=" $projectcolumn[title] LIKE '".$startlet[$i]."%'";

Source: http://www.livejournal.com/community/php/317164.html

Date: 07/13/05 (Javascript Community)    Keywords: php, java

I have a multiple select box problem.


   0
   1
   2
   3
   4


Is there a way to use javascript to select one or more of the options? That is, to hightlight them as if the user clicked on them with the mouse.

The name of the box has to have a [] on the end, since I'm passing this to PHP, and it's gotta be named like an array in order to pass all of the information (which options the user has selected.)

document.addPost.relatedFiles[0].options[0].selected doesn't work, neither does document.addPost.relatedFiles.options[0].selected.

Source: http://www.livejournal.com/community/javascript/71141.html

Date: 07/13/05 (Web Development)    Keywords: php, browser, css, database, web

This is driving me crazy. Any help would be much, much appreciated.

I'm redoing the site template for this intranet website I'm designing - the Dreamweaver template I'd made using tables is completely, inexplicably fubar on certain pages of the site. I got sick of messing with it and told my boss I was going to make an all-new, CSS-based layout, and that was that. He agreed to let me do so.

Everything's been going fine...I've been doing my primary testing in FireFox, but I've been doing testing in IE6 (mostly because that's what almost everyone in this department is likely to use), as well as minimal viewing in Opera 8 and Netscape 7.

Suddenly, things broke. Now I have part of the content text repeated below my footer text. See link here:

http://www.shifuimam.com/php_tutorials/database_trial/drfe/template.php

I've discovered that if I remove the "float: left" property of the lefthand area of the site in my CSS, it fixes it. However (of course), removing that element completely throws the site layout out of whack. I'm about to do absolute positioning of all the elements and throw this template out the window.

I beseech you, please, please help me.

Oh, and while I'm at it...I want the gray lefthand column to extend to the bottom of the browser window, regardless of the length of the content. In all browsers, setting the "length" property to "100%" makes it too long, because there's stuff ABOVE that navigation bar. Any ideas?

X-posted between shifuimam, webdev and webdesign.

Source: http://www.livejournal.com/community/webdev/219531.html

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

Whenever I've got a mysql query and the user is inputting something in a feild (let's just say for example a login page), I add addslashes to every GET and POST request. Is there anything else I can do to protect myself from sql injection? I'm fairly new to mysql so I'm not entirely sure of all of its commands and what not. I thought it would be appropriate to post this in a PHP community, though, because everything that I would have to worry about is in my php coding.

Any help is greatly appreciated.

Source: http://www.livejournal.com/community/php/318792.html

Date: 07/14/05 (Web Development)    Keywords: php

Hello, once more.

I'm writting this more in a inquisitive mode. I'm designing my URIs for my site, and i was just wondering what was your take on this subject. Bear in mind that this is for a blog... archive and stuff.

A few start-up points.

• Why use http://host/post/1 instead of the usual http://host/file.php?page=post.php+id=1?
  to be search-engines-friendly, and it looks normal for "the common folk", it looks tidier ;) and plus, enables you to change the way your site works without breaking your links... are there more reasons?
  
  
• The usage of id's or a slug for posts?
  what's best? With id's you win in length, but you loose in quick identification of the post.. points for and against?
  
  
• When an archive, use date, for instance: http://host/2005/07/03/slug
  you automatically sort your posts under year and month.. but is it really necessary to include the day?
  
  
• what else? i'd like to hear your views...

Source: http://www.livejournal.com/community/webdev/219923.html

Date: 07/14/05 (Java Web)    Keywords: php, database, java

Today I had an interesting conversation with my ex-Boss and good friend. He asked me to summarize the current state of Java world these days as he was busy with databases and scientific computing. Here is my short take on it. Ruby has become a cult like Apple. PHP guys think they are winning over Java. [...]

Source: http://blog.taragana.com/index.php/archive/how-is-java-world-going-thse-days-a-summary/

Date: 07/15/05 (Computer Geeks)    Keywords: php, css, html, xml, sql, java

I'm looking to learn some computer languages and programs and I have this simple list here: Java Java Script Perl C C+ C++ PHP SQL VBasic CSS HTML XML Adobe Photoshop Adobe Illustrator Am I missing anything?

Source: http://www.livejournal.com/community/computergeeks/726141.html

Date: 07/15/05 (Code WTF)    Keywords: php

гламурное php сообщество: http://www.livejournal.com/community/phpprincess/

Source: http://www.livejournal.com/community/code_wtf/11012.html

Date: 07/15/05 (WebDesign)    Keywords: php, browser, web, hosting

Hello everyone! I'm at a real loss with this website I'm developing. You might remember I posted about making an enrollment form, and you were all super helpful. The thing is that the server hosting the site does not support any scripting, so I've had to code the page the retard way (http://www.cfs.purdue.edu/itsi/testitems/EnrollmentForm1.htm). The people want there to be at least a confirmation page show when the person submits the e-mail, which I have included. However, the page shows up if the user presses submit, regardless of whether or not it has submitted, and in a new window. This is just done using Dreamweaver options to open a browser window upon submit.

Can anyone take a look at it and tell me what in the world I can do for these folks? I've looked online, everyone says PHP, scripts... I'm going nowhere on it.

Source: http://www.livejournal.com/community/webdesign/928935.html

Date: 07/16/05 (PHP Community)    Keywords: php

Has anyone successfully upgraded the version of PHP that comes preinstalled with Tiger to PHP5? I tried using darwin ports (sudo port install php5) and it says it's activated, but when I run php -r "phpinfo();" it still says its using php 4. So I'm thinking I'm gonna have to compile it from source, unless there's a better way. Any suggestions?


Crossposted in php and macosx.

Source: http://www.livejournal.com/community/php/319807.html

Date: 07/17/05 (WebDesign)    Keywords: cms, php, mysql, database, sql

I know, another "what CMS should I use?" question. But hear me out. I'm looking for a CMS that's flexible, easy to set up, allows all users to submit content, and has some sort of mechanism for reviewing items (like Epinions or Amazon or Yelp.)

I can run PHP (safe mode only) or Perl, and I've got a MySQL database.

Any suggestions? Please?

Source: http://www.livejournal.com/community/webdesign/930368.html