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

Okay, stumped.

if ($_GET['id'] == "") { $link = mysql_connect("localhost","iop","iopweb") or die ("Could not connect"); mysql_select_db("iop") or die("Could not select database"); $select_string = "SELECT `id`,`name` FROM internships WHERE `approved` != \"yes\" ORDER BY `post_date` DESC"; $result = mysql_query($select_string); while ($current = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "<a href=\"internships_edit.php?id=" . $current['id'] . "\">" . $current['name'] . "</a><br />"; } //end of first clause of get_id if statement } else { echo $_GET['id'] . "<br /><br />"; $query_id = $_GET['id']; echo $query_id; $select_string_specific = "SELECT * FROM internships WHERE `approved` != \"yes\" AND `id` = " . $query_id . " ORDER BY `id` DESC"; echo $select_string . "<br />"; $result_spec = mysql_query($select_string_specific); // Print out the information while ($current = mysql_fetch_array($result_spec, MYSQL_ASSOC)) { echo "<td><b>ID</b>: <input type=\"text\" name=\"this_id\" value=\"" . $current['id'] . "\"/><br /><b>Name:</b> <input type=\"text\" name=\"this_name\" value=\"" . $current['name'] . "\"/><br /><b>Post Date:</b> " . $current['post_date'] . "<br /><b>Title:</b> " . $current['title'] . "<br /><b>Deadline:</b> " . $current['deadline'] . "<br /><b>Description:</b> " . $current['description'] . "<br /><b>Application Requirements:</b> " . $current['app_requirements'] . "<br /><b>City:</b> " . $current['city'] . "<br /><b>Contact Name:</b> " . $current['contact_name'] . "<br /><b>Contact Address:</b> " . $current['contact_address'] . "<br /><b>Contact Email:</b> " . $current['contact_email'] . "<br /><b>Contact Phone:</b> " . $current['phone'] . "<br /><b>Contact Fax:</b> " . $current['fax'] . "<br /><b>URL:</b> " . $current['url'] . "<br /><b>Link to Application:</b> " . $current['app_link'] . "<br /><b>Job yes/no:</b> " . $current['job'] . "<br /> <b>State:</b> " . $current['state'] . "<br /><form action=\"internships_approve.php\" method=\"post\"><input type=\"hidden\" name=\"approved\" value=\"yes\"> <input type=\"hidden\" name=\"submitted\" value=\"yes\"><input type=\"hidden\" value=" . $current['id'] . " name=\"id\"><input type=\"submit\" value=\"Click to Approve\"></form></td>"; } }

Everything works fine until the else portion is reached. At that point, the query that is echoed works just fine if I paste it into my MySQL db, but it acts like an asshole here, apparently, because I get the old "not a valid resource" error message that we all live for. It should only be selecting one record, the one with the corresponding ID number (there are no duplicate IDs) and then displaying the information associated with that ID number after obtaining the ID number from the url as a $_GET. (I know there's some unnecessary variable re-setting in here - I was trying anything I could.)

I can't figure this out. It's something so simple, I bet, and that's why I'm not seeing it because I've been swearing at it for over 30 minutes now.

Any help is appreciated.

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

Date: 01/06/06 (MySQL Communtiy)    Keywords: mysql, sql, google

The MySQL Meetup group meeting on Monday, January 9th will focus on backups -- I will give a 30-45 minute presentation on backups and we will then delve into a discussion -- how folks within the group are backing up, how they're not backing up, how they'd like to back up. If there's time, we'll do a "lessons learned from backup horror stories".

Afterwards, we'll head a few doors down to Boston Beer Works for more chatting.

You can see a video of last month's presentation by Philip Antionades of MySQL AB on the new features in MySQL 5.0 at Google Video:

http://video.google.com/videosearch?q=Mysql+5.0+by+Philip+Antoniades

(we will video this month's presentation but not the discussion)

More details, including the event location and directions, are at: http://mysql.meetup.com/137/events/

I encourage you to sign up to receive notification of events, and participate in discussions outside of the meetups. I won't always be posting here.

Any questions, comments, etc should be sent to me. We're currently looking for a space better than North Station -- something around MIT might be nice, and we're trying to get an MIT grad student/faculty/staff member/organization to sponsor it. (We want a location that's good for people driving AND taking the T, and when the Garden has an event, it's not feasible to park there). If you can help out, please let me know.

(You may forward this announcement to other groups, lists, blogs, whatever.)

I'm quite excited about the presentation, as I'm writing down a lot of information from different sources that really wants to be together, but as far as I can tell is not yet, at least not in a public place.

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

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

First off, new to this community so I hope this is okay :)

Hello, I tried creating my own php based script... and lets face it that was a mess haha (I had so many errors, it was sad really). I've been looking all over the web (literally, I've emailed 20+ people by now) and no one seems to be able to create this project that I am doing (although, one did reply but they were asking for over $500 which I can't afford :/). Basically I'd like a script created, for a project I was hoping on opening a month ago (that went well eh?). Of course I can pay, but I don't have too much money but I'm sure something could be worked out. If interested a discription of what I'd like done (or something similar) will be in the cut below. Thanks in advance, if more detail is require that is fine.


I am creating a project for my up-and-coming forum (despair.nu) where when members join they can take
part in different projects. Project will be like that of xposure.nu (might still be down, sorry)

The project that I need some help on, is creating a php/mysql script where when members join this project they are then approved by having a certain type of link placed on their site. Then a few days a week members are sent random emails containing the user ID, user site address, and user site name and then they must comment on the 3 sites they are sent. Would also like to have it where the emails also contain the comments that the members are supposed to recieve. Also wouldn't mind having some sort of report system, so if someone doesn't comment they can report the member and then member will recieve some sort of warning.Thanks for your time. I was also curious as to 1) How much this project would cost (if you can do it)? and 2) What payment methods you accept (i.e. paypal etc)?.
Thanks for your time


Thanks for those who have read this, that's at least something in my opinion (as cheesy as it sounds). Comment here if interested, or email works as well. Thanks again. Or if someone could point me in the direction of either, learning how to do it myself (which I doubt but, hey call it wishful thinking) or of someone who could possibly do it.

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

Date: 01/09/06 (PHP Community)    Keywords: php, templates, mysql, css, html, sql, java, spam

I've been hunting all around for a decent photo gallery. There seem to be quite a few different projects, some of which are still active, available. None of them seem to accomplish what I'm looking for, though. I have tested quite a few, but all are lacking. To this end, I thought I'd ask here if anyone has anything similar to what I've been looking for.

Major Features:
Abstracts image URLs - hides the path and filename to prevent direct access
Public/private flags - allows some images to stay hidden
Tags - I'd like to be able to tag the images ala del.icio.us, LJ, Flickr
Does not require gd - auto-thumbnails and watermarks can be disabled
Traverses directories - new images can be dropped in a subfolder or the root image folder and will be picked up automatically
Comments - allows for public (configurable) or private comments, either ties into phpbb or uses some sort of email validation/captcha scheme to reduce spam
EXIF - extracts all image data form the photographs and can display it
Uses simple cacheable CSS/XHTML templates
Does not store images in DB
Uses MySQL or abstraction layer that allows MySQL for comments, tags, etc
Takes reasonable measures to be secure and speedy

Minor Features:
Users can upload images
Temporary/expiring image URLs for sharing
Hotlinking configuration - allow all, deny all, allow specific sites
User-switchable templates
Javascript navigation and image pop-ups optional
Keeps stats on a pre image basis - top keywords, views, etc
All images can be watermarked automatically
Thumbnails may be re-generated automatically
Can assign/rename/describe multiple photos at once

I'm sure there are more details, but that should give a start. The scripts I've found so far are either too simple and don't have many features or too complex and require components and methods of use that I won't be using. There are a few others that store the images in the DB, which is something I'm definately against. I want to be able to FTP a directory of images and know that it will be online and ready to go as soon as the transfer is complete, or that it takes a simple click to do a rescan so they are available.

If I have to, I'll start from scratch... I was just hoping that there would be something available that I have not yet found that could serve as a foundation to build from.

Thanks

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

Date: 01/13/06 (PHP Community)    Keywords: php, mysql, html, database, sql, web

Hey Guys

I'm new to this community. I am starting a web design company, and although I used to be decent at PHP, that was a couple of years ago and my knowledge is now pretty much non-existent. I need a script coded for a band website and I was wondering if some of you would give me a price estimate on it.

The script is for bands that want to add shows to their website. The script needs to do the following

- Allow a user to add / edit / delete shows to their website. The shows will be in 2 categories (which will be 2 HTML tables) which are Upcoming shows, and past shows.
- The user puts in information in a form and it's stored in a MySQL database. The most important information is displayed in an HTML table, and in the last cell of the table will have a link for more information. When a user clicks on this link it opens up a popup window and displays ALL the information of the show (eg. Date, time, venue, cost, directions, other notes yada yada yada) in another HTML table (within the pop-up window)

I realise that this is a pretty simple script (in comparison to what you guys have probably coded in the past, so I hope someone out there can code it for me at a reasonable price

Thanks in advance

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

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

i'm trying to select some data from a table. this bit i'm doing quite well with, however it's returning two rows per 'primary key' based on a left join. i've tried using DISTINCT but that doesn't seem to effect it. i then i tried using GROUP BY and that did, so now i'm getting the one row per primary key i was originally after, but i seem to be getting this data without the data of the left join i so desperately need. upon further investigation, back when i was getting two rows per primary key, only the second row per primary key had the data i was after. is their anyway to make sure the query returns the second row as opposed to the first?

my initial idea was to add a clause, but not all rows in the table will have data in that column, i just want to make sure rows with data in that column will definately be returned.

any suggestions?




x-posted to mysql and php_mysql

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

Date: 01/17/06 (MySQL Communtiy)    Keywords: mysql, sql

I have a table that is all messed up so I ran 'repair table my_table'. The problem is that it never completed and didn't give me any error messages. The table is a little bit (a bit over 1 gig), but mysql is using 0.0% of the cpu so it doesn't look like it's doing anything. Does anyone have any ideas to help save my data?

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

Date: 01/17/06 (WebDesign)    Keywords: php, programming, mysql, database, sql, java, postgresql, web, apache

I need some advice in regard to which language to use for developing a dynamic website. My wife and I are thinking about creating a LMAO website, which will allow people to organize various LMAO projects. The website will allow users to register, log in, create projects, join projects, upload pictures, and so on. It's not terribly large project, but still pretty complicated for people who haven't done any web development and little programming in general.

The first problem is deciding upon a language to use. The site will, at least in the beginning, run on our server at home, which is FreeBSD running Apache2 (or anything else we want, to be honest. I'm not giving up FreeBSD, though!). It looks like all major languages in the field, including PERL, Ruby (and Ruby on Rails), Python, and PHP work well with Apache, so that shouldn't be a problem. For the database back-end, we'll be using PostgreSQL or MySQL (if we have to), both of which are widely supported as well.

My wife doesn't have much experience in programming, so for her it will be new experience one way or the other. I have some, but still little. The only language I'm familiar with and can actually write something useful in is Common Lisp. There exists mod_lisp and a couple of web development frameworks, TBNL and UnCommon Web, but the process seems hacky -- from what I can tell -- unless one uses a commercial CL implementations that cost a lot.

I've looked briefly at Python and Ruby, as well as asked for opinions from various groups of people (programmers who prefer Lisp, Ruby, or Python), but it's all still looks like mambo-jumbo to me. The only thing they agree on is that one should refrain from using PHP for anything non-trivial, so I'm inclined to believe that. As far as PERL is concerned, I've always had a distaste for it, so am not all that keen on using it.

Could anyone recommend one of these language, or perhaps another one, that would be suitable for our needs? I've pretty much made up my mind in regards to PHP and PERL, so I'm not looking for a debate about why they're good. I also wish to stay away from Windows-based and Java-based solutions.

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

Date: 01/17/06 (PHP Community)    Keywords: php, mysql, browser, database, sql

Ok, so I have the following code, meant to delete a category in a script I'm working on. It takes the category ID from the $_GET array, checks the database to make sure such a category ID exists, then deletes it if true or shows an error if false.

if ($_GET['categories'] == "deletecat") {
if (isset($_GET['delid'])) {
$idofd = cleaninput($_GET['delid'], 1);
$idofd = (int)$idofd;
$check_delete = mysql_fetch_assoc(mysql_query("SELECT * FROM table_cats WHERE cat_id = '" . $idofd . "' LIMIT 1", $connect));
if (empty($check_delete)) {
echo "

Error: There is no category with the ID number " . $idofd . ".

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

Date: 01/18/06 (MySQL Communtiy)    Keywords: php, mysql, sql

good evening! has anybody ever seen mysql clients (mysql, php, check_mysql(nagios), etc) choke with an error similar to 'can't assign requested address' ? I've got over 30,000 connections listed in netstat with a status of TIME_WAIT. fairly basic php/mysql site (high traffic), no apparent cause.

possible causes I've thought of:

- maybe somebody initiated a connection but didn't close it.. thrwarted due to the mysql reporting otherwise.
- mysql being retarded? not likely, when the error occurs, no incoming connection is reached by the mysql server (via tcpdump/ngrep), resource usage on the server is fine. same with the process list.
- max files being reached?

any thoughts? :D

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

Date: 01/19/06 (MySQL Communtiy)    Keywords: mysql, database, sql

These tech communities are mostly questions from those that need help which I often do :)
I thought it'd be fun to change the pace a little and post some info I think is good to know if your using mysql.

I've recently had problems with table crashes and running mysql in an environment with very little disk space. This has taught me a few things I did not know before hand. One of which is mysql's binary log (also known as the update log in older versions). It stores all statements that are run that could potentially modify data in the database which allows restores to work as best as possible (i.e. even if your backup is a bit old). For more info check the binary log docs

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

Date: 01/17/06 (WebDesign)    Keywords: php, programming, mysql, database, sql, java, postgresql, web, apache

I need some advice in regard to which language to use for developing a dynamic website. My wife and I are thinking about creating a LMAO website, which will allow people to organize various LMAO projects. The website will allow users to register, log in, create projects, join projects, upload pictures, and so on. It's not terribly large project, but still pretty complicated for people who haven't done any web development and little programming in general.

The first problem is deciding upon a language to use. The site will, at least in the beginning, run on our server at home, which is FreeBSD running Apache2 (or anything else we want, to be honest. I'm not giving up FreeBSD, though!). It looks like all major languages in the field, including PERL, Ruby (and Ruby on Rails), Python, and PHP work well with Apache, so that shouldn't be a problem. For the database back-end, we'll be using PostgreSQL or MySQL (if we have to), both of which are widely supported as well.

My wife doesn't have much experience in programming, so for her it will be new experience one way or the other. I have some, but still little. The only language I'm familiar with and can actually write something useful in is Common Lisp. There exists mod_lisp and a couple of web development frameworks, TBNL and UnCommon Web, but the process seems hacky -- from what I can tell -- unless one uses a commercial CL implementations that cost a lot.

I've looked briefly at Python and Ruby, as well as asked for opinions from various groups of people (programmers who prefer Lisp, Ruby, or Python), but it's all still looks like mambo-jumbo to me. The only thing they agree on is that one should refrain from using PHP for anything non-trivial, so I'm inclined to believe that. As far as PERL is concerned, I've always had a distaste for it, so am not all that keen on using it.

Could anyone recommend one of these language, or perhaps another one, that would be suitable for our needs? I've pretty much made up my mind in regards to PHP and PERL, so I'm not looking for a debate about why they're good. I also wish to stay away from Windows-based and Java-based solutions.

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

Date: 10/11/05 (PHP Development)    Keywords: php, mysql, database, sql, web

This has irked me for some time: The lack of INI handlers in PHP.

I was moving my website around from host to host, until I settled, and needed a universal standard that I could write on and rely on that would work anywhere as I really wouldn't have a MySQL database everywhere I went. So I wrote this up after not finding a shred of a command for userlevel INI file handling. INI.Lib (Last Built Oct. 3rd, 2004)

I hope some other people can make some use out of it as well I was able to. If you see any major errors or when you use it you can't for the life of you get past a certain bug, let me know and I will see if this one is any real difference from my current build (Apr. 3rd 2005). I may have just patched up a few commands here and there with my build that I caught in the original code and done a few optimizations. If anyone wants the current build, go ahead and drop me a line to cynagen at cynagen dot com, and I'll be more than happy to send you a copy of the current copy on my server; if enough of you report problems, I'll just repackage my current build and post that instead.

(X-Posted on October 10th 19:54)

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

Date: 06/28/05 (PHP Development)    Keywords: mysql, database, sql, google

I'm working on a site at the moment and I'm trying to optimise the MySQL queries, to place less of a strain on the server and make generally neater code. I'm currently using this technique to pull the last 10 topics flagged as news from the database:

$query = mysql_query( "SELECT * FROM frm_topics t WHERE t.tpc_news = '1' AND t.tpc_news_mod_id > 0 ORDER BY t.tpc_sticky DESC, t.tpc_time DESC LIMIT 10", $_GLOBALS[ 'sql' ] );

$news_sql = mysql_query( "SELECT * FROM frm_posts p WHERE p.pst_tpc_id = '".$results[ 'tpc_id' ]."' ORDER BY pst_time ASC LIMIT 1", $_GLOBALS[ 'sql' ] );

$query = mysql_query( "SELECT * FROM frm_posts p, frm_topics t WHERE p.pst_tpc_id = ( SELECT tpc_id FROM frm_topics t WHERE t.tpc_news = '1' AND t.tpc_news_mod_id > 0 ORDER BY t.tpc_sticky DESC, t.tpc_time DESC LIMIT 10 ) AND t.tpc_id = p.pst_tpc_id ORDER BY p.pst_time ASC LIMIT 1", $_GLOBALS[ 'sql' ] );

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

Date: 06/07/05 (PHP Development)    Keywords: php, mysql, software, html, xml, database, asp, sql, security, web, apache

Here's what I have
Apache 1.3.33
PHP 5.0.4
MySQL 4.1.12a
Operating System: Windows 98

The error that I got when I tried using mysql_connect() on a php page:

Fatal error: Call to undefined function mysql_connect()

Things that I have done so far:
Apache, mySQL, and PHP are in directories on the C drive, named accordingly

in php.ini, this is what I changed (change in italics)
doc_root = "C:\Apache\htdocs"
extension_dir "C:\php\ext"

Removed the ";" in front of extension = php_mysql.dll (Is there supposed to be quotation marks on this line?)

Saved a copy of php.ini (after these changes) in the C:\Windows directory
Saved copies of c:\php\libmysql.dll & c:\php\ext\php_mysql.dll to the C:\Windows directory


--------------
What else am I missing?


PHP Version 5.0.4

System Windows 9x JESSICA 4.10
Build Date Mar 31 2005 02:44:34
Configure Command cscript /nologo configure.js "--enable-snapshot-build" "--with-gd=shared"
Server API Apache
Virtual Directory Support enabled
Configuration File (php.ini) Path no value
PHP API 20031224
PHP Extension 20041030
Zend Extension 220040412
Debug Build no
Thread Safety enabled
IPv6 Support enabled
Registered PHP Streams php, file, http, ftp, compress.zlib
Registered Stream Socket Transports tcp, udp

This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.0.4-dev, Copyright (c) 1998-2004 Zend Technologies



--------------------------------------------------------------------------------

PHP Credits

--------------------------------------------------------------------------------

Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference On On
allow_url_fopen On On
always_populate_raw_post_data Off Off
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_globals_jit On On
auto_prepend_file no value no value
browscap no value no value
default_charset no value no value
default_mimetype text/html text/html
define_syslog_variables Off Off
disable_classes no value no value
disable_functions no value no value
display_errors On On
display_startup_errors Off Off
doc_root no value no value
docref_ext no value no value
docref_root no value no value
enable_dl On On
error_append_string no value no value
error_log no value no value
error_prepend_string no value no value
error_reporting no value no value
expose_php On On
extension_dir C:\php5 C:\php5
file_uploads On On
highlight.bg #FFFFFF #FFFFFF
highlight.comment #FF8000 #FF8000
highlight.default #0000BB #0000BB
highlight.html #000000 #000000
highlight.keyword #007700 #007700
highlight.string #DD0000 #DD0000
html_errors On On
ignore_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off
include_path .;C:\php5\pear .;C:\php5\pear
log_errors Off Off
log_errors_max_len 1024 1024
magic_quotes_gpc On On
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
mail.force_extra_parameters no value no value
max_execution_time 30 30
max_input_time -1 -1
open_basedir no value no value
output_buffering 0 0
output_handler no value no value
post_max_size 8M 8M
precision 14 14
register_argc_argv On On
register_globals Off Off
register_long_arrays On On
report_memleaks On On
report_zend_debug On On
safe_mode Off Off
safe_mode_exec_dir no value no value
safe_mode_gid Off Off
safe_mode_include_dir no value no value
sendmail_from no value no value
sendmail_path no value no value
serialize_precision 100 100
short_open_tag On On
SMTP localhost localhost
smtp_port 25 25
sql.safe_mode Off Off
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 2M 2M
upload_tmp_dir no value no value
user_dir no value no value
variables_order EGPCS EGPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
zend.ze1_compatibility_mode Off Off


apache
Apache for Windows 95/NT

Apache Version Apache/1.3.33 (Win32) PHP/5.0.4
Apache Release 10329100
Apache API Version 19990320
Hostname:Port localhost:80
Timeouts Connection: 300 - Keep-Alive: 15

Directive Local Value Master Value
child_terminate 0 0
engine 1 1
last_modified 0 0
xbithack 0 0


Apache Environment
Variable Value
COMSPEC C:\WINDOWS\COMMAND.COM
DOCUMENT_ROOT c:/apache/htdocs
HTTP________________ ----- -------
HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-shockwave-flash, */*
HTTP_ACCEPT_LANGUAGE en-us
HTTP_CONNECTION Keep-Alive
HTTP_HOST localhost
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 6.0; Windows 98)
PATH C:\WINDOWS;c:\windows;c:\windows\COMMAND
PHPRC C:/php
REMOTE_ADDR 127.0.0.1
REMOTE_PORT 2477
SCRIPT_FILENAME c:/apache/htdocs/phptest.php
SERVER_ADDR 127.0.0.1
SERVER_ADMIN jessica.karels@gmail.com
SERVER_NAME localhost
SERVER_PORT 80
SERVER_SIGNATURE

Date: 10/15/04 (Elite PHP Development)    Keywords: php, mysql, database, sql, java

I was lookin around and found this tonight. Very much kewlness, I am hopeing to join in on the fun in the development community so I can add in my ideas to make PHP even better.
This is a little bit of information I picked up on Creating Custom Exceptions and sending data to the parent class from a function in a subclass. Very spiffy.

query("SELECT NOW()");
var_dump($result->fetch_row());
}
catch(ConnectException $exception) {
echo "Connection Error\n";
var_dump($exception->getMessage());
}
catch(QueryException $exception) {
echo "Query Error\n";
var_dump($exception->getMessage());
}
/* Handle exceptions that we weren't expecting */
catch(Exception $exception) {
echo "Who was that masked exception?\n";
var_dump($exception->getMessage());
}

$result->close();
$my->close();

?>

very spiffy, and I will be posting something using the new MySQLi class. Maybe a whole class system for the generation of graphics pulled from a database. Possibly attach that to a javascript paint proggy, or even better a flash paint proggy..... hmmm the posibilities are endless, but i have to get back to my money making... Gotta love it, but it would be so much more fun if i had a project that really challenged my knowledge and abilities, but well get to that someday.
-=Levi=-

Source: http://community.livejournal.com/php_elite/504.html

Date: 12/14/05 (Javascript Community)    Keywords: php, mysql, database, sql, java

Hi, I have some questions regarding the best way to go about creating dynamic dropdowns in javascript.

I have to create a form with two dropdown lists. One for US states the other for counties within those states. The county dropdown will remain blank until the user selects a state, then the county dropdown will be populated with the correct counties for that state.

I have this working using PHP (the rest of the application is PHP) but I want to do it without reloading the page. The list of states and counties are stored in 2 tables in a mysql database.

My first instinct is use PHP to write the javascript for me. Do the DB work with PHP and then write the javascript arrays. But that seems wrong.

I would think that the javascript should go something like this and would be called from an onchange handler in the state dropdown. I dont know the exact syntax.

create function setOptions(id)

create array of counties indexed with their id's from the database

if there is an id passed to the function
    iterate through the array of counties
        if a key matches the id then write that to the options tag of the county select list

Source: http://community.livejournal.com/javascript/88041.html

Date: 06/22/05 (Software)    Keywords: php, mysql, sql, security, web, linux, yahoo

I have a group of users (100 or so) that need read/write access to a document (excel) of sensitive information. Since they are all over the place, they requested a web application to be able to access from anywhere whenever they need to modify or look at this document. I'm trying to figure out what is the best way to provide a secure way to only allow these specific users to access this document.
ideas have included:

Plone - complex, looking for simplicity
phpBB - requires me to set up a mysql linux box somewhere which might be possible
Yahoo groups - not very secure but basically what i want

any other ideas? Security of this information is the biggest priority. i currently have both linux/windows available to host.

Source: http://community.livejournal.com/software/54525.html

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

Hello all,

I am working on a project to create highly customizable live cds mainly for my peronal use and for friends to try diffrent OSs. At the moment I have several shell scripts that I am looking at converting over to PHP if possiable. The bulk of it i know can be ported easily enough but I have never attempted to call other programs besides MySQL in PHP so I am not quite sure if it is feasable. The server will be located all inhouse with no outside access untill i can be sure of the security implcations involved in the procedure and lower the risks. Can I access other programs through php, spefically can I run "/usr/local/bin/mkisofs -b boot/cdboot -no-emul-boot -c boot/boot.catalog -r -l -L -V LiveCD -o $LIVEISODIR/LiveCD.iso ." and get the intended result? Any thoughts would be appreciated.

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

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

I am writing an open source cms called Rade (intended for release), and want to store images in the MySQL database; MediaWiki's upload system sounds suspiciously insecure, and makes storing metadata harder. However, I have read that blobs in SQL databases decrease their performance. Should I store the images in another table? Another database?

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