Tag Archives: Sql Database

Best way to create a ‘search for’ page in DWMX

Posted on October 18, 2012 by admin419 views

Howdy everyone, We have jumped straight together with this one. My intention is usually to create a page that permits users to find a specific record (word) from your SQL Database. Now the problems is that what the customer is searching for are not in just one column from the table, but five. Reason being is the fact that person who build the DB originally designed it to get ten areas of projects for that user to full, so the areas are Project JUST ONE, project 2, for example.. etc, so in search of a specific project seriously isn’t as simple as looking available as one column/field. I have created ten views inside SQL and hard-coded they’re certified criteria for screening purposes, and then created a union view to collect and display the outcomes of those twenty views, this works excellent but now We have got to build a page in DWMX as it. I have an application with a listing box that displays all of the projects a user may find, once he realizes the project they will click a button as well as a list will appear displaying all the members of staff taking care of that project. … Continue reading →

Posted in Web Design | Tagged , , , , , , , | Leave a comment

Sorry, another PAYPAL question – SOLVED.

Posted on September 10, 2012 by admin474 views

Obtained my buy them now buttons create ok now (see some other thread) – did a test manage and everything’s fine. I’m seeking a method – maybe by using a mysql table of marking the items as sold if the paypal has already been made (and not necessarily before). It could be easy to indicate them as sold once the buy it right now button is constrained, but if a person changes their brain and presses " back" around the first paypal pal it’ll get marked sold if they haven’t finalised the payment. This might have something related to the " return" page on Paypal – if your payment has happen to be finalised and Paypal returns me compared to that page, maybe something has to happen there that will mark the picture as purchased from the database. Any person know anything with regards to this Thanks. Nay hassle, people, I worked out a strong method last night time. Delete thread in order. If you’ll be able to post how people fixed it these, other people may benefit Ok I’ll try : Any time someone presses that " buy the idea now" button it tends to make a timestamp around … Continue reading →

Posted in Web Design | Tagged , , , , , , , , | Leave a comment

Help making Products listing page & uploading info to it

Posted on August 23, 2012 by admin459 views

My business is very new to this sort of requirement & don’t even know very well what to use to go about doing what I need so excuse me only sound dumb in this article…. I want to build a new page which displays a program listing with numerous features etc & shows photos in the product. I want and therefore use this as being a template & have a very simple method regarding uploading different products into a new page whenever & then have them displayed over the internet It might be very similar to how you log onto an aution site & type in your new itemizing details & photo’s & they’ll likely are displayed for the auction site Maybe I want to use an SQL database because of this Any help or maybe ideas on how to go about this may be apprectiated. Respect Paul Certainly, PHP and MySQL… Maybe considering a shopping basket script like OSCommerce Discover something that previously exists, because what exactly you want will take all his time and experience to code personally. Seek Google for: PHP market scripts PHP ecommerce scripts PHP searching cart scripts Several free scripts on the market. You … Continue reading →

Posted in Web Design | Tagged , , , , , , , , , , , , , , | Leave a comment

UTF- and sql database isuue

Posted on August 19, 2012 by admin406 views

This might now be the right forum for this issue but i did browse around before posting these for apprepriate website but anyways, suggestions little proble i’ve been facing. Relating to a database to get say news. Media are posted by users and end users can post applying unicode(UTF-8) somewhere in my page we need to display the all the list such news, not whole content material but say 300 charecters of each one news. With INCI char its no problem you can get using substr within the query for any desired availablility of charecters but! because we dont’ know whether this type of news is with INCII or seemed to be posted using unicode, as well as becuase unicode charecters require 5or 6 incii char in order to display one charecter, We can not use substr function inside query to find 300 charecters on the news, this would likely give me merely about 40 as well as 50 valid unicode chars if displayed. I am pretty sure there’s a way to diagnose unicode chars in the database and fetch desired amount of such charecters and I am hoping one of an individual guys could suggest me the way to … Continue reading →

Posted in Web Design | Tagged , , , , , , , , , , , , , , , | Leave a comment

WordPress Permalinks like YouTube

Posted on July 17, 2012 by admin435 views

Hey Concerning a site pertaining to my videos power by WordPress, but I thought it becomes cool to have got permalinks like youtube . com, how do I do that AGE. G: http: //mysite. com/watchv=Hz86TsGx3fc If you have no way, is there the right way to simply make the particular default post USERNAME longer. AGE. G: http: /mysite. com/4578325 Apply an htaccess track to rewrite your query. use a new sql database with php code this selects * through tablename where identification = $_GET’id’ the url could well be yourdomain. com/id=###### may well change into yourdomain. com/###### but it would show the knowledge from that id within the database along with some other data you place in the table. * means get Every one of the data instead regarding just the username. hope this makes sense. Its very typical. Awesome, thanks! I misread. Regarding wordpress, set as well as to not indicate the category within the url. And it is possible to edit the uri component. if your weblog urls point to the root, then just squeeze id number for the reason that url when a person write the posting. Doing it automatically, you could possibly find a very simple … Continue reading →

Posted in Web Design | Tagged , , , , , | Leave a comment