Date: 02/08/05 (Web Development)    Keywords: php, programming, mysql, database, asp, sql, jsp, web

Ok, I've got a question for all the professionals out there. I've been looking for a while now to get into server-side web programming (PHP, ASP, JSP, SQL) for a little while now. While I do have experience working with these things working on personal projects, I have no professional experience. I was wondering if anyone had any suggestions on what I can do to more effectively represent myself in this way.

In terms of skills, I'm talking a heavy PHP/MySQL background, with a focus on content managers and database served content.

Just hoping someone might have some pointers. Feel free to ask me any questions.

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

Date: 02/18/05 (PHP Development)    Keywords: php, mysql, sql

alright first post, mysql ver 4.1 installed, running off of a winxppro operating system.

I have phpmyadmin-2.6.0-pl1 on my home computer, and whenever I try to logon as root using the password I specified it says "Error
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client"

Source: http://www.livejournal.com/community/php_dev/52920.html

Date: 02/03/05 (PHP Development)    Keywords: php, mysql, database, sql, java, google

I'm sure this is going to create a firestorm of debate, but I'm tired of spending countless hours on Google. Before doing PHP, I was a Perl/Java programmer, and was used to doing database stuff with DBI in Perl more than anything else. I'm presently writing a PHP/MySQL app, which will be ported over to Oracle, so I'm looking to start using an abstraction layer (something I admittedly should've been doing the whole time). I've researched ADOdb and Pear::DB, and I can't make up my mind. Would some of you folks mind sharing your personal experiences?

Thanks!

Source: http://www.livejournal.com/community/php_dev/52325.html

Date: 01/02/05 (PHP Development)    Keywords: php, html, database, sql, java, security, web

alright, so, i finally got around to designing my 'security system' for my family's website. here's how it'll work:

1. user enters their username and password into an html form. a javascript function will confirm that both are between 6 and 16 characters long
   
2. if they, are, they'll be passed to login.php which will double check the lenghts of the two strings, and then confirm that neither one contains anything but letters and numbers. if they don't pass muster, the user gets rerouted to the html login form.
   
3. if the above two criteria evaluate to true, then a SQL query will run to see if there's a matching username and password row in a database.
   
4. IF SO, the script calls session_start() and $_SESSION['UsrIsLogdIn']=true;. the script then redirects them to the rest of the site.

Date: 12/29/04 (PHP Development)    Keywords: php, mysql, browser, database, sql, security, web

i am preparing to design a website for my family. i'd like it to have a secure log-in, which references usernames and passwords in a mysql database. i'd like the rest of the website to be secure, meaning, if you're not logged in, you're redirected to the index. i'm planning to use sessions with cookies. as i'm relatively new to security in web design, i'd like some advice.

i know the login.php script will check the username and password against a corresponding user table. if the login succeeds, a call will be made to session_start(). session_start() will be called on all subsequent pages, as well as a check to see if the login status is true (or something like that). herein is my first question:
what should each subsequent page of the site check for?

do i need to turn SSL on or will sessions, cookies and a database be enough? (it doesn't need to be super tight--mainly, some of my aunts and uncles don't want the pictures of their bikini clad daughters from our beach trips accessible to just anyone over the net.)

... i guess i'm not entirely sure what else to ask. i suppose that i'll need to make each page check to see if the above mentioned login status variable is set to true, but how do i set it to false? do i just design the session or cookie to expire when the browser is closed?

any help or feedback is appreciated. if you know of a good site (that's easy to understand) which goes over what you need to do to design s secure site, please let me know.

ah, by the way, the environment i'm designing this site for is a RedHat server with PHP4.3.9 and MySQL4.0

thanks for your help

Source: http://www.livejournal.com/community/php_dev/50687.html

Date: 11/17/04 (PHP Development)    Keywords: php, mysql, database, sql, web

(x-posted all over the damn place)

I am currently looking for a good web host that offer Tomcat AND php AND some kind of database (MySQL or PostGres - I'm not picky). I'd also like to go with someone who has a sane usage policy (I once had a site yanked by addr.net due to "inappropriate content").

Currently, http://www.oxxus.net/ looks pretty good.

Anyone have any other suggestions?

Source: http://www.livejournal.com/community/php_dev/49616.html

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://www.livejournal.com/community/php_elite/504.html

Date: 02/22/05 (PHP Community)    Keywords: php, blogging, sql

is there anyone oout there who knows much about working with Oracle? i have a few questions about a project i'm doing.

i've created a very basic blogging system, the index page displays all of the posts (in a very ugly plain format hehe), and has a link to a page where you can write your post. click Submit and the post is commited to the DB and going back to the indexpage you can see the new post.

I'd like to be able to display the posts in a more attractive way, but i'm not sure how. I really only know the basics of PHP and SQL.
The second thing i'd like is to have the ability to comment on each post, similar to LJ really.

All source code for the pages can be provided if anyone would like to tackle this. If someone has the time to step-by-step me through these i'd be super grateful! if someone feels kind enough to write the code and be done with it, even better. Or if ou are feeling cryptic and just want to supply some really good links to sites that deal with PHP/Oracle tutorials, that would be helpful too! :)

-fingers crossed-

pretty please? :)

paul.

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

Date: 02/23/05 (PHP Community)    Keywords: php, mysql, xml, sql, java, linux, apache

I'm having a few problems getting Mambo working on FreeBSD 5.3

Whenever I try to log in to the administrators account, with a valid username\password, you get presented with the same screen with the username\password boxes still filled in. /var/log/messages states "Feb 23 17:42:42 linux kernel: pid 15803 (httpd), uid 1006: exited on signal 11"

Nothing is written to the Apache access or error logs

If I try to log in with an invalid combo, a JavaScript popup tells me I got either the username or password wrong. So, the authentication is sort-of happening

The only useful thread I've found on the Mambo forums was this one. Which states "To all who have this issue, it is a problem with duplicate extension entries in your php.ini"

All I have in my php.ini that contains references to extension are:

extension_dir = "/usr/local/lib/php/20020429/"
extension=session.so
extension=mysql.so

So there aren't any duplicates

I really don't know much about setting PHP up. Does anyone have any pointers?

I seem to remember having this problem in the past with Gallery, and the issue was resolved by installing php4-extensions

Here's the version of all PHP stuff I have installed:

# portversion -v | grep php
mod_php4-4.3.10_2,1         =  up-to-date with port
php4-bz2-4.3.10_2           =  up-to-date with port
php4-ctype-4.3.10_2         =  up-to-date with port
php4-extensions-1.0         =  up-to-date with port
php4-gd-4.3.10_2            =  up-to-date with port
php4-mysql-4.3.10_2         =  up-to-date with port
php4-openssl-4.3.10_2       =  up-to-date with port
php4-overload-4.3.10_2      =  up-to-date with port
php4-pcre-4.3.10_2          =  up-to-date with port
php4-posix-4.3.10_2         =  up-to-date with port
php4-session-4.3.10_2       =  up-to-date with port
php4-snmp-4.3.10_2          =  up-to-date with port
php4-tokenizer-4.3.10_2     =  up-to-date with port
php4-xml-4.3.10_2           =  up-to-date with port
php4-zlib-4.3.10_2          =  up-to-date with port
phpMyAdmin-2.6.1            =  up-to-date with port

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

Date: 02/25/05 (Web Development)    Keywords: database, sql

Has anyone ever used this? And, if so, with any success?

http://www.aquafold.com/
Aqua Data Studio is a database query and administration tool that allows developers to easily create, edit, and execute SQL scripts, as well as browse and visually modify database structures. Aqua Data Studio provides an integrated database environment with a single consistent interface to all major relational databases. This allows the database administrator or developer to tackle multiple tasks simultaneously from one application.

trisho.

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

Date: 02/27/05 (PHP Community)    Keywords: php, mysql, xml, sql

Can anyone recommend a good script they know of that is used to get XML into MySQL, via PHP? I'm creating my own but would like to see some examples if you know of any, thanks!

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

Date: 01/08/05 (Java Web)    Keywords: mysql, sql

/etc/rc.d/init.d/mysqld start /etc/rc.d/init.d/mysqld stop /etc/rc.d/init.d/mysqld restart And of course there is the brute force way to kill all the processes: $ for i in `ps -ef |grep mysqld |awk '{print $2}'`; do `kill -9 $i`; done cut doesn't cut it in this case. Sure you can also just use awk. Thanks to Anthony Eden for the comment (below) to remove the [...]

Source: http://blog.taragana.com/index.php/archive/how-to-startstop-mysql-server-on-linux/

Date: 02/10/05 (Asp Dot Net)    Keywords: database, asp, sql

Hello, Heres what I need to do:

Bind a CheckBoxList Control to a database where it will select 13 things out I want the easiest way to check which checkboxes are checked and which aren't and add to my database of features the boolean options 1/0 if they are checked or not. Any help would be appericiated.

I'm using ASP.net, SQL7


I have a ghetto version thrown together thats somewhat working if you want to pm me on aim 'sontek' and talk about it. I can paypal a little bit of money for any help. (i'm not rich, so LITTLE, like $20 :P)

Source: http://www.livejournal.com/community/aspdotnet/27717.html

Date: 02/09/05 (Asp Dot Net)    Keywords: database, sql

One more thing I need help with.

I setup a datagrid and it binds itself to the SQL database and outputs ID, Username, Password (md5), Name, Email, Address.

Now I want to beable to click the ID of one of those and have it bring me to a page thats like an edit page for the clicked table. So it'll let you edit, the name, email, or address, or just delete the whole thing.


What would be the best way to do this?

Source: http://www.livejournal.com/community/aspdotnet/27367.html

Date: 02/07/05 (Asp Dot Net)    Keywords: database, sql, microsoft

My connection string keeps giving me the exception:
"SQL Server does not exist or access denied".

Here it is: "server=server;database=master;uid=sa;pwd=xxxx"
I am connecting to another server on the network. I know my uid and pwd are correct, and that sql server is installed and running on that server. My project is in VB.net, not sure if that makes a difference.

I saw this link: http://support.microsoft.com/kb/328306, but I don't think it should be this difficult. I know I've got it to work before without having to configure DSNs or something like that.
Any suggestions?

thanks.

Source: http://www.livejournal.com/community/aspdotnet/26777.html

Date: 01/13/05 (Asp Dot Net)    Keywords: asp, sql, web

I'm having some trouble with tracing. I have a static class whose method I call from a page that I'd like to get trace data from. The method looks like:

public sealed class DbUtils
{
static public int ExecuteNonQuery(string sql, string dsn)
{
  Trace.WriteLine("SQL", sql);
  int rowsAffected;

  OdbcConnection db     = new OdbcConnection(dsn);
  db.Open();
  OdbcCommand    cmd    = new OdbcCommand(sql, db);
  rowsAffected = cmd.ExecuteNonQuery();
  db.Close();
  return rowsAffected;
}
}

System.Web.HttpContext.Current.Trace.Write("SQL", sql);

Source: http://www.livejournal.com/community/aspdotnet/23616.html

Date: 01/13/05 (Asp Dot Net)    Keywords: sql

I'm getting some weird behavior in a function I wrote.

Private Function GetServerStatus() As Integer
Dim strDataSource As String
Dim myConnection As SqlConnection
Dim myCommand As SqlCommand
Dim intStatus As Integer
strDataSource = ConfigurationSettings.AppSettings("DSN")
myConnection = New SqlConnection(strDataSource)
myCommand = New SqlCommand("GetSystemStatus", myConnection)
myCommand.CommandType = CommandType.StoredProcedure
myConnection.Open()
intStatus = myCommand.ExecuteNonQuery()
myConnection.Close()
Return intStatus
End Function

It uses the stored procedure "GetSystemStatus":
CREATE PROCEDURE dbo.GetSystemStatus
AS
DECLARE @SystemStatus int
SELECT @SystemStatus=MAX(systemstatus)
FROM Config
RETURN @SystemStatus
GO

The weird behavior is that GetServerStatus() returns -1, but when I run GetSystemStatus in Query Analyzer, it returns 0 (or whatever the value is).

Source: http://www.livejournal.com/community/aspdotnet/23458.html

Date: 02/02/05 (Javascript Community)    Keywords: sql

Is there a method so that when the submit button is pressed I can enable any disabled parts of the form. I need them disbaled to prevent accidental changes(you click a button to enable them). However they all need to be passed in the submit for the sql procedure to work correctly.

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

Date: 02/25/05 (Mozilla)    Keywords: php, mysql, html, xml, sql

Do any of you bright minds know WHY some programmers decide to use Decimal Unicode notation (e.g., Firefox), whereas others decide to use Hex Unicode notation (e.g. the Gnome/libxml2/xmllint folks)?

My wish is that:

1.) They had all gotten together and decided on just one,
2.) They had all chosen Hex, padded on the left with zeroes so that all characters are represented by a full four digits (e.g. Â rather than Â for Â), the latter of which is NOT conformant to the Unicode specification, which requires four to six digits, not bloody darn one, two or three).

I know they are functionally equivalent, and I know it's a simple mathematical calculation to go from one to the other, and that Perl and PHP both probably have built-in functions that I could use to convert from one to the other, but GRRRR. I long for consistency, and god forbid, standards-compliance.

Also, why if Firefox smart enough to take UTF-8 input in an HTML form and convert it automatically to Decimal Unicode (which mySQL 4.0 can actually understand), but Safari is not smart enough (and of course, neither is I.E., duh).

--

Don't get me wrong, I don't hate Safari. Safari is FAR better than Firefox at rendering certain difficult Unicode glyphs, like Devanagari (Sanskrit) that has internal HTML markup inside conjunct consonants (Opera 6.03 comes close on this). However, when it comes to Hebrew, Greek, and Romanian (the others I've had to deal with recently), Firefox is just hands-down better.

Source: http://www.livejournal.com/community/mozilla/254172.html

Date: 03/01/05 (IT Professionals)    Keywords: sql

My business is currently using Veritas Backup Exec for Windows for all of our tape based backups. due to some recent licensing issues, we're looknig at an alternative to Veritas. I'm brand new to backup exec, so I don't have enough knowledge to ask correct questions, or make a decent comparison.
My big concerns are the following:

remote management/monitoring. I've got about 45 servers that I want to keep an eye on w/o having to touch each or remote into each
remote backups. I'd love to be able to backup 15 or so servers to a single system with tape drive/library
SQL agent/backup. I've got a ton of SQL servers that I'm backing up, and I can't take them offline.

I've looked at Dantz Retrospect, Tivoli, and Livestate Recovery from Symantec, so far.. LSR is disk based, so that's out of the question. anybody have experience with the above, or any others that they could recommend?

x-posted to it_admin, itprofessionals, and computertech

Source: http://www.livejournal.com/community/itprofessionals/6089.html