Posts

Showing posts with the label Mysql

Foreign language characters in my mysql Data Base?

Foreign language characters in my mysql Data Base? Is the connection to the database also UTF-8 encoded? Give this a try: right after connecting to the mysql database, run the following query. SET NAMES utf8; Great! It worked wonderfully! I added $conn->query('SET NAMES utf8'); Thanks again! mysql_query("SET NAMES utf8"); [Google Ads]
Read more

Joint two table query

$t_query="select a.id,a.memberid as memberid,a.commission,a.calmemberleft ,a.calmemberright,a.totalmembers,a.totalbalance, a.previousreleased,a.presentcommission,a.totalreleased,a.tleftmembers,a.trightmembers,a.date,b.id as mid,b.block,b.username,b.city,b.ledgerid,b.referid,b.emailid from ".COMMISSION1." a , ".MEMBER." b where (a.memberid=b.ledgerid and b.block='') order by a.id desc";
Read more

JOIN QUERY

SELECT art_hview_id, views FROM highsoup WHERE views = (select MAX(views) from highsoup);
Read more

Addslashes

Error 1: in mysql db we cant fetch the record by value while using 'type =tEXT' and also addslashes it is better to use varchar or mediumtext
Read more

Database connect

function tep_db_connect($server = DB_SERVER, $username = DB_SERVER_USERNAME, $password = DB_SERVER_PASSWORD, $database = DB_DATABASE, $link = 'db_link') { global $$link; if (USE_PCONNECT == 'true') { $$link = mysql_pconnect($server, $username, $password); } else { $$link = mysql_connect($server, $username, $password); } if ($$link) mysql_select_db($database); return $$link; }
Read more

POPULAR POSTS ::

JOIN QUERY

SELECT art_hview_id, views FROM highsoup WHERE views = (select MAX(views) from highsoup);
Read more

Add multiple upload box

Image
include_once("includes/header.php"); if(isset($_REQUEST['submit'])){ $c1 = rand(0,9);$c2 = rand(0,9);$c3 = rand(0,9);$c4 = rand(0,9); $rand = $c1.$c2.$c3.$c4; for($i=0;$i { if($_FILES['upload_photo']['name'][$i]!="") { $dir_path = $res.$rand.$_FILES['upload_photo']['name'][$i]; $dir_path1.= $res.$rand.$_FILES['upload_photo']['name'][$i].","; } if(move_uploaded_file($_FILES['upload_photo']['tmp_name'][$i],'upload/'.$dir_path)) { } } $insert_upload="insert into ".MY_UPLOADS." set `userid`='".$_SESSION['USERID']."',`files`='$dir_path1',`date`='".date("Y-m-d h:m:s")."'"; $out_upload=mysql_query($insert_upload); $MSG="File uploaded successfully !..It will be posted after admin review!"; echo " "; } ?> ...
Read more

HTML and PHP INTRODUCTION

Image
HTML and PHP INTRODUCTION PHP is a scripting languag e originally designed for producing dynamic web pages. It has evolved to include a command line interface capability and can be used in standalone graphical applications. PHP is a widely-used general-purpose scripting language that is especially suited for web development and can be embedded into HTML. [Google Ads] While PHP was originally created by Rasmus Lerdorf in 1995 , the main implementation of PHP is now produced by The PHP Group and serves as the de facto standard for PHP as there is no formal specification. PHP is free software released under the PHP License, however it is incompatible with the GNU General Public License (GPL), due to restrictions on the usage of the term PHP. It generally runs on a web server, which is configured to take PHP code as input and create web page content as output. It can be deployed on most web servers and on almost every operating system and platform free of charge. ...
Read more

The top Web development PHP frameworks

Image
The top Web development PHP frameworks : A good framework can help you develop a PHP application quickly, with more simplicity, and with a vision of 'best-practices-oriented'. Examine this list of 9 great PHP frameworks and provide your preference or a new link to a framework not included in this list. 1. Laravel PHP Framework   Regardless of your level of experience with PHP web frameworks, Laravel is a framework that can adapt to your needs.   Laravel's web application framework is both expressive and elegant in its syntax. This framework has a starting point that allows you to concentrate on creating something amazing while we handle the details.   Laravel is committed to providing an incredible developer experience by offering powerful features like thorough dependency injection, an expressive database abstraction layer, queues and scheduled jobs, unit and integration testing, and more.   It is a popular choice for building rich web applications due to its restfu...
Read more

Mobile App Development Trends: Emerging Technologies and Innovations

Image
Mobile App Development Trends: Emerging Technologies and Innovations Mobile application development full analysis 2024:   To become a mobile app developer , Here is the detailed analysis of Unlocking Mobile Potential: Comprehensive App Development Analysis to guide you.   The act of creating, developing, testing, and deploying software applications for mobile devices, such as smartphones and tablets, is known as mobile application development. These software applications are designed to run on mobile devices and take into account multiple hardware constraints. CPU architecture and speeds, available memory (RAM), limited data storage capacities, and considerable variations in displays and input methods are some of the common constraints.   Facebook, YouTube, Google Play, Google Search, Google Maps, Gmail, Instagram, and Apple Maps are some of the most popular mobile apps.   [Google Ads] App Development Insights: Strategies, Trends, and Best Practices The crea...
Read more

String Separation

str_replace function str_replace is a string function that replaces occurrences of a substring with another substring. Syntax : str_replace(find, replace, string, count) Parameters: -find: The substring to search for. -replace: The substring to replace with. -string: The original string. -count(optional): The number of replacements made. Example: $string = "Hello, welcome world!"; $new_string = str_replace("world", "universe", $string); echo $new_string; // Output: "Hello, universe!" strlen() fnction is a PHP function that returns the length of a string. Syntax: strlen(string) Parameter: -string: The input string Return Value: The length of the string (integer). Example: $string = "Hello, World!"; $length = strlen($string); echo $length; // Output: 13 [Google Ads]   PHP->IMAGE UPLOAD : (UPLOAD IMAGES using Move upload function) $image_file1 = $_FILES['file']['name']; $c1 = ran...
Read more