function addTimesLoaded($theRes, $sqlconn) { $mixids = array(); $mixnames = array(); $owners = array(); $published = array(); $mixesLoaded = array(); $theRes = new SimpleXMLElement($theRes); foreach ($theRes->children() as $header) { foreach ($header->children() as $child) { if ($child->getName() == 'mixid') { $mixids[] = $child; $mixesLoaded[] = getMixesLoadedCount($child, $sqlconn); } if ($child->getName() == 'mixname') { $mixnames[] = $child; } if ($child->getName() == 'owner') { $owners[] = $child; } if ($child->getName() == 'published') { $published[] = $child; } } } $table = 'Mixes'; $args = array('mixid' => $mixids, 'mixname' => $mixnames, 'owner' => $owners, 'published' => $published, 'mixesLoaded' => $mixesLoaded); $xml = createXML($table, $args); return $xml; }
function getPassword($fEmail, $sqlconn) { $table = 'UserInfo'; $queryType = 'Select'; $condition = array('Email', $fEmail, 'text'); $types = array('text'); $columns = array('Password'); $values = array(null); $args = array('column' => $columns, 'value' => $values, 'type' => $types); $xml = createXML($table, $args); $res = $sqlconn->query($xml, $queryType, $condition); $thepassword = getValue($res); if ($thepassword == '') { echo 'Account does not exist'; } else { $mail = new PHPMailer(true); //New instance, with exceptions enabled $body = "Password: "******"\r\nReturn to site: http://www.you-mix.com"; $body = preg_replace('/\\\\/', '', $body); //Strip backslashes $mail->IsSMTP(); // telling the class to use SMTP //$mail->Host = "mail.you-mix.com"; // SMTP server $mail->Host = "smtp.sendgrid.net"; //$mail->Host = "smtp.mail.me.com"; // SMTP server $mail->SMTPDebug = 1; // enables SMTP debug information (for testing) // 1 = errors and messages // 2 = messages only // tell the class to use SMTP $mail->SMTPAuth = true; // enable SMTP authentication $mail->Port = 25; // set the SMTP server port //$mail->Port = 587; // set the SMTP server port $mail->Username = "******"; // SMTP server username //$mail->Username = "******"; // SMTP server username $config = new config(); $mail->Password = $config->getSMTPPass(); // SMTP server password $mail->AddReplyTo("*****@*****.**", "YouMix"); $mail->From = "*****@*****.**"; $mail->FromName = "YouMix"; //$to = "*****@*****.**"; $mail->AddAddress($fEmail); $mail->Subject = "you-mix.com: Password retrieval"; $mail->AltBody = "To view the message, please use an HTML compatible email viewer!"; // optional, comment out and test $mail->WordWrap = 80; // set word wrap $mail->MsgHTML($body); $mail->IsHTML(true); // send as HTML $mail->Send(); echo 'Password has been sent.'; } }
function getPublishedValue($sqlconn, $theMixName) { $table = 'Mixes'; $queryType = 'Select'; $condition = array('MixName', $theMixName, 'text'); $types = array('text'); $columns = array('Published'); $values = array(null); $args = array('column' => $columns, 'value' => $values, 'type' => $types); $xml = createXML($table, $args); $res = $sqlconn->query($xml, $queryType, $condition); $publishedValue = getValue($res); return $publishedValue; }
function getMix($sqlconn, $theMixId) { $table = 'Mixes'; $queryType = 'Select'; $condition = array('MixId', $theMixId, 'text'); $types = array('text'); $columns = array('MixName'); $values = array(null); $args = array('column' => $columns, 'value' => $values, 'type' => $types); $xml = createXML($table, $args); $res = $sqlconn->query($xml, $queryType, $condition); $mixName = getValue($res); if ($mixName == '') { $mixName = 'Mix not found'; } return $mixName; }
function getSongs($songsMixTitle, $sqlconn) { $songs = array(); $startTimes = array(); $songsMixTitle = str_replace("'", "\\'", $songsMixTitle); $res = $sqlconn->complexQuery("Select", "SELECT * FROM Mixes WHERE MixName = '{$songsMixTitle}'", 'Mixes'); $mixid = getMixId($res); $res = $sqlconn->complexQuery("Select", "SELECT SongId FROM MixSongs WHERE MixId = '{$mixid}' ORDER BY SongId", 'MixSongs'); $songids = getSongIds($res); foreach ($songids as $songid) { $res = $sqlconn->complexQuery("Select", "SELECT * FROM Songs WHERE SongId = '{$songid}'", 'Songs'); $songs[] = getSong($res); $startTimes[] = getStartTime($res); } $args = array('VideoId' => $songs, 'StartTime' => $startTimes); $xml = createXML('Songs', $args); return $xml; }
/** * 获取每一页中的产品名称和url3 * @param $pageUrl */ function getProductUrls($pageUrl, $brandsArray, $keyword, $withoutFilementKeywordXMLName) { ob_start(); //打开输出控制缓冲 ob_end_flush(); //输出缓冲区内容并关闭缓冲 ob_implicit_flush(1); //立即输出 $xmlFileName = 'xml/' . $withoutFilementKeywordXMLName . '.xml'; $html = file_get_html($pageUrl); $ulsdiv = $html->find('.s-result-item'); //获取ul // $productUrls = array(); $index = 0; foreach ($ulsdiv as $li) { $title = $li->find('h2', 0)->plaintext; $productUrl = $li->find('a', 0)->href; $brand = trim($li->find('.a-color-secondary', 1)->plaintext); echo $brand . '-----' . $title . '<br/>'; //存在关键词则认为是打印材料,添加到对应品牌xml文件,否则添加到丢弃文件 if (containsKeyword($title, $keyword)) { //品牌存在,则说明该品牌的xml文件已经存在,直接将该产品添加到对应的xml文件中,否则新建品牌xml文件 if (in_array($brand, $brandsArray)) { addToXML($brand, $brand, $title, $productUrl); } else { createXML($brand, $brand, $title, $productUrl); $brandsArray[$brand] = $brand; } } else { if (file_exists($xmlFileName)) { addToXML($withoutFilementKeywordXMLName, $brand, $title, $productUrl); } else { createXML($withoutFilementKeywordXMLName, $brand, $title, $productUrl); } } // $productUrls[$index] = $productUrl; sleep(1); ob_flush(); //输出缓冲区中的内容 flush(); //刷新输出缓冲 } return $brandsArray; }
function syncMixAndSongs($sqlconn, $titleSync, $emailSync, $datetimeSync) { $titleSync = str_replace("'", "\\'", $titleSync); $res = $sqlconn->complexQuery("Select", "SELECT * FROM Mixes WHERE Owner = '{$emailSync}' AND MixName = '{$titleSync}'", 'Mixes'); $mixid = getMixId($res); $res = $sqlconn->complexQuery("Select", "SELECT * FROM Songs WHERE TimeAdded = '{$datetimeSync}'", 'Songs'); $songids = getSongIds($res); $table = 'MixSongs'; $queryType = 'Insert'; $condition = null; $types = array('integer', 'integer'); $columns = array('MixId', 'SongId'); for ($x = 0; $x < count($songids); $x++) { $values = array($mixid, $songids[$x]); $args = array('column' => $columns, 'value' => $values, 'type' => $types); $xml2 = createXML($table, $args); $res = $sqlconn->query($xml2, $queryType, $condition); } echo "Mix created!<br/>"; echo "Go to the <a href='' class='linkbutton' id='myMixesLinkFromCreate'>My Mixes</a> page to play your mix."; }
function syncMixAndSongs($sqlconn, $titleSync, $emailSync, $datetimeSync) { $titleSync = str_replace("'", "\\'", $titleSync); $res = $sqlconn->complexQuery("Select", "SELECT * FROM Mixes WHERE Owner = '{$emailSync}' AND MixName = '{$titleSync}'", 'Mixes'); $mixid = getMixId($res); $res = $sqlconn->complexQuery("Select", "SELECT * FROM Songs WHERE TimeAdded = '{$datetimeSync}'", 'Songs'); $songids = getSongIds($res); $table = 'MixSongs'; $queryType = 'Insert'; $condition = null; $types = array('integer', 'integer'); $columns = array('MixId', 'SongId'); for ($x = 0; $x < count($songids); $x++) { $values = array($mixid, $songids[$x]); $args = array('column' => $columns, 'value' => $values, 'type' => $types); $xml2 = createXML($table, $args); $res = $sqlconn->query($xml2, $queryType, $condition); } }
function deleteValuesFromTempTable($emailDelete, $sql) { $table = 'TempUser'; $queryType = 'Delete'; $condition = array('Email', $emailDelete, 'text'); $types = array('text'); $columns = array('Email'); $somevalues = array(null); $args = array('column' => $columns, 'value' => $somevalues, 'type' => $types); $xml = createXML($table, $args); $res = $sql->query($xml, $queryType, $condition); }
function writeXML() { $datei = fopen("authors.xml", "w"); $result = createXML(); fwrite($datei, $result); $ref = $_SERVER['HTTP_REFERER']; header("Location:" . $ref); }
function checkIfUserExists($emailCheck, $sqlconn) { $table = 'UserInfo'; $queryType = 'Select'; $condition = array('Email', $emailCheck, 'text'); $types = array('text'); $columns = array('Email'); $values = array(null); $args = array('column' => $columns, 'value' => $values, 'type' => $types); $xml = createXML($table, $args); $res = $sqlconn->query($xml, $queryType, $condition); $checkValues = getValues($res); if ($checkValues . "" == strtolower($emailCheck) . "") { return true; } else { return false; } }