Posts by Pedro Piloto • 441 points
15 posts
-
2
votes1
answer77
viewsQ: Extract data with bitshift and bitwise operators
Good, I’m having some trouble separating the date parts through bitwise operations. date format: yyyy-dd-mm int menor_data(int date1, int date2) { int day1 = (date1 >> 8) & 0xff; int…
-
0
votes1
answer494
viewsQ: url from the root of the site
Good afternoon, I would like to clear up a question I have for some time in PHP. For example, in this case, I have the site’s translation system, but it only works for the directory in which it is,…
-
0
votes1
answer29
viewsQ: Friendly urls, back to the directory
Good afternoon, I have a doubt, I implemented friendly urls for a page of my website. This way, RewriteEngine ON RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %(REQUEST_FILENAME} !-d RewriteRule…
-
3
votes2
answers1007
viewsQ: Multi-language system
I have a website and I would like to implement a multi-language system. I have some questions about good practice. I wish I had just one domain ****.com. I think this would require me to use systems…
-
1
votes0
answers45
viewsQ: Event Scheduler cannot be activated
I have a website and created a simple ad expiration system through an SQL event, which runs from a given time and changes the ad state if this field dataexpiracao has been exceeded. This works well…
-
2
votes1
answer129
viewsQ: Mysql Event Scheduler needs super privileges
Good morning, I have a website hosting in a company, I have created a very simple system that through an event that runs a certain time in a certain time and makes changes in the elements of the…
-
6
votes2
answers672
viewsQ: Microsoft Azure to host website?
I have a question, I have a domain and an accommodation requested from a normal company. I have heard of Microsoft Azure that works through cloud. Could you explain to me how this works for a…
-
6
votes3
answers714
viewsQ: Can the + symbol on a website name affect searches?
Good evening, I have a site that has in the name the symbol +, this can affect the searches in Google, it will be better to put in the name of the site ... More?
seoasked Pedro Piloto 441 -
1
votes1
answer269
viewsQ: Login with facebook
I have a question regarding login through Facebook. I have a database with a users table and I have a normal registration and login system, but I wanted to implement the login system through…
-
3
votes1
answer222
viewsQ: What is the best practice to restrict access to the website’s administration system?
I wanted to create an administration system for the site, I did so so that users have associated with you a level field and if this is a given value they can access administrator control, otherwise…
-
2
votes2
answers1832
viewsQ: Mysql Automatically Change Data
Good afternoon, I wanted to implement a system that would make my database automatically, change the value of one of the fields of an element when the expiration date field was higher than the…
-
1
votes1
answer591
viewsQ: Chat youtube url system for embed
Good afternoon, I’m trying to create a system, where I receive a youtube url in a form, convert it to embed and save it in a database. This is a classified site, I do not know if this is the best…
-
5
votes2
answers33357
viewsQ: How to get the current date in Mysql?
I intend to create an event so that every hour will see if the expiration date of the announcement is higher than the current date, in this case it will have to change a theme of this announcement…
mysqlasked Pedro Piloto 441 -
1
votes1
answer255
viewsQ: Equivalent of mysql_result in PDO
I’m trying to move from mysql to Pdo but do not understand how to step that mysql_result to Pdo, I appreciate any help made available $limite = 10; $SQL_COUNT = mysql_query("SElECT COUNT('id') FROM…
-
1
votes0
answers23
viewsQ: Do I need to generate separate pages for each ad to have a URL without parameters?
I’m developing a classified site. For each record in the database it is necessary to generate a page for the ad in question, as on the normal classified sites. I made a generic page that if I…