[mysql if statement]

I don't understand, it's quite confusing for me...

[Trying to automatically detect and parse encoding or content type from e-mails]

Please write some code here.

[How to text a phone number in database]

Can you post your code here.

[need to store a database variable in a php variable]

after an update query, use select query

 

list($copies)= mysql_fetchrow(mysql_query("select copies FROM book where bookid='$bookid'"));

 

[stripslashes problem]

Whenever you assign a value to a variable, at that time apply mysql_real_escape_string() filter.

 

like $artist = mysql_real_escape_string($_POST['artist']);

$song = mysql_real_escape_string($_POST['song'])

etc...

[Alternative for Curl?]

hi, can you please post you CURL code which you used for image fetching.

[Suggestions for PHP Dynamic Form Handling]

Hello,

during dynamic create of form value, in for loop write a below code

 

<input type="hidden" name="dynamic_value[]" value="$value[$i]">

 

So, you get those values in the form submit page.

 

* you haven't write action in form open tag and your submit works properly, there are no changes required.

 

let me know any error you get.

[Database table to be incorporated into HTML form value=""]

sorry, but I don't understand your question 

[stripslashes problem]

$sql = "UPDATE $table_name SETartist = '".mysql_real_escape_string($artist)."',song = '".mysql_real_escape_string($song)."',quote = '".mysql_real_escape_string($quote)."' WHERE quoteid =  ".mysql_real_escape_string($_REQUEST['quoteid'])."";

[simple # question]

for more internal link info, visit http://www.w3schools.com/html/html_links.asp

[Any proper methods for multiple INSERT command?]

It is not possible with two different tables. for single table you can do that

 

$query = "INSERT INTO practice_user (name, email, password, dob, category, comments) VALUES ('$name', '$email', '$password', '$dob', '$category', '$comments'), ('$name', '$email', '$password', '$dob', '$category', '$comments'), ('$name', '$email', '$password', '$dob', '$category', '$comments'), ('$name', '$email', '$password', '$dob', '$category', '$comments'), ('$name', '$email', '$password', '$dob', '$category', '$comments')";

 

  $result = mysqli_query($dbc, $query)

 

 

[Fetching data with links]

Hey  monsure,

 

You should create one dedicated page of book_details.php and whenever you display overview page with title and author give a link to that particular page, see below code

 

while($rows = mysql_fetch_assoc($result))
{

echo "-Title: <a href='book_details.php?id=".$rows['id']."'>" . $rows['title'] . "</a><br/>" . "-Author: " . $rows['author'] . "<br />";
}

On book_details.php page fetch a bookdetails from $_GET['id'] variable.

 

Query should be

 

$sql = "select * from book where title_id =".$_GET['id']

 

[stripslashes problem]

I think, htmlentities() also helps to resolve this problem.

[Mobile advice]

hello comman, you don't need to create another domain but make sure that hosting provider is support for subdomains!

[Mobile advice]

in your case, you can use subdomain, one for pc and other for mobile.

for mobile you can design your website to support for all device.

[Error]

Hey, can you paste your code here for better understand your problem.

[Multiple Queries]

try below code,

$sql = "INSERT INTO `data` (`info`, `write`, `date`) VALUES";     for ($c=0; $c < $num; $c++) {             $sql.= "(";             $sql.= '"'.str_replace('"', "", $data[$c]).'",';             $sql.= "'".date('Y-m-d')."');";        }echo $sql;mysql_query($sql);

 

 

your code will generate the query which you can execute once only.

[Signup works - Login doesnt]

I am eager to know from where you set these two variables

$userid and $password, I can't see any $_POST, $_GET or $_REQUEST.

 

$userid=mysql_real_escape_string($userid);

$password=mysql_real_escape_string($password);

[Lots of Exploding]

If I understand you properly then you can implement like this

$query = mysql_query("SELECT * FROM table_name");

while($row = mysql_fetch_array($query))

{

// you can apply explode here on each row data like name and school

 

$name_arr = explode("-",$row["name"]);

$school_arr = explode("-",$row["school"]);

 

}

 

I hope above code helps you.

 

[File Uploads]

is the  "Members/$id/".$newname $id folder is available on server?

If not then create it first and give 777 permission to upload files.

[automatically sending sms]

Hey Tarun,

I think you should make scheduler to send SMS automatically from server.

cronjob will help to make it possible.

[php Novice struggling to read in a file... ;/]

try to use HTML entities while you are displaying on the screen.

 

Result  Description  Entity Name 

<         less than <            

>         greater than >

&         ampersand &

 

[eCommerce Opion Question]

best one is osCommerce, OSC has good community support.

 

You can use wordpress e-store plugin

 

Cubecart is also good option.

[PHP security checklist]

Find checklist below.

 

1. SQL Injections

2. Stop Using $_REQUEST

3. Don't save plain text Password Cookies

4. register_globals = Off

 

for more details visit http://www.kavoir.com/2010/03/php-security-checklist-for-websites-and-web-applications-bottom-line-for-every-good-php-developers.html

 

[enable to fix the errors could someone have a look]

use this string

 

echo "<img src='http://www.google.com".$current[0]->icon['data']."' alt='weather'>";