PHP - Collecting Userids And Inserting Row For Them

Hi there, hope one of you can help me with a problem im just having.

Ok, lets start with the explanation what i want to to:
I'd like to collect headlines from a html site, and get the test results in an array, so that the array structure represents the dom-levels of the site.

Small Example:
<h1>test1.1<h1/>
<h2>test2.1</h2>
<h2>test2.2</h2>
<h3>test3</h3>
<h1>test1.2<h1/>
Shoul end in a array structure like:

Code: [Select]
array('level 1' => array (
            'sibble1' => array (
                'headline' => 'test1.1',
                'level2' => array(
                    'sibble1' => array (
                        'headline' => 'test2.1',
                        'level3' => array(), // empty data, needs to be processed anyway to find gaps, to maybe a h4 headline would be existing
                    ),
                    'sibble2' => array (
                        'headline' => 'test2.2',
                        'level3' => array (
                            'sibble1' => array (
                                'headline' => 'test3.1',
                                'level4' => array(), // empty data, needs to be processed anyway to find gaps, to maybe a h4 headline would be existing
                            ),
                        ),
                    ),
                ),
            ),
            'sibble2' => array (
                'headline' => 'test1.1',
                'level2' => array(),
             ),
        ),
);

So i hope out of this example you can see what i want to do. level represents the healdine level 1-9, sibblin is as name for the childs on the headline level.

Ok, so to extract the herefore needed data out of the html, i build a class with a recursive function, that filters the html by a regex from one headline to the next, first iteratin all childs, if there are no more childs i go tho ne nextsibbling element.

as an running example code look he

Code: [Select]
<?php

class Application_Model_DomParser {

    const PREG_MATCH_ONE_ELEMENT_TO_MUCH_LENGTH = 4;

    private $slicedFields = array();

    public function __construct() {
    }

    public function sliceFirstSectionToDataFields($level = 1, $haystack) {

        preg_match_all("#(.*?)<h$level>(.*?)</h$level>(.*?)(<h$level>|$)#s", $haystack, $data);

        // prepare the chunkData
        $pageText = '';
        if (isset($data[1][0])) {
            $pageText = $data[1][0];
        }
        $headline = '';
        if (isset($data[2][0])) {
            $headline = $data[2][0];
        }
        $dataToProcessNextLevel ='';
        if (isset($data[3][0])) {
            $dataToProcessNextLevel = $data[3][0];
        }
        // @todo dirty warnings compression, search why warning occures
        @$posOfNextChild = strlen($data[0][0]) - self::PREG_MATCH_ONE_ELEMENT_TO_MUCH_LENGTH;


// from here goes the debug...
echo $headline ."::" .strlen($dataToProcessNextLevel). "<br>";


        if (strlen($dataToProcessNextLevel) <= self::PREG_MATCH_ONE_ELEMENT_TO_MUCH_LENGTH) {
            if ($level < 9) {
                $dataToProcessNextLevel = $haystack;
            }
            else {
                return;
            }
        }
        //recursive check for next level in $dataToProcessNextLevel
        $nextLevel = $level + 1;
        $this->sliceFirstSectionToDataFields($nextLevel, $dataToProcessNextLevel);


        $haystack = substr($haystack, $posOfNextChild);
        // slized To The End
        if (self::PREG_MATCH_ONE_ELEMENT_TO_MUCH_LENGTH == strlen($haystack)) {
//            die("slized To The End");
            return;
        }

        // recursive check for other childs in actuall level...
        $this->sliceFirstSectionToDataFields($level, $haystack);
    }
}


$htmlString = 'test<h1>headkline1.1</h1>
<p>test test</p>
<h2>headline 2.1</h2>test test
<h2>headline 2.2</h2>
<p>tes test test</p>
<h3>headline 3.1</h3>test
<h3>headline 3.2</h3>test
<h2>headline 2.3</h2>
<p>&nbsp;</p>
<p>test</p>
<h1>headline 1.2</h1>
<h2>headline 2.4</h2>
<p>11111111111112222222222222222222222</p>
<p>&nbsp;ewfwrefg upowmdg w3q09umq09wrt n3q089ty 3q0898943ty -98 41</p>
<h3>headline 3.3</h3>
<p>test</p>
<p>test</p>
<p>test</p>
<h1>1.3 testtest</h1>
<p>test</p>
<h3>head 3.4</h3>
<p>sadfsadfsadf asdfsda f sdaas saf saddas</p>
<h3>head 3.4</h3>
<h3>test 1.3</h3>
<p>test;</p>
';

$model = new Application_Model_DomParser();
$result = $model->sliceFirstSectionToDataFields(1, $this->htmlString);


So letting this piece of code run, you can se via the debug echo, every headline is found, even in the right order of its occurence.

My problem now is dont get it how to return the extracted values, and collect them to get a result as my above shown structure shows.

So i spent ours to solve this problem but didnt come to a result.

I know its a hard problem, and to help me takes time, cause its a complex situation.

Allthough i hope someone knows a anser. I need this problem solved, to get my mind rested!

Thanks, and greetings
Selma

hi i'm trying to insert this text just "we're pleased to announce etc........ect"

but I can only insert "We" i believe its because single quotation mark. I've tried using addslashes, mysqli_real_escape_string and htmlspecialchars, strp_tags and applied it to my variable $s. But what ever i seem to try and insert still results in "we" being inserted. Cant see for the life of me why???

appreciate any help

if (isset($_POST['submitted'])) {

$errors = array();

if (empty($_POST['title'])) {
$errors[] = '<p class="error">Either you haven\'t filled in the title or story for this news</p>';
} else {
$t = mysqli_real_escape_string($dbc, $_POST['title']);
}
if (empty($_POST['story'])) {
$errors[] = '<p class="error">Either you haven\'t filled in the title or story for this news</p>';
} else {
$s = $_POST['story']; 
}
echo $s;

if(empty($errors)) { // No errors

$q = "INSERT INTO news (title, story, date_added) values ('$t', '$s', NOW() )";
$r = mysqli_query($dbc, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc)); 

if (mysqli_affected_rows == !1) { // It didnt run ok
$errors[] = '<p class="error">An error occured with your upload<a href="loggedin.php"> Admin</a></p>';
} else {
echo 'Your news story has been added, visit <a href="news.php">News</a>'; 
} //if mysqli_affected rows
} else {
echo '<p class="error">The following errors occured<br />';
foreach ($errors as $msg) {
echo " - $msg<br>";
}
echo 'Please try again';
} // end of $errors

} // End of submitted


This is my code i'm using :-)

as you an see i'm posting the variable $s which is    ($_POST['story'] with no functions and it still only inserts "we" nothing more?????

Code: [Select]
elseif($_GET['rma']=="issue"){
session_start();
$rma_id=$_GET['id'];
$_SESSION['rma_id']=$rma_id;
$rma_issued=$_POST['rma_issued'];
if($rma_issued=="y"){
$length = 2;
$characters = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ";
$string= microtime(true);
for ($p = 0; $p < $length; $p++) {
$string .= $characters[mt_rand(0, strlen($characters))];
}
for ($p = 0; $p < $length; $p++) {
$string2 .= $characters[mt_rand(0, strlen($characters))];
}
$string="".$string2."".$string;
$string=explode(".",$string);
$string=$string[0].$string[1];
$rma_number=$string;
date_default_timezone_set('US/Eastern');
$rma_date_issued = date("F j, Y, g:i A T");
$rma_month_issued = date("m");
$rma_year_issued = date("Y");

$sql2000000="UPDATE $tbl_name4 SET rma_number='$rma_number', rma_issued='$rma_issued', rma_date_issued='$rma_date_issued', rma_month_issued='$rma_month_issued', rma_year_issued='$rma_year_issued', returned='n' WHERE rma_id = $rma_id";
mysql_query($sql2000000);
header("Location: ./acp_admincp.php?rma=issued");
}

The above isn't inserting anything into the DB... not even the Date information.

How can I insert a url in the body of an mail such that when the user clicks on it return the url string

Hello guys, im wonder if ca i syntax the insert so i can  insert some fields with alphabeticly shorting by name field

Thanks

All the variables are set for sure, anyone have any clue why the following isnt inserting anything into the db?

Code: [Select]
        //### Query to insert new item into the database table "items"
$query = "INSERT INTO `items`(`name`,`image`,`description`,`description2`,`description3`,`ItemType`,`cash_price `,`credit_price `,`GrowAmount`,`SellAmount`,`MaxOff`,`MaxDef`,`MaxHoes`,`Attack`,`Defense`,`Prestige`,`SafeLimit`,`ProductionQuality`,`ProductionWeight`,`HoDrugUsage`,`HoIncome`,`PurchaseDiscount`,`Informants`,`Pimpness`,`SalesPrice`,`SalesWeight`,`TroopDiscount`,`NotoReq`,`SCReq`,`PRReq`,`Buyable`,`ClassSpecific`,`Sellable`,`Multiple`) VALUES('{$name}','{$image}','{$description}','{$description2}','{$description3}','{$ItemType}','{$price}','{$creditprice}','{$GrowAmount}','{$SellAmount}','{$MaxOff}','{$MaxDef}','{$MaxHoes}','{$Attack}','{$Defense}','{$Prestige}','{$SafeLimit}','{$ProductionQuality}','{$ProductionWeight}','{$HoDrugUsage}','{$HoIncome}','{$PurchaseDiscount}','{$Informants}','{$Pimpness}','{$SalesPrice}','{$TroopDiscount}','{$NotoReq}','{$SCReq}','{$PRReq}','{$Buyable}','{$ClassSpecific}','{$Sellable}','{$Multiple}'";

        //### Execute the above query
        mysql_query($query);

when i insert a new topic into the database its id is generated by the auto incrememnt field tid.
but what i do next is insert the post for that new topic in the post table which has p_pid(post id) and p_tid(the topic id it is for). so how do i generate that p_tid when the topic has just been inserted. i used to do it by inserting the topic then running a query to pull the newest topic if from the database which would mean the post belonged to that topic. but what happens when people are posting several topics at the same time?

Hey, Basically the script runs fine except for the fact its just inserting one user instead of multiple users, anyone have a clue as to why? would be a huge hand, Cheers

Code: [Select]
<?php
if (isset($_POST["submit"]) && $_POST["submit"] == "Recall Selected Informants")
{
//Force POST values to be INTs
$addIDs_ary = array_map('intval', $_POST['chkInv']);
//Remove any 'false' value
$addIDs_ary = array_filter($addIDs_ary);
//Check that there was at least one valid value
if(count($addIDs_ary))
{
//Create comma separated string of the IDs
$addIDs_str = implode(',', $addIDs_ary);
//Create and run one query to perform all the adds (of the user) 
$query = "INSERT INTO hitlist SET hit_id = '($addIDs_str)' AND player_id = '$playerID'";
$sql = "UPDATE players SET Informants = Informants - 1 WHERE id = '$playerID'";
mysql_query($sql) or die(mysql_error());
if(mysql_query($query))
{
$selectedCount = count($addIDs_ary);
$adddCount  = mysql_affected_rows();
echo "{$adddCount} of {$selectedCount} Investigated player(s) were successfully added.";
}else{
echo "There was a problem running the query.<br>" . mysql_error();
}
}else{
echo "Invalid ID data passed.";
}
}

I am still having issues with getting the second part of this function to work right. It inserts fine into the first table but after that it's not performing the second insert.

Code: [Select]
function sendMessage($recipients, $bcc, $subject, $message, $sender)
    {
        $data = array(
            'subject'    => $subject,
            'senderID' => $sender,
            'message' => $message
        );
       
        $this->db->insert('usersPersonalMessages', $data);
        $insertID = $this->db->insert_id();
       
        foreach ($recipients AS $recipient)
        {
            $recipientData = array(
               'usersPersonalMessagesID' => $insertID,
               'userID'    => $recipient
            );
        }
       
        if ($bcc)
        {
            foreach ($bcc AS $userID)
            {
                $recipientData['userID'] = $userID;
                $recipientData['bcc'] = 1;
            }
        }
       
        $this->db->insert('usersPersonalMessagesRecipients', $recipientData);
    }

Hi there reader(s)

I've been searching everywhere, and I'm not one to post my issue unless I've searched as hard as I could, I'm not new to PHP, but I am new to MySQL (so go easy on me) and I've got variables all set up, and I've successfully established connection to my Database and my Database's table, but now I cannot find a way to insert the data (variable) into a column of the table.

Willing to provide more information!

how do i insert two same values bearing variable into the same row though different column into a database? Insertion was successful but at the end I always end up getin an error for which I was not allowed a redirection...thanx


error:
Code: [Select]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') VALUES('spaceman12', 'ja')' at line 1

Im trying to choose what I want the id to be set to when I create a row on another table

using this code below it tells me "unknown column "id" in 'field list'
making me think it has to asign a random id first

Code: [Select]
<?php
$d1 = "SELECT id FROM game WHERE id='".mysql_real_escape_string($_SESSION['user_id'])."'";
$b1 = mysql_query($d1) or die(mysql_error());
$c1 = mysql_fetch_array($b1);

if (empty($c1['id'])) { 

$a1 = "INSERT INTO game SET id = '".$_SESSION['user_id']."'";


mysql_query($a1) or die(mysql_error()); ?>

Hi guys.....

I'm having a problem that I've been tearing my hair out over for way too long. I'm hoping that some of you may be able to help me or at least point me in the right direction.

I'm using MySQL 5.0.91 (via PHPmyAdmin from GoDaddy).

This query should basically grab the data from the Facebook API and insert it into the database. It's not doing that. After inserting the data, it queries the database, and redirects the user to their profile page (USERNAME.php). Because there is no data in the database for that user, it has no idea what their username is, so it redirects them to ".php"....yes, that is "[dot]php".

I'm not entirely sure how to debug this either. I've tried a few var_dump()'s with not much luck.

Is there a specific order in which this stuff needs to be in? Maybe that's the problem, so I'm also including a screenshot from PHPmyAdmin of the database table.

Here's the code:


// user not in db, insert details
if(!empty($user)){
         $apiGet = array(
         'method' => 'users.getinfo',
                'uids' => $uid,
                'fields' => 'uid, name, first_name, last_name, pic_square, pic_big, sex, email, birthday_date, activities, interests, status, about_me' //theses are the fields it pulls from the Facebook API
                 );                                                                                                            
         // create array to hold returned values
         $fbi = $facebook->api($apiGet);
// insert details
$iString = "oauth_provider, oauth_uid, username, name, first_name, last_name, sex, pic_big, email, joined, lastLogon, birthday_date, user_activities, user_interests, user_status, user_about_me";

$iArray = array(); //the following are the values of the fields
array_push($iArray,'facebook');
array_push($iArray,$user['id']);
array_push($iArray,$user['name']);
array_push($iArray,$fbi[0]['name']);
array_push($iArray,$fbi[0]['first_name']);
array_push($iArray,$fbi[0]['last_name']);
array_push($iArray,$fbi[0]['sex']);
array_push($iArray,$fbi[0]['pic_big']);
array_push($iArray,$fbi[0]['email']);
array_push($iArray,time());
array_push($iArray,time());
array_push($iArray,$fbi[0]['birthday_date']);
array_push($iArray,$fbi[0]['user_activities']);
array_push($iArray,$fbi[0]['user_interests']);
array_push($iArray,$fbi[0]['user_status']);
array_push($iArray,$fbi[0]['user_about_me']);
var_dump($email);
$db->insert('users',$iArray,$iString);
$where = "oauth_uid = '{$uid}'";
$db->select('*','users',$where);
$result = $db->getResult();
                  // the next line creates a profile page. After that, there are lines that point the user to that page.
                  createProfile($result['username']);


I've added some comments to it to articulate what is going on.

Thanks in advance!
Alex

Hi All,

When inserting data into a DB I get a current timestamp using GETDATE() - however, I would like to insert a date that is say 3 working day's from the time the record was inserted.

Is this possible? If so, how would I go about it?

Thanks
Matt