Hi,
This is my first article and so please provide comments on it (good or bad).
The design of the database is one of the most important factors in the performance of the database and with a good database design you also need optimal queries to perform optimally. Everyone wants the performance...
...i need it to work with out them having to contact there administrators asking them to allow mysqli
$mysqli = new mysqli("localhost", "desvisa_v", "******", "desvisa_site");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error())...
...while($row = mysql_fetch_array($result))
{
$text = $row['entrytext']; //CHANGE VARIABLE
}
$sql = "SELECT * FROM pranks WHERE pranksentry LIKE '%$text%' ORDER BY id DESC"; //GET PRANKS SIMILAR to TEXT
$result5 = mysql_query($sql);
while($row =...
Hello,
Going to try to explain this as best I can. I have a bunch of stuff in a database and I need to display this info within a table. This isn't a problem at all but, I need it to only display 3 td tags per line and then move on to the row.
so i need it to do :
code:
<table>
<tr>
<td>My...
Hi,
Now we can create our upload.php file. To start we'll check that the file upload is safe by setting a list of allowed filetypes and disallowing all other file uploads. This will prevent people from uploading malicious files. Then we will check the filesize to prevent large files from being...
Hello,
cURL and libcurl
wget http://curl.haxx.se/download/curl-7.16.0.tar.gz
tar -pxzf curl-7.16.0.tar.gz
cd curl-7.16.0
./configure --with-ssl
make
make install
ldconfig -v
Then use --with-curl in PHP's configure
For use with Perl use
libcurl - the Perl Binding
wget...
Hi,
You need to add the following lines to httpd.conf (If you're using Apache for Win32)
ScriptAlias /php/" c:/path-to-php-dir/"
AddType application/x-httpd-php .php
Action application/x-httpd-php "/php/php.exe"
Then restart Apache and it should interpret php files correctly.
For more...
...error.
When selecting on the search button bottom left I end up with the following message:
"Error en la Base de Datos al ejecutar
select * from fichas where
tipo=''
and precio>= and precio<= and terretam <= and casatam <= order by puntos descYou have an error in your SQL syntax...
Hello,
Webpages are written in HTML - a simple scripting language.
HTML is short for HyperText Markup Language.
* Hypertext is simply a piece of text that works as a link.
* Markup Language is a way of writing layout information within documents.
Basically an HTML document is a...
Hi,
Images can be used to make your Web pages distinctive and greatly help to get your message across. The simple way to add an image is using the <img> tag. Let's assume you have an image file called "peter.jpg" in the same folder/directory as your HTML file. It is 200 pixels wide by 150 pixels...
Hi,
If you have used Microsoft Word, you will be familiar with the built in styles for headings of differing importance. In HTML there are six levels of headings. H1 is the most important, H2 is slightly less important, and so on down to H6, the least important.
Here is how to add an important...
Hello,
Every HTML document needs a title. Here is what you need to type:
<title>My first HTML document</title>
Change the text from "My first HTML document" to suit your own needs. The title text is preceded by the start tag <title> and ends with the matching end tag </title>. The...
...formatted as plain text. For TextEdit, you can set this with the "Format" menu's "Make Plain Text" option.
This page will teach you how to:
* start with a title
* add headings and paragraphs
* add emphasis to your text
* add images
* add links to other pages
* use...
...manually, without the assistance of your hosts control panel, then run SSH to your web server and do the following (taken from MySql.com):
* mysqldump --tab=/path/to/some/dir --opt db_name
If you were to open up a MySQL dump file you would see a slew of SQL queries that you would...
Hi,
Beside creating index you can also removing index by using DROP INDEX statement in MySQL. Interestingly, DROP INDEX statement is also mapped to ALTER TABLE statement. Here is the syntax:
DROP INDEX index_name ON table_name
Hi,
PHP is an HTML-embedded scripting language. Much of its syntax is borrowed from C, Java and Perl with a couple of unique PHP-specific features thrown in. The goal of the language is to allow web developers to write dynamically generated pages quickly.
When http request arrive to your...
Hi,
PHP scripting language have an built in function to change between the timezones , you will need the PEAR package . In the following example show you how to convert from GMT system format to IST Format .
<?php
// include class
include ("Date.php");
// initialize object
$d = new...
Hi,
Going to try to explain this as best I can. I have a bunch of stuff in a database and I need to display this info within a table. This isn't a problem at all but, I need it to only display 3 td tags per line and then move on to the row.
so i need it to do :
code:
<table>
<tr>
<td>My First...
...| RTREE]
ON table_name (column_name [(length)] [ASC | DESC],...)
First you specify the index based on the table types or storage engine:
* UNIQUE means MySQL will create a constraint that all values in the index must be distinct. Duplicated NULL is allowed in all storage engine except...
...name="Submit" id="Submit" value="Submit" />
</p>
</form>
Here is the insert1.php file
<?php
$con = mysql_connect("localhost","Application","*******");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("CpaApp", $con);
//Assign each array to a variable...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.
Attention: "role based name" email prefixes such as support, webmaster, info, contact, forum, service, affiliate, admin, traffic, partners, marketing, etc., for our member accounts are not permitted. They are acceptable for a vendor listing, but not for the member email. This is due to bulk email processors scrubbing them for delivery due to extremely high bounce rates. Please apply for membership using a personalized email prefix. Something like bob@xxxxx.com.
If we discover you signed up with a role based name we will give you only one message to change it. After 3 days your account will be removed if the email is not changed.