Date: 02/08/08 (Asp Dot Net)    Keywords: database, yahoo

I need a grid where I can select a checkbox or select everything else in the row.

So I could select the checkbox and hit the delete button and the row is deleted in the database. Or I could click on one of the other columns in the row and the item is opened in another page. (Kinda the way Yahoo Mail works)

Does anyone know if that is possible ? (And have you seen an example if it is ?)

Source: http://aspdotnet.livejournal.com/95513.html

Date: 01/28/08 (Asp Dot Net)    Keywords: database

How do I run a piece of code each time a page is displayed ?

I thought I could just put it in the page_load and not use a page.ispostback and that would mean the code is called each time the page is displayed.

However, I have a linkbutton that modifies a customer in the database. When the user clicks the linkbutton, the customer is modified and the page is redisplayed BUT I dont see the updated information for the customer.

(I have another page that displays a grid that shows the latest data whenever it is called).

Should I create a function to load the customer that the page_load and linkbutton both call ?

Source: http://aspdotnet.livejournal.com/94877.html

Date: 03/26/10 (PHP Development)    Keywords: php, database, web

Hi I need a little help with this. I'm looking for a simple PHP script that i used to have and now im having difficulty finding it. All the script does it retrieve the data from another webpage created on your server, so when you click the link (/index.php?page=contact) and the page reloads, the page will have that data in the content area of your index template.

I don't remember this code ever needed a database.
Can anyone help?

Source: http://php-dev.livejournal.com/83094.html

Date: 02/12/10 (PHP Development)    Keywords: database

I'm surprised to see the var_dumps aren't identical. Is there any reason in practice to worry about the difference between them? Also, in general, is code like following frowned upon? I'm building up a data structure through reading rows from a database -- an array of arrays.

array('C'=>'C')));

array(1) {
  ["B"]=>
  &array(1) {
    ["C"]=>
    string(1) "C"
  }
}
array(1) {
  ["B"]=>
  array(1) {
    ["C"]=>
    string(1) "C"
  }
}

Source: http://php-dev.livejournal.com/82911.html

Date: 08/16/09 (PHP Development)    Keywords: database, shopping

Does anyone have any experience of installing paypal express on a custom built shopping cart? i'm getting absolutely nowhere and and starting to lose the will to live :( Is there any kind sole willing to have a look at the code for me? maybe even correct it, test it, make it work? for a little bit of cash? None of the online tutorials i've found make any sense :/

I've got a business account set up and have the API details, and i have a sandbox account with API details. The express button is on the checkout page and takes me to paypal sandbox. but it doesn't seem to be taking the order details through with it. I also need the site to update the database to say payment has been received and the order should be shipped to the paypal address.

Anyone feeling helpful and kind? :) pretty please? I need this doing as sooon as possible.

[x-posted a little]

Source: http://php-dev.livejournal.com/82433.html

Date: 04/19/09 (PHP Development)    Keywords: php, mysql, database, sql

[solved, thanks to synergetic]

HiGuys,

Needing a bit of help with MySQL queries. Hopefully someone has the answer, or a pointer at least :)

Say I have a page displaying an item, www.domain.com/item.php?id=12 and at the bottom of that page i want to have a Previous link and a Next link which will link to the previous and next item in the database, how do i call the item numbers? I don't want to just do $id - 1 or +1 becausethe next item might be number 14 for example, not 13.

So before the links are displayed, i need some way of saying the id is 12, look at what the next number is in the id column and select that one. So it's not just a prev/next page link, but prev/next item in the DB link.

Hopefully my laymans terms aren't too confusing!

Any ideas? :)

many thanks,

Paul

Source: http://php-dev.livejournal.com/81861.html

Date: 03/10/09 (PHP Development)    Keywords: php, mysql, database, sql, web

[solved, thanks to thenetimp]

(x-posted to php)

Hey guys,

I'm coding an image gallery to use on my PHP site and need a bit of help with a couple of features I want to code into it. I was hoping someone here could either give me some pointers or send me to a website that will help with either explainations or code snippets :)

1. Firstly, thumbnails. I have created an admin panel where I upload the images and can set various things like the category, title etc, and all that is stored in a MySql database, and the file uploaded to a general directory. But i'd also like to create a thumbnail of the image as it uploads. I've found several scripts that make thumbnails from images already in a directory, but i'd like it to happen as I upload the image. Is that possible? Without having to use some all-in-one image gallery script heh. I'd also need it to resize the image proportionally so that images aren't just squashed into a 100x100 square shape.

2. Secondly, I'd like to "tag" images like with LJ entries, so that on the front end when a picture is being viewed, the list of tags is shown and can be clicked on to show other image thumbnails with the same tag. But i'm not really sure how to go about this... I was just going to have a table field called img_tags and store them all in that per image, but then is that efficient? searching for matches within a db field? any tips or suggestions?

3. oh and as an extra thought, how can i then take those tags and make a tag cloud maybe?

All and any help would be most appreciated! :)

paul
x

Source: http://php-dev.livejournal.com/81475.html

Date: 12/25/08 (PHP Development)    Keywords: html, database, google

I am trying to write an event calendar application. For no other reason than the learning experience, so please don't answer by "go use google calendars". You don't learn anything that way.

I have written the part that builds the display of the calendar. I found a class that built a display, but it had all the HTML in the class so I rewrote it to be more of what I wanted.

Now I want to create the database to store the events. I want to enter an event by date. I want to be able to add an event every 2 weeks on thursday, every 3 months on wednesday, but I am not sure how to approach putting that in the database. Looking for some database structure suggestions.

Source: http://php-dev.livejournal.com/80976.html

Date: 02/17/07 (PHP Development)    Keywords: php, mysql, browser, css, html, database, sql, web, linux, apache

Schedge, an Austin based company, is reinventing scheduling.

We are looking for an experienced Lead PHP developer.

Have you developed enterprise scale PHP applications?
Have you worked with technologies like AJAX and MVC?

Then this might be the position for you!

You'll be responsible for leading the development efforts of the core application. The position is contract-to-hire with the option of equity in the company.

Key Areas of Responsibility:
* PHP Application and database development
* Work with Designers and other Developers to build complex user interfaces and data interactions
* Write/Update functional specs

Required Experience:
* Enterprise scale PHP experience
* MVC (Model-view-controller) design experience
* Basic DOM Scripting experience
* Basic (X)HTML & CSS experience
* MySQL
* Multi-browser development
* Apache Webserver

Preferred additional experience:
* Experience with the CakePHP (or similar) PHP framework
* Flash or Action Scripting experience
* MySQL clustering
* Code development for Linux servers

You'll be a good fit if:
* You “get the Web”, and understand it’s full potential.
* Work efficiently and get it right, not just "good enough"
* Can set and execute priorities individually and in a group
* Effectively communicate to people of varying levels of technical expertise

Please note: This is a 100% telecommuting position but the ideal (but not required) candidate would be located in Austin, TX and available for weekly meetings.

If you feel you are a good fit for this position please send your resume and rate per hour to jobs@schedge.com

[cross posted] My apologies if you receive this post more then once.

Source: http://php-dev.livejournal.com/75751.html

Date: 07/13/08 (See my site)    Keywords: database, web, seo

                            Be Something!!

TalentZoo.com is THE website communications professionals and executives, job seekers, and media-savvy people frequent for:

• Information on the company's offline class recruitment services
• A kick-ass job board with the most coveted positions in the advertising, marketing, public relations, broadcasting, and publishing fields
• A resume database employers with Talent Zoo accounts can browse when looking to make their next hire
• Up-to-date industry news
• Industry resources, including articles, podcasts, blogs, and even a salary monitor for professionals to measure their worth
• Our Rookie Directory, where communications professionals with less than 2 years' experience can get their names in front of top employers looking for young talent
• We are currently seeking Bloggers who specialize in Marketing, Advertising, Public Relations!!  Take a look at our blogs:
• www.beneaththebrand.com; www.beyondmadisonavenue.com; www.flackme.com; www.12pointtype.com; www.digitalpivot.com; www.seoshootout.com

Interested?  See our website at: www.talentzoo.com

Source: http://see-my-site.livejournal.com/116084.html

Date: 12/23/06 (Web Hosts)    Keywords: database, google

Does anyone have any suggestions for a search engine script that I can use for my site? I'd like to allow users to search for things within my site [primarily videos], but the problem seems to hinge on the fact that I don't use databases to drive my site.

I wouldn't mind creating the search index myself, I just want something nice and clean to display results and all that. I looked at the option of adding a Google custom search engine to my site but I don't much like the branding and ads.

Any suggestions would be awesome!

Source: http://webhosts.livejournal.com/37707.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://php-elite.livejournal.com/504.html

Date: 09/02/13 (Web Development)    Keywords: php, database, web, hosting

Hi,

I downloaded the Wordpress source files to my development environment, where I am playing around with new features and adding content.
Now that I have a better comfort level with Wordpress, I'd like to migrate my blog content to my production server through FTP.

I understand I also would have to migrate the database too, since that's where all my content is stored.

Should I go through the installation process on my production server, and then copy the modified databases over to production? Or should I just paste all of my PHP source files from dev into a new folder on my server and assume that things will work (I guess that is kind of a silly question?)

Is there anything I should be aware of when pasting the files in Production and logging into it? My biggest concern is while I am going through the installation again, someone else could be trying to go through the Wordpress files as I am configuring my blog environment for the first time.

I can't change the database names on my server, since it is going through a web hosting company, so perhaps it is better to go through the installation again in production, and then migrate the content from the databases.

Your help is greatly appreciated!

Thanks!

Source: https://webdev.livejournal.com/583728.html

Date: 02/11/11 (Web Development)    Keywords: programming, css, html, technology, database, web, seo

Inkwell Creative, a growing Portland, Oregon company focusing on web design, graphic design, interactive media, video and branding, is looking to hire a web developer. We are seeking a hard working team player and someone who is forward thinking when it comes to technology. You must be able to work with us in a collaborative team setting, know many coding and web programming languages and have a strong portfolio.

Requirements:
5+ years of experience
Strong portfolio
Must be collaborative
Knowledge of many coding/web development languages
Knowledge of CSS and HTML 5, Content Management Systems, Flash, SEO programming, Integration into Databases
Knowledge of iPhone apps a plus

Compensation:
DOE. Benefits and paid-for parking. This is a salary position.

TO APPLY:
Email a cover letter, resume and link to your online portfolio to hr@inkwellgroup.com. Please include in your cover letter any outside hobbies, passions and interests. We kindly request no phone calls and no employment agencies.

APPLICANTS WITHOUT A COVER LETTER, RESUME AND PORTFOLIO WILL NOT BE CONSIDERED

Source: https://webdev.livejournal.com/573896.html

Date: 12/28/10 (Web Development)    Keywords: database

I want to create a database of information, and I want to be able to support multiple tags to improve search capabilities.
I'm not sure what is the best way to implement such a (tag) system.
Wondering if anyone can point me in the right direction?

Source: https://webdev.livejournal.com/572544.html

Date: 09/26/11 (PHP Community)    Keywords: php, database, sql, microsoft

I've got a Microsoft Access application that I'm going to have to convert to PHP and another database (PostGres or SQLite). The db portion I could do by hand if I needed to (the tables are not complicated). It's the forms that I'm worried about.

Does anyone have any experience with a tool for converting Access forms to PHP code? I found DB Convert, which looks promising, but I'd like to know about anyone's first-hand experiences.

Source: https://php.livejournal.com/682814.html

Date: 02/11/11 (PHP Community)    Keywords: programming, css, html, technology, database, web, seo

Inkwell Creative, a growing Portland, Oregon company focusing on web design, graphic design, interactive media, video and branding, is looking to hire a web developer. We are seeking a hard working team player and someone who is forward thinking when it comes to technology. You must be able to work with us in a collaborative team setting, know many coding and web programming languages and have a strong portfolio.

Requirements:
5+ years of experience
Strong portfolio
Must be collaborative
Knowledge of many coding/web development languages
Knowledge of CSS and HTML 5, Content Management Systems, Flash, SEO programming, Integration into Databases
Knowledge of iPhone apps a plus

Compensation:
DOE. Benefits and paid-for parking. This is a salary position.

TO APPLY:
Email a cover letter, resume and link to your online portfolio to hr@inkwellgroup.com. Please include in your cover letter any outside hobbies, passions and interests. We kindly request no phone calls and no employment agencies.

APPLICANTS WITHOUT A COVER LETTER, RESUME AND PORTFOLIO WILL NOT BE CONSIDERED

Source: https://php.livejournal.com/681768.html

Date: 12/04/09 (PHP Community)    Keywords: database

Hi Guys!

Another dumb question from the peanut gallery!

If you're writing a bunch of classes that will run an application, where is the best place to have your database connection(s)? Would it be in the file that ends up interfacing with the user and receiving/displaying data, in the class files themselves, or some other location?

Thanks!

Edit: If the answer is in the calling files, how would you make sure your classes used it, and how would you pass it across pageclicks?

Source: https://php.livejournal.com/674926.html

Date: 02/21/09 (C Sharp)    Keywords: cms, database, sql, web

First off, I'll state that I'm working with C# 2008 express edition, SQL Server 2008 Professional edition, and .NET 3.5.

Second, I'll state that one of the ideas behind this project is to do it without .Net's auto-binding. If it can't be done without auto-binding, it's not going to get done at all, for reasons having to do with extreme customization of the data access code that will be happening way, way down the line. So I need an answer in code, not in designer. Thanks.

Okay, what I'm doing seems to me to be simple and obvious, but either .Net doesn't agree with me or I'm looking in the wrong place. I have a simple form. It contains a datagridview and three buttons. One button works perfectly--it's the one that closes the form, and we don't need to discuss it here. The other two buttons, however, are giving me fits. They are labelled "save changes" and "cancel".

The datagridview is bound to a DataTable. This is pretty standard code, I think:

SqlConnection cnErasmus = new SqlConnection();
            //populate the datatable with the data already in the table.
            tblAuthorType = PopulateDataSet(cnErasmus);
            //Attach DataTable to datagrid.
            dgvAuthorType.DataSource = tblAuthorType;

        private DataTable PopulateDataSet(SqlConnection cnErasmus)
        {
            string strAuthorTypeSelectQuery = "SELECT AuthType FROM AuthorType";
            using (cnErasmus)
            {
                using (SqlCommand cmSelectCommand = new SqlCommand(strAuthorTypeSelectQuery, cnErasmus))
                {
                    CreateConnectionString(cnErasmus);
                    OpenConnection(cnErasmus);
                    using (SqlDataReader theReader = cmSelectCommand.ExecuteReader())
                    {
                        tblAuthorType.Load(theReader);
                        CloseConnection(cnErasmus);
                    }
                }
            }

/******************SqlTransaction trnchangeAuthorTypeData = 
       cnErasmus.BeginTransaction("Changes");
            //Must assign both transaction object and connection
            //to Command object for a pending local transaction.
            SqlCommand cmTransactionCommand = cnErasmus.CreateCommand();
            cmTransactionCommand.Connection = cnErasmus;
            cmTransactionCommand.Transaction = trnchangeAuthorTypeData;
            //Whether transaction is committed or rolled back depends
            //on which button the user presses...********************/

Source: https://csharp.livejournal.com/101781.html

Date: 08/01/10 (Apache)    Keywords: mysql, database, sql, jsp, web, linux

I'm involved in migrating an existing, functional JSP/Struts2 app from Windows to Linux.

The former Windows environment was a Tomcat/Struts/Eclipse setup. The new environment is a standalone installation of Tomcat (which is already configured and serving several other applications).

The app in question, "MyJSPWebsite", was copied to the Linux/Tomcat webapps folder and correct permissions assigned. The database (mysql) was also copied over with user permissions established.

The site now opens, but none of the struts enabled content is functioning. For example, a drop-down list of data is not being populated. I'm not seeing any error SQL messages in catalina.out, and the username/password & query work fine from command line.

Are there separate, core struts files that have to be installed outside of those already included in the webapps/MyJSPWebsite folder?

Source: https://apache.livejournal.com/44268.html