[Updating meta value in database mysql]

I get this error: Error updating record: Table 'wordpress_i12dhflgoa.postmeta' doesn't exist

 

Here is the code I am using:

$sql="update `wp_pzvy_postmeta` set meta_value = '10' where meta_key = '_price' AND post_id=(select post_id from postmeta where meta_key = '_sku' and meta_value = 'GF-1370')";

[Updating meta value in database mysql]

The thing is that I am doing this out of wordpress, it is a separate script running in the server.

Hey,

Thank you very much for all your help, I will try this out this afternoon and let you know if everything works ok.

[Updating meta value in database mysql]

How can I get the post_Id based on the meta_value? In this case meta_value is GF-1370?

Thank you

[Updating meta value in database mysql]

This is the table from myphpadmin. It looks like it got reformatted when I originally posted.

 

meta_id        post_id         meta_key                meta_value

18538            4356             _sku                          GF-1370

18541            4356             _price                        2.343

[Updating meta value in database mysql]

Hi,

I changed the code a bit and tried to execute it and I am getting this error: Error updating record: Unknown column '_sku' in 'where clause'

Here is the code

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
 $sql="update `wp_pzvy_postmeta` set `_price` = 5 WHERE `_sku` = 'GF-1370'";

if (mysqli_query($conn, $sql)) {
    echo "Record updated successfully";
} else {
    echo "Error updating record: " . mysqli_error($conn);
}
mysqli_close($conn);

[Updating meta value in database mysql]

Hi guys,

I have a problem with my code.

It connects with the database but it doesn't execute anything.

I am trying to update a value in a table but I really don't know what I am doing wrong.

I am trying to change the price based on the meta_value GF-1370

Thank you very much.

 

Here is Table (Taken from myphpadmin)

meta_id  post_id  meta_key  meta_value

18538 4356 _sku GF-1370 18541 4356 _price 2.343

 

and here is my code:

 <?php 
$link = mysql_connect('server', 'username', 'password'); 
if (!$link) { 
    die('Could not connect: ' . mysql_error()); 
} 
echo 'Connected successfully'; 
mysql_select_db(wordpress_i12dhflgoa);
$sql="update `wp_pzvy_postmeta` set `_price` = 5 WHERE `_sku` = 'GF-1370'";
?>  

[Changing a value on table]

I just fix it. Thank you guys.

$result = mysql_query("UPDATE wp_usermeta SET meta_value='0' WHERE meta_key = 'wp_s2member_login_counter';")

[Changing a value on table]

Hi guys,

I know a little bit of PHP but I am very new to mysql.

How do I change the value (meta_value) of all the wp_s2member_login_counter in this table (wp_usermeta) using php?

Thank you very much!

This is what I got so far:

<?php
// Connect to MySQL
$link = mysql_connect('mywebsite.com', 'wrd6rEDgggy', 'password');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_select_db(wrd_47io4f3a6l);

$result = mysql_query("UPDATE wp_usermeta SET wp_s2member_login_counter='0'")
or die(mysql_error());  

?>

[Reading Txt Files From Bat File]

Hi guys,

I managed to write this script to open a link in internet explorer close it and open another one.

I would like to have all my links in a different txt files with multiple links line by line and be able to do the same function reading it from the bat file

 

I will appreciate anybody that can help me with this.

This is the bat file I made which works great. It opens these two llinks one at a time and do some stuff.

 

@echo off

start /MIN iexplore.exe www.website1.com

ping 192.178.1.1 -w 1

ping 192.178.1.1 -w 1

ping 192.178.1.1 -w 1

ping 192.178.1.1 -w 1

ping 192.178.1.1 -w 1

ping 192.178.1.1 -w 1

ping 192.178.1.1 -w 1

tskill iexplore /A

RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 255

start /MIN iexplore.exe www.website2.com

ping 192.178.1.1 -w 1

ping 192.178.1.1 -w 1

ping 192.178.1.1 -w 1

ping 192.178.1.1 -w 1

ping 192.178.1.1 -w 1

ping 192.178.1.1 -w 1

ping 192.178.1.1 -w 1

ping 192.178.1.1 -w 1

ping 192.178.1.1 -w 1

tskill iexplore /A

RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 255

 

Thank you very much

[redirectmatch question]

Requinix,

I used this

RedirectMatch (example-)*\.html$ http://www.example.com$1.html

 

And the output was:

www.example.com.html

 

At least it is recognizing the beginning of all my urls but I am missing something.

[redirectmatch question]

How can I do it with redirect match?

Thank you

 

[redirectmatch question]

The .htaccess and the files are in the same folder.

I know the htaccess is working because all the lines above and below that are doing what they suppose to do.

[redirectmatch question]

Nope, didn't work

[redirectmatch question]

Requinix,

Thank you for the quick response, however for some reason this is not working for me. (it doesn't redirect)

this is my htaccess code

 

Options +FollowSymLinks

RewriteEngine On

RewriteCond %{HTTP_HOST} ^example\.com$ [NC]

RewriteRule ^(.*)$ http://www.example.com/$1 [R=301,L]

RewriteEngine on

RewriteRule ^example-(\d+)\.html$ /$1.html [L,R]

addtype application/x-httpd-php .html

AddHandler x-httpd-php .html

AddType application/x-shockwave-flash .swf

[redirectmatch question]

Hi guys,

 

I have several urls that I would like to redirect using one line in my .htaccess

 

example:

 

http://www.example.com/example-1.html  redirect to http://www.example.com/1.html

 

I just pretty much want to take out the beguining (example-) of multiple urls

 

Thank you very much.

[preg_match question]

Got it thanks

[preg_match question]

Psycho,

I am sorry to bother you.

How can I extract this text using preg_match_all? Where Read all reviews from  is the beguining and ') is the end?  'Read all reviews from text-to-extract')

I having trouble with the delimiters.

 

This is what I got so far: preg_match_all("#Read all reviews from \('([^']')*)#", $text, $matches);

 

but is not working.

 

Thank you very much.

[preg_match question]

Thank you Psycho, it worked great.

[preg_match question]

Hi guys,

I hope you guys are having a terrific day.

I am trying to get some data from a page using preg_match an place it in an array.

 

This is the PHP code I got so far:

 

<?php

$url = "http://www.examplepage.html";

$raw = file_get_contents($url);

preg_match("/<ul class='Codes'>(.*)<\/ul>/isU",$raw,$output);

echo $output[1];

?>

 

I am able to read all text between <ul class='Codes'></ul> which is the one I am showing below.

 

Result from PHP code above:

 

<li><script type='text/javascript'>Code.number('4.236173.USD.EN.057880560561287921.386595955', '')</script><img src='/Images/providers/logos/Logo1.gif?cdn=040309' alt='' /> <script type='text/javascript'>Code.number('4.236173.USD.EN.057880560561287921.386595955', 'Read all codes from Number1')</script></li><li><script type='text/javascript'>Code.number('4.1957403.USD.EN.057880560561287921.458090474', '')</script><img src='/Images/providers/logos/logo2.gif?cdn=040309' alt='' /> <script type='text/javascript'>Code.number('4.1957403.USD.EN.057880560561287921.458090474', 'Read all codes from Number2')</script></li><li><script type='text/javascript'>Code.number('4.4801652.USD.EN.057880560561287921.1469771421', '')</script><img src='/Images/providers/logos/Logo6.gif?cdn=040309' alt='' /> <script type='text/javascript'>Code.number('4.4801652.USD.EN.057880560561287921.1469771421', 'Read all codes from Number3')</script></li>

 

 

 

This is what I would like to do:

 

Count how many times Code.Number happens.

and then for each of then capture and place in array the code number between the ' '. (the first example will be 4.236173.USD.EN.057880560561287921.386595955) and so on.

 

Code Numer 0,1 = 4.236173.USD.EN.057880560561287921.386595955

Code number 0,2= Logo1.gif

 

Code number 1,1 = 4.1957403.USD.EN.057880560561287921.458090474

code number 1,2=Logo2.gif

 

and so on.

 

Thank you very much.

[form alt or title tag not working inside frame in ie]

The title tag works fine in Firefox, but the alt tag or title tag doesn't work in ie.

 

This is my iframe in file1.html

 

<iframe src="file1.php" frameborder="0" scrolling="no" width="560" height="390" marginheight="0px" marginwidth="0px"></iframe>

 

and this is the form inside file1.php

 

<form action="file2.php" method="get">

input type="submit" name="button" id="button" value="Results" alt="bla bla bla" Title="See bla bla bla"  />

  </form>

Thank you for your help!

[Extracting data from csv to a 2d array]

Hey sasa,

How do I compare and sort this array?

I am adding a new value at the end of the arrays like this

$colors[$i][repeat]=$x;

After I added the value I would like to compare and sort the array base on that value

I have something like this so far and it is not working:

function compare($x, $y)

{

if ( $colors[repeat] == $colors[repeat] )

  return 0;

else if ( $colors[repeat] < $colors[repeat] )

return -1;

else

  return 1;

}

 

uasort($colors, 'compare');

print_r($colors);

 

[Extracting data from csv to a 2d array]

Great, that's exactly what I was looking for.

one more question: how do I echo does values without getting Array ( [0] (blue [1] => 0 [2] => 2 [3] => 2 [4])  etc etc

 

I would like to print is just like this blue1234

Thanks

[Extracting data from csv to a 2d array]

I extracted the data fine with fgetcsv() function, the problem I am having is adding the values to the array so I can use them anyway I want.

[Extracting data from csv to a 2d array]

Hi guys,

This is my problem:

I have a csv file let's say have these values:

 

blue,1,2,3,4

red,8,5,6,7

 

I need to add thes values into a 2d array

to be able to use like this:

colors[1][2]=2

colors[2][4]=7

 

Where my first number is the row and the second number is the value within that row.

 

This is what I got so far

 

<?PHP

$i=0;

$j=0;

$file_handle = fopen("color-list.csv", "r");

while (!feof($file_handle) )

{

$colors = fgetcsv($file_handle, 10000);

 

for ($j=0; $j<=4; $j++)

{

$row[$i][$j]=$colors[$j];

                                        print row[$i][$j];

}

$i++;

?>

 

For some reason this doesn't work. Maybe I am declaring the arrays wrong.

 

Thank you!

[Getting error with fseek]

All I want is to be able to read a file until I find a word.

This is the code I wrote:

 

<?php

$word="blah";

$i=0;

$myFile = "http://www.example.com/file.txt";

$handle = fopen($myFile, 'r');

while($Data<>$word)

{

fseek($handle, $i+1);

$i=$i+1;

$Data = fread($handle, 4);

}

if ($Data = $word) echo $Data;

fclose($handle);

?>

 

And this is the error I am getting: "Warning: fseek() [function.fseek]: stream does not support seeking in ...." I keep getting this error repeatedly until it finds the word and print it.