etrader
Members-
Posts
315 -
Joined
-
Last visited
Never
Everything posted by etrader
-
Delete initial digits at the beginning of a string
etrader replied to etrader's topic in PHP Coding Help
That is my problem. There are other digits within the string, and I need to delete only the initial digits. -
I want to delete (likely by preg_match) the initial digits at the beginning of a string, but no alter to alphabetical characters. The string can contain digit or not. For example: $string="1-words are here"; $string=everything is word"; I want to delete if there is any digits at the beginning of my string. Thanks
-
a long column or several short columns in mysql?
etrader replied to etrader's topic in PHP Coding Help
No, I do not want to perform search, as they are numbers to define some parameters (even it can be only 0,1). And I never call them separetly, when I get them from mysql database, I need all of them. So you think it is better to store them in a single column to reduce the number of columns? -
I want to assign some values for each entry. Which plan is better to assist better mysql performance Plan A: Storing as "value1-value2-value3" in a column created by varchar(50); then I can process the values by explode() or Plan B: Storing values individually in three columns created by int(11) I want to know several small int() is better OR it is better to keep the number of columns lesser by having a larger column of varchar(), as I need to add "-" separator.
-
Thanks folks, this was exactly what I missed
-
I insert into mysql table by a simple form. The problem is that I get error when my text contains (') or ("). Dow I need to put a \ before them by php before inserting into mysql or there's another trick to skip (') and (") when storing and calling text into/from mysql database?
-
I capture a list of my articles from mysql by this command mysql_query("SELECT * FROM Text WHERE Key='$key'") Now I added a column for published and draft to be identified by 1 and 0, respectively. What is the best way to show only published articles? Adding a WHERE condition? What is the most common method in major CMSes? Thanks
-
Differentiating between visitor and bot in user agents
etrader replied to etrader's topic in PHP Coding Help
Thanks LeadingWebDev, Yes this is an alternative solution, as get_browser will provide [crawler] to be true or false. But I have read some reviews on the internet as the [crawler] is not very accurate, probably because get_browser is not very popular. On the other hand, it gives lots of information which are useless to me. Then, I though using $_SERVER['HTTP_USER_AGENT'] and performing preg_match is a lighter process. What do you think? -
I am writing a simple counter, but it counts both visitors and bots. To distinguish between these visits, I use $_SERVER['HTTP_USER_AGENT']. By preg_match I can get which visit is by a bot. The common way in the internet is to define preg_match for each major bot (e.g. googlebot). As I explored, all bots have their official url in the uer_agent. Thus, preg_match by "http://" should consider all bots; as user_agent of a human visitor does not include a url. Right? What's your idea to do so?
-
Thanks WebStyles, you gave me a brilliant idea
-
I want to crop a circle in the middle of a photo. To have transparency of the image around the main circle, I need to save it as PNG. Is it possible to write a php code to 1. crop a full circle in the middle of a JPG file 2. then save it with png transparency to show the main circle only?
-
Thanks premiso, that's exactly what I asked for I use Nginx, thus, I needed to adopt the rule; but it is the easy part. I just needed to have an idea Thanks again!
-
Sorry it was my mistake!
-
I search for words in mysql by mysql_query("SELECT * FROM Articles WHERE Tags LIKE '%$q%'", $con); But I have problem with my tags as they are stored as "tag1,tag2,tag3". Now I want to get every article which contains "tag1"; but this does not work as LIKE %tag1% needs space to detect a word; though my tag list is comma separated.
-
It seems there is no way to do so. I am currently doing what ZulfadlyAshBurn said. I was looking for a way NOT to edit every single php file in my admin folder. I was looking to make a rule for the entire folder, not every single page. WebStyles, I did not ask you to make it work for me. I just asked you to clarify your tip, as apparently you did not get my issue. Anyway, thank folks!
-
Sorry I didn't get it. Where should I put this code? I am looking for a way to create limited session to avoid access to the entire folder of admin; without putting the code in each single page.
-
I created a session by a login page, and limited the pages by adding this condition to every page if(!isset($_SESSION['level'])){ echo"You are not authorized to visit this page"; } This works perfectly for every single page, but how I can use it for an entire folder like admin folder ?
-
I have created a very simple CMS by storing articles in mysql database. Everything is OK for my need; but I have no idea how to handle user management. I have created a table for users and a page to create new accounts. But how I can restrict the article submission page to logged in users? How I can show a widget of profile of logged users? I think there are different ways to do so; define(), cookie, .... What is the best method as CMSes normally use? Thank you in advance
-
Thanks TeNDoLLA, I prefer the explode trick. It's quite simple, and I am dealing with explode a lot.
-
brilliant idea, $str2[0] will always return regardless of the existence of the given character. But I am still open to new ideas
-
I want to delete everything after a given character; e.g. wanna get the first word from this string by deleting everything after first occurrence of "-" $str="word1-word2-word3"; I use this trick to do so $str2=substr($str,0,strpos($str, '-')); This works perfectly, but the problem is when the string is just one word without the given character (i.e. "-"). It will return nothing for $str="word1";
-
Minimal vs. complete installation of php
etrader replied to etrader's topic in PHP Installation and Configuration
Thanks Doug, it is an important issue. I am interested to know what php modules (in addition to php-common) are really necessary. -
Following common tutorials, we usually install selected modules of php. I wonder why not installing all modules (e.g. as yum install php php-*). Are they really useless? We have lots of unused softwares on our servers; do these unnecessary php modules consumes lots of resources? On the other hand, I am curious to know what are the necessary modules of php for a normal usage? P.S. I think that we install most of php modules by php-common!
-
Thanks for sharing your idea
-
ACL is a advanced system for creating users and user permissions stored in mysql, right? I am talking about only one admin whose login can be stored in a file too. Do you still think that php-based ACL is the best solution?